Hello:
I have list of rows with month as one of the column. I need to create an action, which will let the user to select a number of rows and then duplicate those rows but changing the month according to the modal input value that user sets during the process.
I have no idea how to do it.
First, create a new table named UserInput with a column NewMonth to capture the user’s input for the new month. Next, go to Behavior > Actions and create an action for your main table to duplicate rows by setting it to “Data: add a new row to another table using values from this row.” Then, create another action to update the month column using the value from the UserInput table.
After that, create a grouped action that includes both the duplication action and the update month action. Set up a form view for the UserInput table in UX > Views so users can enter the new month value. Finally, create a bot in Behavior > Bots to trigger the grouped action when a new record is added to the UserInput table, running the grouped action on form submission.
This setup allows users to select and duplicate rows while updating the month based on their input, ensuring efficient data management.