my next hurdle is, how can i limit someone from creating a timecard under someone elses name? as mentioned, we use forms to create a timecard, and our current set up has a drop down menu where the user selects their name from a drop down menu. i can get of this field altogether, but there are several dependencies tied to it that i cant risk losing. hiding the field from user view wont work either because the field is then left blank, which also affects the data coming from these dependencies. any suggestions?
So after you enabled the toggle that captures the email of the submitter, this info gets stored in the Created By field. From here, you can create an automation that copies the Created By field to your Name/Collaborator field. Doing this will let you hide the dropdown field while ensuring it still gets filled in every time.
The trigger would be "When a Form is Submitted" and the action would be "Update record".
I don't know how familiar you are with automations in Airtable so if you need more explanation, I can walk you through that as well.