Guys, I’ve had great success using Airtable for another project, and am thrilled with its functionality. Now I’m trying to map student progress on lessons. The lessons are given according to student readiness, not to a whole class, so each child moves at his own pace. There are still some benchmarks for approximately when a child is expected to receive them, though.
I’m attaching a screenshot of how I handled this in Excel. I used a formula to highlight which lessons were possibilities according to each child’s age. But in Airtable, I can’t seem to do something like this. I’ve added like 8 fields trying to get it to just reference the freaking age that I’ve already put into the Student table. Is there not any way to do a formula referencing a field in a different table?!
Did it in Excel, how to do it here

Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.