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
I have taken out the " in front of Right now it works fine. Thank you so much
Left ( Field1 ; 2 ) & "\"X" & Middle ( Field1 ; 3 ; 2 ) & "\"x" & "Right ( Field1 ; 2 ) & "H"
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
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...
I'm not sure I understand, but in the layout next to the field, you can put "LBS".
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
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.
Thank you so much
Retrieving data ...