2 Replies Latest reply on Jul 10, 2014 6:09 AM by philmodjunk

    User input data as search criteria



      User input data as search criteria




           I am very new to filemaker so i apologise if the solution to this question is simple.


           I am trying to create a dialogue box which prompts the user for a number of days, i.e. 30, and then performs a find which returns any records which have a value of less than 30 in the field "time remaining".

           Using old posts on this forum I have been able to return records where "time remaining" = 30, but not "time remaining" < 30. This is what I have:



           Enter find mode []

           Show custom diaglog["search for upcoming actions....      ]

           If[ Get( LastMessageChoice) = 1 ]

           Perform Find []

           End If



           The way this is done, there doesn't seem to be a suitable place to insert a < operator.


           Any help would be much appreciated