Using only last entry for formula use

[Louis_Colas]

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?

[ScottWorld · Accepted solution]

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

[Louis_Colas]

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

[ScottWorld]

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