6 Replies Latest reply on Nov 13, 2016 8:39 AM by philmodjunk

    Pre-fill find operators via script

    BillR_1

      Users regularly search a time billing database for all entries from a "date start" to a "date end" (The start and end dates need to be separate fields, because some work could extend over two or more days). To search for a range (i.e. a week of time) users enter ≥ (a particular start date) and ≤ (a particular end date)

       

      I'd like to shortcut the find operators step for them, so they don't have to figure out how to enter "≥" and "≤". The following script almost does it, but it doesn't complete the last line. I'm presuming that's because Filemaker thinks the search would be for nothing, with the ≥ (0) and ≤ (0) because there is nothing after the operators in the fields - even though I didn't tell it to perform the find. Is there a way to make this work?

       

      Thank you.