If you would like to update an existing record via form, this is one of the options:

My preferred way before I learned Javascript was to do this by using a partially prefilled form that creates a record in an “update” table linked to the record which needs to be updated. Then use several “update record” automations to update the destination record. Each field should likely be separated into its own automation, other wise you may update a field with a blank input.

Alternatively, you could use a script action! You will need some Javascript know-how, but this will not require the prefilled form. You can first search all of your records in a view with the original student records and find the destination record based on the Memberstack ID. Then you can update the record with only those fields which have been updated.

If you need help setting this up feel free to reach out :slightly_smiling_face:

@Paul_Warren1 - I ended up going down this same partially prefilled form route to submit to the “updated profile” table. I skipped updaing an airtable record in the “new members” table and just went straight to updating the webflow CMS item.

Interested to learn more about the javascript option though - I feel this would save me a lot of time!

My full use case is a directory listings membership site for the dating industry using webflow/memberstack/airtable and zapier/integromat. Free for singles to browse listings & contact businesses and businesess pay a fee to list themselves. We use at least 25% of each membership fee to pay for facebook and google ads!

@Moe - I’v looked at your extension a few times as it fixes quite a few issues I’ve come across but it’s just too expensive for this project

Hi @Charlie_Spokes, Thanks for sharing this. I am working on a directory listing website and stuck on this. can you share more details of your solution? Do you mean a user to update details through updating details on WebFlow OR Memberstack?

Hi @Rupesh_Patel,

1.A user can create a paid account on my site using memberstack.
2.This creates 2 unique memberpages (one public facing and one private, accessible only by that client)
3. The private page has an airtable form with the webflow user ID prefilled. When the form is submitted, it creates a new line in my “updated members” table & triggers integromat (using watch records then search record) to find that record in my “new members” table & update that member in both Webflow CMS to update the private and public members page.

It’s not the most elegant solution but it works fine!

The easiest & best way to do this is by using Fillout’s advanced forms for Airtable, because it lets you update Airtable records directly from a form.

In your case, as soon as a member fills out a “new record form” for the first time, their new record will be created in Airtable, and you will send them an automated email that gives them a special URL. This special URL will enable them to update their record in Airtable by using an “update form”.

You can see how to set this up in my video below, which also shows off many other advanced techniques using Fillout:

• Using Fillout to create an eSignature approval process with PDF file creation.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, display Airtable lookup fields on forms, create new linked records on a form, control access to a form via SSO or email domains or a list of email addresses stored in Airtable, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show off some other advanced features of Fillout on this Airtable podcast episode:

• Using Fillout to create an order entry form with line items.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld