4 Replies Latest reply on Nov 18, 2015 9:04 AM by Appogee

    Text Field Insists on Adding Up Numbers Placed In It?

    Appogee

      Hi all, I'm new to Filemaker and hoping you can help me understand and work around what seems to be a strange behavior...

       

      I have a field (MyDatabase::TextField) in a database which I have defined as a "Text" field.

       

      I place the number 3 in it .   So far so good.   I can see "3" in there.

       

      Now I want to update MyDatabase::TextField so that it contains "3,1". 

       

      The "1" comes from a different Text field (MyDatabase::DifferentField).

       

      I use a script with the following syntax:

      Set Field [MyDatabase::TextField; MyDatabase::TextField + "," + MyDatabase::DifferentField]

       

      Instead of seeing the expected "3,1",  the field MyDatabase::TextField instead shows "4".

       

      What am I doing wrong?

       

      Thank you in advance for your guidance.