Sort a list by re-occurring ref views

[ivannewman]

I'm making an app where you can create an account for a person, and then record a visit with the persons account and date of visit.

I have it set up so that when someone visits, I can go to a form view, select a date, and then select the account that visits, and then add it to the records (creating a new account when they've never visited before).

I have 2 tables set up: "Accounts" that stores all the info like Name, Number, Address, etc. ; And a "Records" table that references that name on the "Accounts" table and then creates a new row with the reference and the date. Hence, recording the visit.

MY QUESTION: I want to be able to have a deck view called "Accounts" that shows all accounts created AND organize it by the number of visits by each account. I'd like to be able to show the number of visits by each account name as well. I have the deck view set up but I can't for the life of me figure out how to organize the view by the number of visits.

I'm very new to Appsheet and I have little to 0 coding experience. If there's any code I need to put in please tell me where to put it. Thanks

[dbaum · Accepted solution]

---

@ivannewman wrote:

I want this sorted alphabetically:

---

Wherever the list of values is defined (e.g., maybe in the column's Valid if property) include a SORT or ORDERBY function to yield the order you want.

---

@ivannewman wrote:

I want this sorted by number of visits. So the account with the most visits appears on top:

---

Control row sort order - AppSheet Help