Adding multiple invoices per client: one or multiple form submits?

Ask for Help
1

Hello. Im trying to add multiple dates to a row in a way that the calendar shows each date.
to explain:
I have multiple clients that make monthly payments, and i would like to see the date of each payment on the calendar . For example, client 1 payment today, one month from today etc…
would this be possible? or i need to create a row for each payment?

… And if this is possible, how can i make the form to add the payments, is it possible for automatic calculations? ex. client 1 will do 21 payments, calculate each date per month
thank you in advance

2

If you don’t have to many fields in the form to add an invoice, I feel that creating a new row for each payment in the easiest approach.

3

I understand, but i have something like 200 clients, some of them with 21+ payments, i could do a form for each payment, but in terms of work/ time ratio, i would like to avoid it

4

That sounds to me like the most straightforward approach too. I would resort to Make, loop through the info 21 times to add 21 rows. They have this repeater module that I think would be useful.

image

5

But would this add the dates? i mean, would it calculate the date for each month? our would it be better if i somehow try to code it ? the problem for me is that the callendar only has start and finish dates.

I’m sorry, my english is so rusty atm.
Thank you in advance

6

Yep, when you use the repeater, you can use its value to ride the date calculation.

https://www.make.com/en/help/tools/flow-control

Say you start with a date of 1st May, then every iteration of the repeater, you can have a function to calculate the date like:

addMonths(original date; repeater number)

image
image892×276 22.4 KB

2 Likes
7

Thank you very much for your help sir.

1 Like
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.