Curious if anyone has an idea for this one, I’d like to use an unsorted table view (or did) to move items up and down and calculate their visible row number and put it in a row field. (basically I want to have a unique and intentional sort order that I create by dragging and dropping. Any ideas? Th…

[image] anadin: calculate their visible row number This is not possible in general, since View filters can change which entities are displayed – so in different Views, a particular entity’s “row number” could be different (and it might not even be displayed). Within a script you can access t…

Both list view and the new grid view allow drag and drop re-ordering. Out of interest, why do you want/need to get the position (number) of an entity in a given view and put it as a field value for each entity?

Related [image] How to access entities' "natural sort order" in Rules/Buttons/scripts? Get Help Entities can be (re)ordered manually via dragging (i.e. in a Card or List view). How can such entities’ relative order be determined or set in a Rule/Button/script? …

I was thinking about something similar to build my card-sort Grid View (yes, needs a different name). Technically, if I give an entity X and Y number single-select fields, I could use those on a Board View as coordinates and then drag cards around as I want. Only problem is that new numbers aren’t …

So I want to do this for export reasons we are using a DB as a data source for a game. Due to the nature of adding/removing items over time the DB is not in the right order so I can’t use their unique id. We are willing to drag and drop things into an order in one view and the copy that row order in…

Calculating a unique row int (not unique ID)

Get Help

Chr1sG August 9, 2023, 7:02am 3

Topic		Replies	Views
How to access entities' "natural sort order" in Rules/Buttons/scripts? Get Help	11	624	February 8, 2022
Formula for number in list view Get Help	9	566	April 18, 2023
Row order change of database Ideas & Features	2	124	April 29, 2025
Allow sorting by Rank in Table views Ideas & Features table-view	3	401	June 9, 2023
Can we translate the ranking number to a normal number? Get Help	3	242	July 14, 2023

Calculating a unique row int (not unique ID)

Related topics