Hi! Sending formatted mails from automations is great! Thanks for adding this feature!
A litte glitch: Using Links from fields with {column name} doesn’t seem to work:
● When we create such dynamic links, the dialog where you enter the URL jumps to an empty page
● Our workaround was to create a fixed link, then copy this one, and modify it, entering {column name} as the (dynamic) link URL
Doesn’t work: The placeholder {column name} is never substituted with the actual Link URL from the column.
All we can do now is insert {column name} directly into the text, which makes the link non-clickable text in the resulting mail. Creating a proper link would be nice.
Again: Functionality is great, and this is just a minor glitch.
If we support “{a-link-column}” to be replaced by a clickable link (instead of plain text) in the email template, do you think if it can meet your need?
@daniel.pan Hey Daniel, we’ve got a similar problem.
We are using placeholder in our emails like {email} {first_name} etc. but the placeholder is not getting replaced in the sent email.
Hi, I now re-checked this issue in 5.0, and it has improved (a bit ;-).
Use case: I want to dynamically change part of a link in an email with the content of a column that triggers the mail (automation / button). Or, more precisely, I’d like to pre-fill a seatable form that is opened when the user clicks of the link in the E-Mail.
The use case in complete steps:
I create a new user with name “FIRST LAST” in Seatable
With an automation, a mail is sent with the content:
Hello User {name}
we just registered you. Please fill out this form to tell us more about you:
https://seatable.mydomain.com/dtable/forms/custom/prefilled/?prefillForce_name={name}
Clicking on the link opens a form with the “name” field prefilled with the user’s name. This is for convenience, and to make sure the User’s name provides a consistent link from the user input to the registration record in the other table.
This is what I found out in Seatable 5.0.7
Partly works with mail text in plain text
Depends on the recipient’s mail client whether the URL is clickable
{name} needs to be urlencoded by hand - since there is no formula functions, I do the main replacement like “substitute({name},” “,”%20")" somewhat clumsily
Barely works with Rich Text mail
Only if the link is not treated as a link, but as text
That implies that a link text cannot be set - the URL is visible as in plain text
The rest like encoding and the dependency upon the mail client to be able to click on the link is the same.
In a perfect world, Seatable would have a nice function to include column values into a URL, urlencode them, and show a nice, clickable link with a nice link text.
