Hi everyone !

After reading formula guide, I have few questions regarding what’s doable with Airtable (i’m not really familiar with Excel formula, so any advice is welcome).

I’m working in a training center for Maternal assistant and life assistant for dependant person. We have various training that last from 14 hours to 35 hours. Each year, these trainee have 58 ! hours of free training. We use Airtable to follow the subscription process and to know which training they choose. It is important for us to know how many free hours they still have.

For now, we use 3 tables for that :

- First one is a database with Trainee ID, the training they’ve choosed this year, their remaining free hours
- Second one is our subscription table : fields are grouped by training dates AND training - we use it to check if we have all the pieces for the subscription
- Third one is a “training database” : We have all the training names, teachers and hours for each… I created it to link the content to the first and second tables

We follow their remaining hours on the first table.

My questions are :

- Can I create a formula that associate a number of hours for each training ? ( What I mean is that on our third table, we have each training and their duration - Can I link them or must I redo it in the formula ?)
- Can I create a formula which automatically upload their remaining hours according the training they choose? (If X training is putted, which last 14 hours, then the next column goes from 58 hours to 44 hours)

Sorry for my frenchie english I hope this was clear enough.

Thanks all !