Hello everyone,
I would like to create a button in my Seatable application that generates a direct link to a web form with a preselected record linked to that button. The goal is for the user to be directed straight to the web form with the appropriate record already selected, avoiding the need to manually choose it.
Is there a way to achieve this functionality? If anyone has experience with this or knows how to set it up, I would appreciate any tips and suggestions!
As far as I know, unfortunately it won’t be that easy:
first, because I think prefilled values is currently available only for standalone forms, not for forms in App (maybe I’m wrong but I couldn’t find this option in the app/form settings)
second, because a link column can’t be directly prefilled. So you’ll have to use a workaround, like creating a new text-type column in the table related to your form, that you’ll be able to prefill and that will allow you to identify a unique date. I prefer using the ID’s row, but as it will be displayed on the form, maybe you’ll prefer to use the TerminNr but careful : you can only use this column if the content of this column is actually unique (one single value for one single row). If you do so, you’ll also need an automation rule (not available in every plan) or a script run to fill the actual link column from the content of the text column
Depending on what you need, you could however create a simple link for each date row:
Create a standalone form (using the Forms button in the top right corner (between Apps and Statistics) in which the text column will be displayed and required, whereas the link column won’t be present
Get the public URL of the form (for example by clicking the Form page button in the top right corner of the Form editing page), which should look like "https://cloud.seatable.io/dtable/forms/THE-ID-OF-YOUR-FORM
Add a new formula column in your Dates table (let’s call it URL for example), with the following formula (assuming here that you’re text column contains the TerminNr value and is called TerminNr as in the dates table. If it’s not the case, you’ll have to change the name in the URL, but not between the curly braces, the TerminNr between the braces being the name of the first column in the dates table as shown in your screenshot): "https://cloud.seatable.io/dtable/forms/THE-ID-OF-YOUR-FORM/?prefillForce_TerminNr=" + {TerminNr} (don’t forget to use the actual form URL by replacing THE-ID-OF-YOUR-FORM!)
Configure your Buchen button to open an URL, this URL being contained in your URL column
Then, when a new form is submitted, you’ll need (with an automation rule or a manual script run) to create the actual link between your booking and the date, using the text column (here TerminNr) to find the corresponding date.
Not sure if this is clear (actually almost sure it’s not ) but still, hope this helps. Don’t hesitate to ask me to clarify if necessary!
Bests,
Benjamin
PS: using ?prefillForce_ in the URL will make the prefilled value read-only. If you want the user to be able to change it (read-write), you can use ?prefill_ instead, but in this case my example won’t work as it’s a text column and not a single-select one, so the user can definitely enter something that is not the proper TerminNr of a date row…
) but still, hope this helps. Don’t hesitate to ask me to clarify if necessary!