Link to next lowest number

Topic Labels: Base design
568 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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.