How to move/appear Records to the top of a table

Support, Troubleshooting, & Help
, ,
1

I’m making an app, and I need to prioritize a field variable so that when it appears, it will be filtered/sorted to the top. Is there any way I can make it so that the table will make the fields with the desired variable appear at the top without making the rest of the records filtered out?

While I am aware I could make another table where the filtered variables could appear, but for aesthetic purposes I would like to avoid that.

Any help would be appreciated.

2

do you have an exaple dataset for both (the one that should appear at top and the one for the bottom)?

I gues that sounds like an easy job for “sort by”…

3

Hi Jade,

You can put the rows you care about at the top by using Sort By on the Interactive Table.

  1. In the table, add a field called Priority (Number or Boolean).
  2. When the row meets your condition, set Priority = 1 in a trigger; leave others 0.
  3. Open the Interactive Table’s settings. Click Sort By.
  4. First sort by Priority in descending order.
  5. (Optional) add a second sort on another column for tie-breakers.

Every record stays visible; those with Priority = 1 simply appear first.

See:
Create fields – Tables
Sort tables – Interactive table widgets

Let me know if any step is unclear.

4

Hello! I used the info from this thread to apply it (it worked). I used numbers before the entries, and this is how it turned out:

  1. Ready For Inspection
  2. Pending
  3. Complete

I wish there was a way to make custom sorting in these situations where it would make more logical sense to put it in the order of " Pending, Ready, complete" but at least it works. Maybe they will put it in a future update.
Thank you for your advice!