OK, I’m about a week or so into using Coda for real work…
I am attempting to use Lookups where possible in a sort of relational database type manner.
Whilst Lookup functionality works rather well, I cannot (yet) figure a way to filter the selection of Lookup.
Imagine this scenario:
I have a table of companies
I have a table of contacts which uses a lookup reference to link a contact to a company
I have a table of factories that has a lookup to a company, BUT I would also like a lookup to a contact…
I do not want to have to choose from 1000’s of contacts when I have a lookup to the contact table. It would be far better to limit the possible contacts to only those who belong to a specific company (namely the one already chosen in a different column).