This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am looking at to allow users to edit data stored in airtable, without being airtable users. I know how I can do this with form, or with mini extension but I am looking for a solution that would allow user to see all the data in a table, and be able...
I am working a field trip application to organize field trips for my school. Airtable is definitely game changer for this!
I met a problem on my budget tab:
For each grade I have a total budget
I can select the trip record from another TAB on a colum...
I need to calculate automatically the number of chaperones I need for a field trip.
If I have 1 to 30 students, I need 3, 30 to 60, 6, etc… The calculation is: {#of stduents}/30*3. The number is an integer. But if I have 31 students, it gives me 3 as...
I have a student assigned to a homeroom in the column “current homeroom”. I am adding a checkbox “Withdrawn”. I would like to do this:
IF the student is withdrawn THEN move the value from “current homeroom” to “homeroom 22-23”.
The result being: cell...
In Airtable i have students information including a unique student ID for 600 students in a view called Master class showing students from Pre-K to grade 4.
I need the 600 students data information to sync with z Google sheet.
I have created a scenar...
I have done it with a form too in the past, but with the quantity of data I have for this application, it will be way too cumbersome. I think I will use Google Sheet, Make.com to automatize the sync with Airtable. Thanks !
Thanks for your help. My explanation was not clear, of we need 3 chaperones for 30 students, which means we need 4 for 31, 4 for 40, 5 for 41, 6 for 50, 59, and 60.
The formula that works for me is this one: ROUND(({# Students}/10+.49)
