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!
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.
Expanding on @ScottWorld’s suggestion:
This limits the possibility of data entry errors and user effort.