Here is my use case. I have a table with content for a letter. Each row represents a paragraph in the letter. The order of the paragraphs is controlled with an [Order] column that takes a number.
By default each rowโs [Order] are an incrementing multiple of 10. New content can also be placed in between existing rows, e.g. an [Order] value of 21 will put that paragraph between the paragraphs with [Order] values of 20 and 30.
What I would like to happen is to have these values rebase whenever a new โin betweenโ [Order] value is introduced (either by an add or edit).
For example: There are three existing rows with Order values of 10, 20, and 30. Two new records are added with values of 21 and 25. Upon sync, a workflow is triggered and everything is rebased to multiples of 10, like this:
Has anyone done something like this? Any ideas for how I can approach this better? My main desire is to avoid a situation where these values become too crowded and adding or reshuffling paragraphs becomes very cumbersome.
Solved! Go to Solution.
@Steve, thanks for pointing me in the right direction. The โadd across datesโ example was particularly insightful. Iโll definitely give this a crack in the weeks to come.
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |