14 posts in this topic
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
By Philip Curtis
I am new to the forum and new to FM-Pro14. I have been knee-deep reading books and tutorial videos on it for 2-3 weeks so far.
I am stuck on a problem and I can not find any documentation. I wonder if someone can help. I am guess this is an easily solution and my beginner status is the problem <;
When I create a new button, or modify the existing button, it keeps reverting back to being part of a Group. I have 'Arrange-->Ungroup' many times without success.
When I go back to Browse mode and click the button, all fields are selected.
When I go to Layout mode and select the button alone, then select 'Arrange-->Ungroup' (it greys out-temporarily), the Right-Click and select 'Button Action'-'Single Step', I continually get a message saying the button is part of a group.
When I select all fields while in Layout mode and then select 'Arrange-->Ungroup', it is greyed out which tells me they are not part of a group. But back in Browse mode selecting the button selects all fields.
I've been doings circles with this without resolution. Whew!!
Is it possible I did something incorrectly when I first started by dragging all the fields at once onto the Layout from the Field Picker?
BTW, the problem is associated with this text:
Attach a button definition to an existing object or objects, like text or a field Select the object(s) and choose Format menu > Button Setup. If you select multiple objects, select only objects that have no previous button definitions. FileMaker Pro groups the objects when you define them as a button. See Grouping and ungrouping objects. If you attached a button definition to an existing object, you can only use an action for the button, so skip to step 5. https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.47.html https://www.filemaker.com/help/14/fmp/en/html/edit_layout2.11.16.html#1192005 I have read and re-read these pages without resolution. The message I get is the button can only be used for an action. But I have not 'attached a button defination to an existing object' Where can I see the status of this? Am I on the right track here? Thanks again, Phil