Using only last entry for formula use


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?

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

1 Like

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

1 Like

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

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.