AnsweredAssumed Answered

User input data as search criteria

Question asked by RowlandPentyGeraets on Jul 10, 2014
Latest reply on Jul 10, 2014 by philmodjunk

Title

User input data as search criteria

Post

     Hi,

      

     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

      

     R

Outcomes