Help

Sorting in "chronological" order

Topic Labels: Automations
Solved
Jump to Solution
574 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeffpdoes
6 - Interface Innovator
6 - Interface Innovator

I’m trying to figure out how to keep a View sorted in a chronological order.

Initially, a client fills out a form online which collects their pertinent info and adds them to my database. After discussing the needs of my client they send me a deposit to get on my waitlist. I have set up a “Waitlist” View in my base that filters clients based on whether or not I have received a deposit. I would like the “Waitlist” view to be sorted in the order that deposits are received.

Ideally, when I receive a deposit, I enter it into the “Deposit” field, which automatically adds it to the “Waitlist” view. How do I keep this view sorted in the order that deposits are added (or in the order that they are added to the “Waitlist” view)?

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Jeffpdoes!

Create a “Last Modified Time” field, and set it to ONLY update when you update the “Deposit” field.

Then, you can sort by that field. Airtable will put all the empty ones at the top, but you can filter them out of your view or just ignore them.

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Jeffpdoes!

Create a “Last Modified Time” field, and set it to ONLY update when you update the “Deposit” field.

Then, you can sort by that field. Airtable will put all the empty ones at the top, but you can filter them out of your view or just ignore them.