Airtable: adding new linked record ovewrites previous one with Update record

[Pedro_Silva]

Hi!

I have these 2 tables:

Candidates:

Attachment:

The tables are connected through the attchemnts field. Each candidate can send various files through email and the candidate record is supposed to record all the files in that field.

The scenario idea is to:

1. read candidate email
2. create candidate record
3. store the files in google drive
4. create 1 record for each file in the attachments table
5. update candidate record with each of these files

The problem is: the last update ovewrites the previous one, so i can’t append one record to the field. I’ve tried various map and add functions combinations with no success.

Any idea how to overcome this?

Thank you!

[Pedro_Silva]

Got it