Transferring values to other tables when email address matches

Hi @Bandersnatch,
Welcome to Airtable! If you have the students information in a different table than your Form data, you can link the records and use a Lookup field to bring in the score to the students table.

Or you can use an Automation to update the record in students table.

If you want different behavior for existing email, use automation. trigger by form submission, then ‘Find Records’ with the same email
then use conditional actions

length means list of records found. if 0, add create record action using data from submitted record. if >0, do nothing (you can even delete submitted record, but that needs a bit scripting)

sometimes, when you take new record data, automation triggered after record created, but before all data filled, so you can receive empty ‘total score’ field - it was filled a millisecond after automation launched.
to avoid such accidents, use another trigger instead, based on a value you need. for example, when record matches condition (total score not empty)

Than you very much, this is very helpful :slightly_smiling_face:

I want to prevent cheating. Is there a way that I can prevent duplicate submissions when the email already exists in the table associated with my form? Or some kind of workaround that will achieve the same?

I tried but couldn’t make it work. The actions should be
form is submitted → score is calculated in the quiz table → this core is synced with a field with the score in the user database IF email adress submitted in the form and email adress in students table match…

Thank you very much!