Hey there! Let me explain the problem:
I want to create an action that allows me to pick a date, and duplicate rows that already exist with different dates, based on that one I chose before. Basically, the purpose of this action is distributing a pack of tasks across the user calendar, based of the date that decides to start.
Let´s say I pick 09/29/2023 as the date. Then, I want the copying action to create several new rows (I tell appsheet which ones with a SELECT() function) and that their respective dates are, for the first row created, the date I chose (09/29/2023) and after that, they have to add 2 more days for each row that follows. This means I will have the next result:
1st row copied: 09/29/2023
2nd row copied: 10/01/2023
3rd row copied: 10/03/2023
...
And son on.
I hope I explained it correctly.
Thanks a lot!
LinkedIn
Twitter
