Hello all. Sorry if this is a duplicate quest...

(Tony Carlisle) #1

Hello all. Sorry if this is a duplicate question. I looked briefly and didn’t see it.

I have a simple database of dates, fname, lname, item1, item2. I normally add names from the app, but I don’t see a way of sorting them into alphabetical order on the app so I do it on the spreadsheet, but when I sync the app it doesn’t show them in the order I want.

The other issue is that if I have a duplicate fname I get an error message and so I have to add a number to the name. How is it that I can’t enter two people with the same first name into the database? Otherwise I love this app.



Hi @Tony_Carlisle Check out key columns. You may need to change yours as it sounds like you may have Fname as your key. help.appsheet.com - What is a Key? What is a Key? help.appsheet.com

(Aleksi Alkio) #3

@Tony_Carlisle In generally, you can sort the order from the table’s definition. The option is called as “Sort by”.

(Tony Carlisle) #4

@Lynn Thank you

(Tony Carlisle) #5

@Aleksi_Alkio Thank you