Duplicate multiple row coming from same table

Hello all,

I would like to duplicate few rows on the same table.
I use Appsheet for my budget management.
I have both table 
Expenses

Capture d'รฉcran 2023-11-04 215304.png
Budget

Capture d'รฉcran 2023-11-04 2203434.png

Budget have a Ref_ROWS to key Date on Expenses
Capture d'รฉcran 2023-11-04 2155024.png

Every month, i do my budget and a new date is created,
each time i imput Tags manually in table expenses.
If its possible i would like these Tags are duplicate and add new after the old with new key date.
I tried with both actions, but im not comfortable with this code.

Thanks for helping me

Herod

 

Solved Solved
0 6 1,176
1 ACCEPTED SOLUTION

What do you have set as the Key for the Expenses table?  I see above its the Date column but if that were the case then you'd have a duplicate key issue.  Did you change it?

Also, why is Date a Ref type value?

In the Duplicate Budget Rows action you need to adjust the Date for the rows being added.  Otherwise, you are adding exact duplicates and depending on how you have the key set, AppSheet will remove the duplicate row.

View solution in original post

6 REPLIES 6