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

    User input data as search criteria

    RowlandPentyGeraets

      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