Jonathan_Gunne1 - profile

Jonathan_Gunne1 · May 07, 2024

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...

Jonathan_Gunne1 · Apr 03, 2024

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 ...

Jonathan_Gunne1 · Dec 06, 2023

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....

Jonathan_Gunne1 · Nov 30, 2023

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...

Jonathan_Gunne1 · Oct 24, 2023

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...

Jonathan_Gunne1 · May 07, 2024

Nope.

Jonathan_Gunne1 · Apr 04, 2024

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 ...

Jonathan_Gunne1 · Apr 04, 2024

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...

Jonathan_Gunne1 · Dec 06, 2023

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...

Jonathan_Gunne1 · Nov 30, 2023

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...

User Statistics

User Activity

Converting Multiple Dates in a Single CSV Cell Before or After Import

Visualize Linked Relationships - Flowchart

CSV Import Merge Issues

Automate and graph quarterly data based on start and end dates.

Academic Program Map - And/Or dependancies

Re: Visualize Linked Relationships - Flowchart

Re: Visualize Linked Relationships - Flowchart

Re: Visualize Linked Relationships - Flowchart

Re: CSV Import Merge Issues

Re: Automate and graph quarterly data based on start and end dates.