I have a CSV file delivered weekly with information about grant opportunities. I've been importing this file into Airtable, however, many of these grants include multiple submission deadlines throughout the year so I'm struggling to find the best way...
I am mapping out the content in an academic program with the following levels:Program ObjectivesCourse ObjectivesModule ObjectivesAssessmentsI have a separate table for each of these levels.Starting at the bottom, an assessment in one of the courses ...
I have a list of records that's something like this. PROJECT NAMEPROJECT VERSIONCONTACTASSIGNEEApples1JoeBobApples 2JoeBobBananas1SallyJimOranges1JoeJudyI receive a .csv report with the most recent information about the first three fields every week....
https://airtable.com/apprdPguzaBCfjD56/shroyWamJGrG0yeMiIn the sample base above, I have two linked Tables. One is a list of projects, the other is information for a quarterly report. Currently, I am linking the tables to each other manually when upd...
I would love to have Airtable help me to map out the prerequisites for an academic program but I'm having a little bit of trouble. Imagine a list of courses - some are required for the program, some are electives, etc... Many of these courses have pr...
Let's see if my awful drawing helps. The top section shows how records are linked to each other across Tables. Apples records are linked to Bananas. Bananas to Oranges. Oranges to Lemons.What I'd like Airtable to give me, is a flow chart that allows ...
Hello again, Scott. A base schema isn't quite what I'm looking for. Attached is an example that might help. I created this one by putting everything all in one Table and linking records in the same table (program, course, and module objectives). This...
I'll check it out, thanks. I've been trying my hardest not to leave Airtable and rope in another app.One thing I just thought of but haven't tested yet, would be to create a new text field and have an automation copy the formula field (e.g., "Apples1...
That did the trick. I was able to create an automation with three separate Find Records blocks (since you can't do conditional grouping within Find Records). The first identifies the Quarter the start date falls within, the last identifies the Quarte...
