Skip to main content

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!

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 oTasks] table.

Reply


Terms & Conditions