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:
Fields: Starting Script Page Number, Scene Title
Fields: To Do, Priority, Script Page Number, Scene Title LINK
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.
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.