Nov 01, 2020 01:31 AM
I’m trying to set up an airtable automation to update an existing record in a table “new members” after that member submits additional information through the airtable form I’ve embedded on my website.
The form is set up to automatically add their Memberstack ID to the new submission so I can match it to existing records and use this to update them but I cannot get the automation to work as it seems to be based on the Record ID field, not Memberstack ID.
Can anyone help me out
Thanks in advance
Nov 11, 2020 04:08 PM
Nov 11, 2020 06:39 PM
If you need help setting this up feel free to reach out :slightly_smiling_face:
Nov 11, 2020 11:38 PM
@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.
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!
Nov 11, 2020 11:39 PM
@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
Nov 19, 2020 03:08 AM
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?
Nov 20, 2020 01:24 AM
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!