I don't really know if the Title really explains my situation, but here it is..
I have Four Fields: Name, Gender, Class and Policy
Policy Field is an Unstored Calculation with the calculation below with result set to Text
If ( Gender = "Male" & Class = "Primary"; "RUNNING" ;"EXPIRED")
Meaning, my intention is to Set the Policy field as Running, if the Student is Male and in Primary Class, otherwise, it should be set to Expired..
The calculation does not work, some fields are displayed correctly with the correct value while others are not.
However, if I remove the Logic "&" from the calculation making it only a single criterion, If ( Gender = "Male" ; "RUNNING" ;"EXPIRED"), then it works well..
Why can't I compare several fields using "&" or "OR" with that function?
Is there a better way of actualizing this?
I am importing a csv file and need to use matched field names when importing: the provider of the file adds fields from time to time. However one of the field names in the cvs file ends with a space and when managing field names I do not seem to be able to define a field name which ends in a space. Every time I do the field name has the trailing space removed when I save it. Does anyone have a solution?
Thanks in advance.
After moving to FMP advanced 13 I still don't know how to automatically add a new field in the current layout I work on.
Before it was simple but now I always need to drag the icon into the layout in Layout mode.
Is there a way to tell the app to ALWAYS add new fileds to the current layout
Thanks a lot
I am currently using the StartingPoint Template for my business.
My current problem that needs solving is I created a few new fields and portals on the estimates module in which I must manually put a customer Reference Number, portal created for showing the Cubic meterage, and a calculation field which calculates the total cartons needed as a result of the Quantity input and the Master carton qty.
The problem enters when I "move to invoice" it does not relay all the information from Estimates to the invoice module. I am struggling for the answer, having tried creating portals (perhaps I am not setting up the portal correctly?)
Any guidance on this would help greatly!