Nick Ashcroft 9/24/2018 5:41:46 AM
I have already implemented something similar with up / down buttons but it is not ideal. Indeed, as you say, its OK if you dont mind records with duplicate ranks since pressing one of the buttons up or down will just remove or add 1 to the rank so making it the same as its 'neighbour'. What I want to do is swap the rank of the 'neighbour' with the selected item rather than make it the same.
Problem is that it is not possible using a 'record change trigger' to also update other records, which is what is needed to update the 'neighbour' as well as the record being moved.
Other option I thought is to rearrange the list using the buttons and then 'select all' using a multi-record button and add a 'reorder' button but Teamdesk has no idea of the order to apply !
It would be nice if there was a built-in function where you could identify the position of a record in a view and use this somehow in the button assignment with a multi-select update.
Alternatively, another kind of record trigger which updates all matching records in a table and not only the current record. I know there are time and periodic triggers but theses are no good in my use-case.
other creative suggestions welcome ;-)