Skip to main content
Solved

Using only last entry for formula use

  • June 6, 2022
  • 3 replies
  • 22 views

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?

Best answer by ScottWorld

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

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • June 6, 2022

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


  • Author
  • New Participant
  • June 6, 2022

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


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • June 6, 2022

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: