Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automatically linking records by date

Topic Labels: Automations
Solved
Jump to Solution
4662 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
Kamille_Parks
16 - Uranus
16 - Uranus

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

See Solution in Thread

3 Replies 3
Abdulrahman_Alz
6 - Interface Innovator
6 - Interface Innovator

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.

Kamille_Parks
16 - Uranus
16 - Uranus

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

Thank you so much!!!