AnsweredAssumed Answered

Way around limitation in use of variable in scripted find?

Question asked by Order_from_Chaos on Nov 27, 2011
Latest reply on Jan 31, 2013 by ErikWegweiser

I have been excited to adapt some of my scripts to use the newly supported use of variables in the find script step. One issue that I've run into is that if I set a variable to a value of NULL with "", it becomes undefined. If this value is then used in a find script step, it is not expanded so that FileMaker states that no records exist for this query since the search term becomes "$VariableName". I run into this issue when I want to search by multiple criteria and some of them may vary well be empty. Is there a way to define a variable as having no value but not be undefined so that FileMaker will still expand the variable in the appropriate search field?

 

Brett

Outcomes