Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Using only last entry for formula use

Topic Labels: Base design
Solved
Jump to Solution
246 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,

I’m designing a database to help manage my client base. I created a main table (let’s call it Table A), for the clients and other tables (table B, table C) for data that I measure over time. I need to make calculations (result = table B/Table C), but only with the last data entered in those tables (B and C).

Is there a way to get only the last data entered for a given client?

1 Solution

Accepted Solutions

That’s relatively tricky to pull off in Airtable. I discuss how to do it in this video podcast:

See Solution in Thread

3 Replies 3

That’s relatively tricky to pull off in Airtable. I discuss how to do it in this video podcast:

Wow! Thank you very much! It works. I would have NEVER figured it out by myself

You’re welcome! You might have figured it out on your own, given enough time! :stuck_out_tongue_winking_eye: