Mar 09, 2023 09:02 AM
Hello, I am trying to update an existing record with a form without it creating a new record. I have attempted this several times using automation but I am having no luck. Any suggestions?
Mar 10, 2023 04:45 AM
Form submissions will always create a new record, so the best you can do is delete the newly created record after you've used the data in it.
Do you have a Pro plan? If so, you can add a "Run a script" action and write some JavaScript that will delete the form submission once you have utilized the data in the form submission to update the existing record. There are some examples of the code that can accomplish this in the forums and you can search for it
If you do not have a Pro plan then you could attempt to use a third party tool with some JavaScript to delete the record the form submission created
Dec 07, 2023 10:06 PM
A workaround is to use a form that integrates with Airtable. We have built a form allowing you to edit a record in Airtable.
https://miniextensions.com/miniextensions-form-for-airtable/
Using a formula field, you can generate a unique URL for each record and opening this URL will allows you to update existing record.