I have created a multiple choice quiz (following this guide Self Grading Quizzes With Airtable). I have setup a field with the total score of all correctly answered questions for each student. I want to transfer this value automatically to another table into a field that is associated with the same email address as in the quiz table each time a new form is submitted. Ideally I also would like to achieve that another submission from the same email address is ignored and not transferred a second time.
I am still very new to airtable and unfamiliar with the correct terminology. I hope this was understandable.
Thank you for your help!
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)