May 28, 2021 08:19 AM
I am working with a client that is using several different forms in a table, and they want to tag submissions with which form is filled out. In other words, if someone fills out form #1, the record that is created indicated that form #1 was filled out. If form #2 is filled out, then the record indicates that form #2 was filled out, etc.
I am sure there is a way to do this, but I can’t figure it out for the life of me!
Thanks in advance!
May 29, 2021 08:22 AM
Welcome to the community, @Rob_Kissner!
Unfortunately, that’s not possible with Airtable, which has very weak/limited form features.
In general, when it comes to Airtable, you’ll always be much better off by using a professional form building tool like JotForm, which has native integration with Airtable.
However, if you’d like to stick with Airtable’s forms, the only way to do this would be to create additional fields in your database (one for each form), and add each one of these new fields as a required field onto each one of your forms. It could be as simple as a checkbox or something like that. It needs to be required on the form, though. Then, after the user submits the form, the very presence of a value in that field would indicate which form the record came from.
You could also add automations — one for each field — that would change the value of other fields based on the presence of a value in those additional fields.
May 29, 2021 10:09 AM
Based on @ScottWorld, This is the only solution if you wan’t to stick with AirTable. Other wise you can use some third party tools and achieve it.
May 29, 2021 11:33 AM
Expanding on @ScottWorld’s suggestion:
This limits the possibility of data entry errors and user effort.
May 29, 2021 11:53 AM
May 29, 2021 11:55 AM
Thanks so much for the insight. I agree, Airtable’s form features are a bit lacking. The client would ideally like to stay in Airtable, so I will definitely experiment with your suggestion.
May 29, 2021 12:01 PM
This is interesting — I didn’t know that this was a feature available in forms. This is why Airtable needs to give us an ongoing log of changes to their product. Everyone is left to their own devices to discover changes on their own.