Hello!
I’m stuck with a schema/data model problem. My whole scenario is rather large, but I have specific issue to tackle: I’m iterating through an array containing Airtable record IDs. For each element in that array (=airtable record ID) I look up the fields/values of that airtable record and then I create 1 corresponding record in a different airtable table. However, if specific field in that original airtable record contains the value 1, i want to create TWO corresponding records.
I guess i want to nest two iterations: Iterate over all records in the initial array and for each record, check field X and if field X is empty, create only one record, but if field X contains a value, create two records. Bonus: While the first record will be a copy of the initial record in a different table, the second record will be identical to that apart from one field, which shall have a hard coded value).
I guess it’s completely clear what i mean