Are you wanting to run this just one time to link them all up or is there some sort of a trigger that you would want to trigger the automation?
If this is a one off, try:
1. Make the primary field of the "Plants" table the "Plant ID" field
2. In "Events", in a view where no records are hidden, click the field header of the field that contains the plant IDs
- This selects the entire column
3. Hit CTRL / CMD + C
4. In "Events", in a view where no records are hidden, click the field header of the linked field to "Plants"
5. Hit CTRL / CMD + V
This will link everything up
--
For new data, if you can leave the primary field of the Plants table as "Plant ID", then you can create an automation that'll trigger when new "Event" records get created, and their action would be to paste the "Plant ID" value into the linked field, which would link stuff up for you automatically
If you cant have "Plant ID" as the primary field, then you'll need to create an automation that'll do a "Find Record" step followed by an "Update Record" step, and Airtable has a guide for that here: https://support.airtable.com/docs/linking-existing-records-using-automations
Are you wanting to run this just one time to link them all up or is there some sort of a trigger that you would want to trigger the automation?
No this will be an ongoing process to track scheduled events. As I upload records of newly scheduled Events, I would like them to automatically link to their respective Plants. The trigger would ideally be something along the lines of "If new Events added, link to Plant based on Plant ID". If that isn't an option and it ends up being an automation run at a certain time each day, or if I need to manually trigger the automation, that is fine. I just don't want to manually link every Event to a Plant.
