Hey!
I have an Airtable base that collects new sales with the dates and amount of payments that the client is going to do (1, 2, 3, 4, etc).
I want to dynamically create several records on an Airtable base depending on how many payments the client is going to do. For example:
- Client pays in full, just create 1 record with that one payment’s date and amount.
- Client pays in 3, create 3 records with each individual payment date and amount.
I do this to keep track of payments and see when a payment is pais or how many payments are still left to be paid.
In Make, i am using a Search Record → Set multiple variables (create array of dates and payments) → Aggregator to create 1 array → Iterator to separate dates and payments → Create Record.
The problem is that it only creates 1 record every time and I want it to be dynamic, meaning that I want it to create as many records as payments the customer is going to do.
Any ideas?
PD: Número de Pagos = Number of payments // Fecha de pago = Payment Date // Importe Pago = Payment amount
The following flow only creates 1 record on Airtable:
Hi @Alejandro_Panos,
it seems like you have different payments all in one table (Pago 1, Pago 2, Pago 3…).
Let’s say you leave it as this.
I’d actually set it up simpler than your current approach.
You might use the Watch Records as you have it but afterwards you simply have a Router.
Then you have multiple ‘Create a Record’ modules and the filter for each is “If Pago 1 exists” → create record, “If Pago 2 exists” → create a record, “if Pago 3 exists” → create a record…
Your Airtable seems to have a maximum number of payments so I don’t see a need to make your scenario unnecessarily dynamic. 
Hope it helps!
Best,
Richard
1 Like
@Richard_Johannes thanks for your feedback!
I was actually thinking of doing that because, even if I had to add 6 payments, it would not be that much of a headache. I guess I just wanted to be as optimal as possible.
Let’s say I went with the approach of making it dynamic (which in this case I won’t). Do you have any idea of how to go about it so that it creates a new record each time?
Yeah I think in that case it would be best if your database would have a different design.
I.e. instead of having 6 columns “Pago 1, Pago 2, Pago 3…” you’d have linked fields. Then you would iterate through the linked fields.
In Airtable you could maybe have a field to show ‘next payment’ or ‘number of payments’ to have the similar information available to you in the table
Cool! What do you mean by linked fields exactly?
Within Airtable you have one table ‘Clients’ and then a second table ‘Payments’: Linking Records in Airtable | Airtable Support
This would enable you to have unlimited payments and not only the pre-defined columns (i.e. 6 payments).
I see. Thanks a lot @Richard_Johannes for your help it is much appreciated!
1 Like
