I have a single table in my base which has 5 forms. Each of those 5 forms is filled out by a different group of users at various stages of a review process. They all answer some variation of the same assessment, with a slightly different wording of questions plus or minus a few fields.
There is a single select field in the table (not shown in the form) that denotes the status or “Review Type” provided by which groups. For now, that is a manual field that I am selecting after a review comes in. (They are fairly sequential in process, so easy to determine which “type”.)
Is there a way for Airtable to auto select the “Status” on an entry (from a list of single select choices) based on which form the entry was submitted from?