My parent table has a column (Survey Status) to indicate the status of that record.
At this point I ask my users to manually update the status of old records from Latest to Previous.
But of course after only a few surveys I end up with multiple Latest records as Latest is given upon creation and my users forget to update the old record.
I donโt blame them itโs not user friendly.
How can I make it so that when I create a new record in my table the column (Survey Status) value of the previous record will be updated from Latest to Previous?
Iโm pretty sure itโs an easy solution but I canโt get my head wrapped around it.
Solved! Go to Solution.
I think that you need to use automation. Follow the steps on the image. Inside โRun a data actionโ you can set different types of actions about the rows of your table. Inside Events, you can set the data change type trigger. Finally, inside Bots, create a new one and choose the event that trigger the process you create.
I think that you need to use automation. Follow the steps on the image. Inside โRun a data actionโ you can set different types of actions about the rows of your table. Inside Events, you can set the data change type trigger. Finally, inside Bots, create a new one and choose the event that trigger the process you create.
Took me some messing around with the actions but I got it somewhat working.
Thanks!
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |