2 Replies Latest reply on Sep 9, 2011 4:41 AM by willrollo

    Simple If question

      Title

      Simple If question

      Your post

      Hi

      If I want a script to occur if a field is empty, then how do I go about this?

      I wrote this:

      If ( Type = "trade" ; Company ;  First Name & " " & Surname )

      The field is called 'Type'. If the word "Trade" is put in the field then I want the 'Company' field to show whatever name the user has entered for company. If there is nothing entered, then I want the first and surname entered automatically...

      Any ideas? I know the answer is a simple one but I jsut cant find where it explains this in my mssing manual book..

      thank you

        • 1. Re: Simple If question
          TSDuck

          Hi will rollo:

          Thanks for posting.

          You can use the following script steps to enter the first name and surname in the company field if the type field is blank.

           

          If [IsEmpty ( tablename::Type)]

          Set Field [ tablename::Company; tablename::FirstName & “ “ & tablename::Surname]

          End If

           

          This will check if type is empty, and if so sets the company field to the values in first name and surname.  Let me know if you need any further detail.

           

          TSDuck

          FileMaker, Inc.

          • 2. Re: Simple If question

            great - thank you. wil be posting more quesions so thank you for your patience and help!