3 Replies Latest reply on Apr 30, 2013 11:37 AM by philmodjunk

    Set field problem

    justjoker

      Title

      Set field problem

      Post

           Hello,

           I'm trying to write a date range find script but get a problem with Set Field syntacsis. It always says that an operator is expected here (see the screenshot attached).

           I'm sure, I'm doing something wrong. Please, help.

            

           Serge

      FileMaker_Pro_Advanced_2013-04-30_09-28-16.png

        • 1. Re: Set field problem
          philmodjunk

               When Setting up Set Field, there are two Specify buttons that must be clicked. To get Set Field [Table::Field ; Expression], add set field to your script and click the first button (specify target field). Select Table::Field from the list of fields. Do not click the specify button next to the repetition box. Click OK to close this dialog box. Now click the lower specify button (calculated result) and create the expression to the right of the semicolon (;). Do not try to type in the semicolon.

          • 2. Re: Set field problem
            justjoker

                 I've specified target field at Set Field as MyTable::DateTime

                 I'm trying, to create the expression:

                 Globals::gStartDate &...& Globals::gEndDate

                 but get the pop-up window "This number cannot be evaluated".

                 What Am I doing wrong?

                 Serge

                  

            • 3. Re: Set field problem
              philmodjunk

                   The ellipsis is text and should be enclosed in quotes:

                   & "..." &

                   You may be interested in this thread. It provides a number of examples of setting up scripted finds using global fields and the set field step: Scripted Find Examples