I’ve seen this question asked but not answered, so here’s my try at it.
I am emailing over 300 authors an update to a contract and collecting their e-signatures. I made an airtable form for this (e-sig as a check box). I would like my “Authors” profile table to update automatically as responses roll in from the form. I didn’t include a dropdown linked to “Authors” because I don’t want everyone to see who else is enrolled. But otherwise, I have to manually link each new record to the ‘authors’ table. Is there a way to use a unique ID (their email) to automatically link the record? Screenshot:
I then have the Authors table pulling from the Agreement Responses. Essentially, I want to be able to quickly determine who has signed the contract and who hasn’t.
Any help is much appreciated. Thanks!