Can't overtype in a calculation field once in browse

[Cradders]

Hiya,

Is it possible to do this? Logically it seems it should be but it doesn't want to work.

Within my product catalogue table I have a field called "Description".

In this table there is a field for "Product Type" which is a value list, one of the choices being "brochure". Under the Brochure section of the layout are a number of different fields with value lists, about what kind of brochure it is.

I've made the field "Description" a calculation with the following formula:

If (ProductType="Brochure";
(BrochurePages & ", " & BrochureOrientation & ", " & BrochureLamination & ", " & BrochureLaminationOptions & ", " & BrochureFoilOptions & ", " & BrochureDimensions & ", " & CoverPaperWeight & ", " & MainPaperWeight);
WHAT DO I PUT HERE? ).

If the Product Type is not "Brochure", I want to be able to type in the field. What do I put in the formula to allow this? I have tried "" and 0, neither of which work.

The formula result type is set to text.

Help?

Cheers,
Cradders

 

[JeanW]

Logically it should NOT ...

It's a calculated result in your field, you can't change that value in browse, just by overtyping....

Seems to me that you don't have a data diagram nor a relation diagram from your application....

FileMaker is a 'low entry' program, but still needs the basic from database development.
With clicking around to make 'things working' you will hit more than once a wall...

In the manual is an example to achieve what you want.

 

[Cradders]

JeanW,

I don't have a manual...

Is it difficult to explain what I have to do?

??

Cradders

 

[JeanW]

One way to go in FM 7...

Use the 'action on exit field' plugin and script the next steps f.i. with a conditional set field step.

Or put the field entry in a loop, with again a conditional set field.

...no manual ¿¿¿... see what the helpfile can do for you...