Hi everyone,
I’m looking for advice on updating existing Airtable records through a Softr form, and I’m running into two main issues:
The Setup:
- I’m building an app in Softr connected to Airtable.
- Each contact has a unique email address, which can be used to identify them.
- I can easily create personalized links to prefill fields or filter data—this part works fine.
- The contacts don’t have Softr user accounts, and I want to avoid requiring a login.
My Main Problems:
1. Updating an Existing Record in Airtable Through a Softr Form (Without Login)
- Softr forms always create a new record instead of updating an existing one.
- I need a way for users to edit/update their existing contact record, identified by their email address.
- I do not want them to log in or create a Softr user account—just click their link and update their data.
- Is there a native way to update an existing Airtable record in Softr, or is there a workaround (e.g., via automation or filtering)?
2. Updating Two Records in Different Airtable Tables from One Form
- I need the form to update data across two related tables in Airtable (e.g., contact data in one table and property data in another).
- Is it possible to use a single Softr form to update two Airtable records in different tables at once?
- If not, what’s the best approach to handle this (automation in Make, Airtable Automations, something else)?
What I’m Trying to Achieve:
- The buyer fills out a form that updates their contact details (Table 1).
- On the same form, they answer a question about property usage (Table 2), which should also update the linked record in another table.
- I want to keep it simple: no logins, no extra steps for the user.
Any advice or proven workflows would be a huge help!
Thanks a lot!