Appogee

Text Field Insists on Adding Up Numbers Placed In It?

Discussion created by Appogee on Nov 18, 2015
Latest reply on Nov 18, 2015 by 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.

Outcomes