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.