Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't overtype in a calculation field once in browse

Status
Not open for further replies.

Cradders

Technical User
Jul 21, 2005
25
FR
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
 
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.

 
JeanW,

I don't have a manual...

Is it difficult to explain what I have to do?

??

Cradders
 
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...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top