Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automatically linking records by date

Topic Labels: Automations
Solved
Jump to Solution
1565 3
cancel
Showing results for 
Search instead for 
Did you mean: 

The Background: My kid’s school needed a Daily Health Survey that parents/faculty/staff/volunteers need to fill out every day, and I said I would help and now I’m stuck. I created a JotForm which dumps data into an Airtable base, and I use automations to create one big table that has all the individual pieces in it.

The raw data goes here: https://airtable.com/shri5YgdoGt16lZGH
The automations create this: https://airtable.com/shrgmvNxk4fWEwlYX

The Problem: the principal of the school would like to be able to print out a sheet of paper every day that has the names of the students/faculty/staff/volunteers on it and their clearance statuses. So:

Pablo Picasso - Cleared
Zoey Beckmann - Not Cleared
etc

This is a great use for the Page Designer Block (I think), but in order for me to do that, I need to figure out a way to automatically link all of the records for each date to a single record in another table, and that’s where I’m stuck.

Any advice? Thanks so much.

Yikes Screenshot

1 Solution

Accepted Solutions

One of the winners from the recent Blocks Contest was “Link Records by Fields” by Patrick Sier.

See Solution in Thread

3 Replies 3

We made an Airtable extension to solve this problem: https://miniextensions.com/auto-link-airtable-records-by-view-id/

You can create a view in your linked table that has a filter so that it only includes the records with the dates you want. Then, the tool will automatically link those records to a record that you can use the Page Designer Block on.

One of the winners from the recent Blocks Contest was “Link Records by Fields” by Patrick Sier.