Skip to main content

Formulas

  • March 13, 2024
  • 3 replies
  • 13 views

Forum|alt.badge.img+3
  • New Participant
  • 2 replies

Hello to all, im trying to create a table in order to control and track the days off of the employs. The first row is exactly what i need. But the team takes days off in different dates during the year. So if i put new dates in the second row, airtable discounts again the days from all. See the pic below. We have 28 days per year, 12 are in stable dates so the team needs to use 16 throughout the year in the dates they want. i need in the first column second row to be shown 6 remaining days not 14. is this possible to do or the air table doesnt have this capability? I hope i explained myself well. Thank you!!

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Ah, you can't reference another row (record) via a formula like that I'm afraid.  You're going to need to create a linked field and link them appropriately.  Airtable has a guide on how to create linked records here: https://www.airtable.com/guides/build/connect-data-with-linked-records

I've also put something together here for you to check out, and this is how I would try to handle leave tracking

You'd have a taable where each record is a single person:


Then you'd have a table where each record represented a single block of leave taken:

Because the records are linked together, I can use a rollup field to sum up the total number of days taken by that person, and then use a formula to find the remainder


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 2 replies
  • March 13, 2024

Thanks a lot!!!ill try it now


Forum|alt.badge.img+8
  • Inspiring
  • 22 replies
  • March 13, 2024

We built out the EXACT same function for one of the workspaces we manage.  Email me if you'd like the template, happy to share.  kurt@adbm.agency