How to Update Existing Airtable Records via Softr Form (Without Login)? + Updating Multiple Tables

Ask the community
1

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! :raising_hands:

2

Hey,

  1. Yes, softr forms concept is only for creating new records as well as airtable forms.

If you have no trouble prefilling personalized data links for each of your users, why not use prefilled airtable native forms to update your records? (it requires an automation to handle the update)

  1. There is no form service that will update records from different tables in one go. This requires integrating webhooks after form is sent, or setting up logic in your backend to handle this need.

If the experience you are looking for is necessarily updating a record via a custom url form with no logins, no prefills, or extra headaches you can consider bringing fillout forms into your softr app. Awesome service.

3

Hey, I’m having the same issue (updating an existing record in airtable without login.

How did you solve this?

4

Hi everyone

For this use case, I would offer using a junction table in the datasource (e.g. Airtable), which would only serve to collect the newly submitted records from the form. Then I would use our Softr Workflows, and trigger the automation with Record Added trigger. Then I would find the relevant records in the other tables with Find record steps (multiple actions if there are more than 1 tables to find records in and to update them), and since there will be prefilled data in the form such as the email address, I would use it as an identifier to find the correct records that I need. Then I would use the Update record action and update them as I need. In the end, if needed, I could delete the record from the junction table with Delete Record step.

5

I came across this older discussion and wanted to add that if anyone has explored any new integrations or tools lately to simplify this process, it’d be great to hear about them. Anything that might minimize complexity while meeting the no-login requirement could really benefit the community. Has anyone tried alternative solutions or new automation services that work well with Softr and Airtable?