I’m looking for a way to determine which course a customer purchased first. The problem is that each course has it’s own table. (I REALLY wish we could restructure this and put all course enrollments are one table but we there is an obstacle I don’t think we can overcome.) So it breaks down to ther…

[image] Using a formula to get the earliest/latest date across several fields Tips & Tricks Sometimes you want to know the latest date across several fields. [image] While there are many ways to do this, I present one way that works with date/time fields as well as dat…

[image] Alisha_Sadeski: I was picturing a really long nested if statement formula comparing dates to work out first course purchased. It’s not you; I have a hunch it’s the data model, :wink: specifically the lack of a transaction register. Imagine a [flat] list of every course purchased, the …

Using a formula to get the earliest/latest date across several fields Sometimes you want to know the latest date across several fields. Yep, and when a new course is added, new fields are added, and then it’s off to the races to re-scale the system. Any formula dependencies on existing and al…

This is amazing! You always have all the answers! It gave the earliest date. Woo-hoo!! I really didn’t think this was going to be possible. And then I wrote a formula to translate that into which product was the first. Thank you so much!! [image]

[image] bfrench: then it’s off to the races to re-scale the system Yup. I agree that a different scheme would be better. But Alisha said that she already wants to do this but cannot right now. And I’m on my phone with only one hand available right now, so I thought I’d just answer the questio…

[image] bfrench: What am I missing? The obstacle we have comes down to the course platform the client is using - Mighty Networks. It’s horrible to work with. They don’t have open API. The few zap triggers they have are basically useless. They don’t make it easy to access data. Regular manua…

[image] Alisha_Sadeski: it would be alot of work for her to do all that. Understood. So, you could back into the transactional list using a script process that generates the missing ideal table.

@Alisha_Sadeski Just an FYI that the process you described regarding importing the CSV files could be easily automated with Make.com , and it would also give you significantly more functionality than what you’re getting right now from Airtable’s CSV Import tool. You could even fully automate the proc…

Ahhhhh!!! I use Make alot. But this is not a use case I ever thought of (or knew was possible). :exploding_head: I just went and played around in Make! I had never even noticed the csv tool before. I just set up a simple little test. It worked and was super smooth and fast. This is so good to know.…

That’s great to hear! Glad I could help! :blush:

[image] Alisha_Sadeski: I use Make a lot. But this is not a use case I ever thought of (or knew was possible). Make is very powerful, indeed. Imagine a different approach that requires only your data and one API call to OpenAI that costs about 1/60th of a penny. Given this GPT query: [Cle…

Formula to compare 6 dates and determine which was first

Airtable Questions Fields and Formulas

Kuovonne April 3, 2023, 12:27am 3

Topic		Replies	Views
Using a formula to get the earliest/latest date across several fields Tips & Tricks	10	1784	October 4, 2024
TODAY() Optimization Question Airtable Questions	2	44	August 12, 2024
Roll up to derive the latest edit in Rich Text field Fields and Formulas	5	343	May 22, 2023
promptGPT() Sadly Doesn't Exist Scripting	22	641	April 19, 2023
List your top Airtable feature requests here! News & Announcements	146	4696	October 1, 2025

Formula to compare 6 dates and determine which was first

Related topics