I’m new to using Glide, but currently building my first app. I’ve run into a challenge, which I hope you can help me solve!
Short description: When I add one row with data, I want an identical row of data to be added to the sheet, with some adjustments (i.e. change a date in one column).
Long description: I am building a service inspection report app, where a technician should be able to enter data for a completed service. Currently, each services corresponds to one row in the sheet. I have a column called ‘stage of service’ and would like to add a button/action, which creates a duplicate row with the same data for Service X, when that row has been marked as ‘Completed’. This new duplicate row would then be an ‘Upcoming’ service, which will be put in the calendar for the next inspection.
Let me know if it is necessary to elaborate on the above!
I think I understand most of your points, however, how would I automatically ‘Paste any data of current row to the new one, including the new date’?
This is specifically the challenge that I have. When I add an ‘add row’ action button, it just takes the data from the first row in the datasheet and not the specific row which the user has just added (e.g. row 10 in my snip above).
I would have liked that when a user ‘Adds a row’ (i.e. row 10 in my picture), there would be an option within the ‘add row’-form to add a duplicate row which would then be the follow-up service. Now, the user would need to add a completed service and then subsequently locate that service in the list and press ‘Add follow-up service’.
I would have liked a button here, that duplicates the row with the ‘date of next service’ defining the row 11 ‘date of service’:
Of curse, what you need is called “On Submit” action, you can found it in General on that same from screen, just add “Add row” action. Remember the Date has to be the newDate math column calculate.
But, it will make the row automatically and no just when stage is “Completed”, as the form will create two new forms with “Incomplete” stages.
That seems to do the trick - now an additional row is automatically added on submission. Only ‘challenge’ that I am left with is the User Experience when pressing Submit and they don’t get a ‘Success’-notification.
Any way to add two ‘On submit’ actions, so I can both have an ‘Add row’ as you suggest and a ‘Show notification’?
