Jun 25, 2020 10:58 AM
Hello! I am trying to figure out a way to link 1 column of records to multiple tables. For example, I have a master list of students on one table and have additional tables of info that I would like to link to the master list so that when I add or delete a student on the master list, it adds or deletes that record on all of the other tables. Is there a way to do this?
Jun 25, 2020 11:53 AM
That is not possible, because Airtable has no automations built into the platform. Everything in Airtable is triggered manually by the user.
If you wanted to fully automate this process, you would need to turn to On2Air: Actions, which works in conjunction with Zapier. On2Air Actions is the only tool available which triggers automations based on deleting records.
If you don’t care about the deletion of records, you could turn to Integromat, which I consider to be the vastly-superior platform to Zapier.
p.s. If you have a budget for your project and you’re looking to hire an expert Airtable consultant to help you out with this project, feel free to send me a private message! :slightly_smiling_face:
Jun 25, 2020 03:40 PM
Welcome to the community, @Mollie_Turbak! :grinning_face_with_big_eyes: If you really want a multiple-table solution, then @ScottWorld has great ideas. However, tracking different info for the same students across multiple tables isn’t very efficient. I suggest putting everything into a single table, and using filtered views to control what’s seen at a given time.
I teach an online class, and that’s how I have my class database set up. I have one table named
[Students] that contains all student info, and that table has about a dozen different views. One view is where I enter all key student info: first name, last name, student ID, etc. Another view is where I keep track of the grades for extra credit challenges they’ve submitted. A few other views are used for more complex grading in certain weeks of the course. All told, I’ve got 80 fields used in various ways across all views, but it’s all for the same set of student records. When I’m looking at the record for John Smith in the main data view, it’s the same John Smith record that I see in the Extra Credit view, only with different fields showing.
To read more about using Views in Airtable, check out this page:
Jun 25, 2020 03:54 PM
Very true what @Justin_Barrett said!
@Mollie_Turbak, I never considered the possibility that your tables might not be setup properly to begin with. Be 100% sure that you have the proper database & table structure for your system, to make your life much easier moving forward! @Justin_Barrett has given you some wonderful information & resources.