Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 01, 2024 01:48 PM
Hi! Below is a screenshot of what my current interface looks like, and the two fields in question are highlighted yellow.
I thought these two fields would allow my team to add new contacts and update existing ones respectively. However, when this form is submitted, a new row is created regardless of which client option my team fills out. Rather than new information being linked to an existing client through the use of the drop down menu, a new row is created. Is there a way to make this distinct function for each of these fields?
Thank you!
May 01, 2024 04:46 PM
It seems like you essentially need two types of forms.
One to update, and one to make a new record.
You already got the new record form sorted. As for updating, you could use the "open record details" option and make the fields editable.
Have a look at this workaround I made:
https://community.airtable.com/t5/show-tell/update-record-through-form-sorta/td-p/179052
You might be able to configure this to do what you're looking for?
May 01, 2024 06:46 PM
If your users don't have Airtable accounts and you still need them to be able to update records, Airtable has a guide for that here: https://support.airtable.com/docs/use-case-update-records-via-a-form
It's for the old form view, but the logic still applies. Might want to look into Fillout.com as well as that'd just work right out of the box
May 02, 2024 04:29 AM
There are 3 great workarounds for this limitation:
1. On the first form, give the user a link to the other form which will add new records to the linked table.
2. On the first form, in the linked record field, give the user an option to choose from that is called "new record" or something like that. Then, conditionally show additional fields where they can type in the new information. Then, use an automation to add the new record into the appropriate table.
3. Use Fillout's advanced forms for Airtable, which has this functionality natively built into its forms. Fillout offers about 500 advanced features that aren't natively available in Airtable's native forms.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
May 02, 2024 07:02 AM
I get what you are saying! That brings up a follow up question. Is there a way to make fields in the "open record details" page ONLY editable by the assignee for that record?