I send outlook email notifications from Airtable Automations to my staff to update records in Airtable as per below screenshot.
However, for external users I want them to click on a link where they update records via a form in Softr.
How do I insert a link like the below but instead direct users to the form relating to the record ID within Softr?
e.g. I want my users to approve orders and add purchase orders
Hi @FPX
I was facing the same challenge for new user’s registration (new records in Airtable) and what I did was to create a page in Softr open to non-logged users.
Hi @FPX at the moment, our conditional forms don’t support that. But you can create a detail page instead that you send your users too and they can update the details for the record that you include in the URL there.
To create the URLs you may have to use some formulas in Airtable though to prepare each of the links to be sent in your emails to contain the record IDs.
Softr’s form block, won’t let you update records. But you can collect the data entered into the form and pass it to make, to update the record on airtable.
The record id value can be set as hidden field on your form, and with this id, make, can look for the record id on airtable and update the desired values.
Another alternative is to integrate fillout forms, then you can have a link to a form, that can edit any record you wish on your table, without worrying about softr user sessions.