I have a row for each day of the week for each store in my company. I want my user to be able to change all the open/close hours with one input, whether thats a form or a button that copies the hours from the current selected row to the other days of the week for that store. I havenโt found a way to pass values to multi row edits. The execute an action on a set of rows was my first idea but I donโt see a way to set the value of a different row based on current row for multiple rows.
Solved! Go to Solution.
Can you change the data design at all? My first impression is that maybe the Days should be columns in a single row. This would allow you to use a Virtual Column switch, e.g. โCopy to All Daysโ that when set, copies the hours from the first day automatically into all the other days right in the form all in one shot.
If the data design needs to remain as is, meaning the store hours need to be rows by day, then it is still doable. My first thought is again to set a flag, โCopy to All Daysโ, in the form so that when this day row is saved, you can inspect this row to see if the flag is set. If so then have your Workflow call an Action to do that โexecute an action on a set of rowsโ. You can identify all the rows that need โcopied toโ where the flag is BLANK. The row to โcopy fromโ is where the flag is TRUE. When done, reset the flag for the next edit.
I hope this is clear but if not just let me know
Can you change the data design at all? My first impression is that maybe the Days should be columns in a single row. This would allow you to use a Virtual Column switch, e.g. โCopy to All Daysโ that when set, copies the hours from the first day automatically into all the other days right in the form all in one shot.
If the data design needs to remain as is, meaning the store hours need to be rows by day, then it is still doable. My first thought is again to set a flag, โCopy to All Daysโ, in the form so that when this day row is saved, you can inspect this row to see if the flag is set. If so then have your Workflow call an Action to do that โexecute an action on a set of rowsโ. You can identify all the rows that need โcopied toโ where the flag is BLANK. The row to โcopy fromโ is where the flag is TRUE. When done, reset the flag for the next edit.
I hope this is clear but if not just let me know
User | Count |
---|---|
42 | |
25 | |
24 | |
19 | |
15 |