Calculated Value Lists

Idea created by Dhrakar on Oct 28, 2015
    Duplicate
    Score1
    • jbante

    Rather than have to create relationships and custom fields for a value list, it would be great to either be able to use the calculation engine directly to define a value list, or use a variation on the ExecuteSQL() step.  For example, if I needed all of the company names, I could use ExecuteSQL( "SELECT co.id, co.name FROM co WHERE co.region = 'west'").  Since the calculation would be constant for the whole session, FileMaker could pre-compile it when the file loads in and it should be pretty fast.