Ranking and change order of the rows in the spreadsheet

[jansaamszoon]

Hi, what a nice platform is Appsheet. I like ti very much.
I’m developing a project management app to line up projects in a pipeline.
For this app, the ordering of the projects is important as that reflects the order of the projects in the pipeline.

I like to give the user the opportunity to change the order of the projects in the pipeline by pressing an arrow up or down (of one place up, or once place down), or giving the opportunity to move between two projects or before or after a specific project.

How to best approach this? How can I change the order of projects (or an ordering number) in the spreadsheet in response to an update in the app?

Thanks a lot!

[Steve]

jansaamszoon:

How can I change the order of projects (or an ordering number) in the spreadsheet in response to an update in the app?

Not possible from AppSheet.

[jansaamszoon · Accepted solution]

Hi Steve
thanks. Ive found a workaround by keeping track of the rank in the spreadsheet, and doing an update on two records to swap the rank number. A bit slow and not very robust but kind of works. For a proto type fine right now.
Thanks. You are doing a good job helping so many people in their journey. very much appreciated

[Marc_Dillon]

Dinamic ordering of rows - virtually ordering rows by clicking on up/down arrow within table view Questions

Hello everyone, I have the folowing question: I am trying to make it possible to order some values dynamically. I have a row with some names and their sequence (order) in a list, see below (f.e. in a competition where people are frequently having a certain particular position, that might change over time). What I want to achieve is when I manually click on the up-arrow, the row should move up - when I manually click on the down-arrow the row should move down within the list. So the order no…