Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jun 21, 2021 04:21 AM
Hello, Filemaker user here, and I’d love to learn how to re-create some functionality so I can use airtable. This database is for the entertainment industry:
Table: Scenes
Fields: Starting Script Page Number, Scene Title
Example data:
1,Exterior House
30,Interior House
50,Exterior Office
Table: Tasks:
Fields: To Do, Priority, Script Page Number, Scene Title LINK
Example Data:
Set Dining Table,High,5
How do I link this tasks to its appropriate scene? Page 5 of the script is in scene 1 because scene 2 starts on page 30. In Google Sheets, Excel, and Filemaker, no extra work is needed, Lookup will return the correct, previous value without “going over” to the next record.
Thank you!
Jun 27, 2021 12:12 AM
Welcome to the community, @Nick_Solyom! :grinning_face_with_big_eyes: The link field itself doesn’t create the ability to automatically access content from the linked table. Links are made from record to record, and most often these links must be made manually. However, automatic linking could be possible using an automation that runs a script, though it would need to be carefully designed to prevent accidental triggering as you’re editing the page numbers in the [Tasks]
table.