8 Replies Latest reply on Apr 3, 2013 8:13 PM by anthonyb

Field input

I have been given the task of finding how to get the calucaltion field to automatically transform 121212 to 12"X12"x12H in the dimension feild and I cant seem to get it right can some one lead me in the right direction

• 1. Re: Field input

Left ( Field1 ; 2 ) & "\"X" & Middle ( Field1 ; 3 ; 2 ) & "\"x" & "Right ( Field1 ; 2 ) & "H"

• 2. Re: Field input

I have added: Left ( Dimension ; 2 ) & "\"X" & Middle ( Dimension ; 3 ; 2 ) & "\"x" & "Right ( Dimension ; 2 ) & "H" but I am getting a warning "H" can't be found

• 3. Re: Field input

I have taken out the " in front of Right now it works fine. Thank you so much

• 4. Re: Field input

You have been so helpful....could I bother you with one more question in the weight field how can I code the feild to automatically know the weight is in LBS...

• 5. Re: Field input

I'm not sure I understand, but in the layout next to the field, you can put "LBS".

• 6. Re: Field input

Thank you so much again...I am trying to figure out why the spaces are not showing am I missing something is the / mark for spaces and then it will not allow me to do 12.5" can you sugguest a cure Please

• 7. Re: Field input

The backslash key is an excape key that says ignore the next character for purposes of the calcultion function.  Say you want to put a Double Quote in a field, how will you do this?  You have to put double quotes around anything you are putting in.  If you put a double quote within two double quotes, you get """.  But that won't work, because it sees the middle double quote as belonging to the first double quote.  So you have to escape the character and the way you do this in FileMaker scripting is "\"".  This will results in a single double quote being saved in the field.  So if you want to have the number 12.5 followed by a double quote, you would have to do something like   NumberField & "\""    and this would become 12.5" in the field.

1 of 1 people found this helpful
• 8. Re: Field input

Thank you so much

1 of 1 people found this helpful