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.
