Entering Text on One Layout and Shows up on Another

[Crinklaw]

HELP!!!

Whats up everyone. I'm trying to set up a file here. I have two layouts. One is a log to log material into, the other is a history of the logs for different vendors. Anways, I can't seem to figure out how to get certain fields to show up on my history log only if they have text in them. If nothing is entered, I don't want them showing up. How do I do this? Basically I've got a rejection form on the Log for each shipment that is only filled out when we find rejected material. I don't want the form on the history layout if there was no need for it to be filled out.

Please help ASAP!! I'm hoping is not complicated where I have to enter in a bunch of formulas into scriptmaker.

Edited September 28, 2005 by Guest

[-Queue-]

Create calculation fields based on the original fields, e.g.,

Case( not IsEmpty(someField); TextStyleAdd( "FieldLabel: "; Bold ) & someField )

and put the calc fields on your historical layout.

[Crinklaw]

Lets say my first layout is "layout 1" and my second layout is "layout 2"

one field is "Description" that has text in it... and I want the same field to show up on my history layout... what do I need to do? I coudln't get the calic to work.

[-Queue-]

If you want Description to always show, then put the Description field on layout 2. If you only want to show it when it has data, use the calculation field.

Make sure you are using real calculation fields and not text fields with auto-enter calculations.

someField is just that; replace it with the name of the desired field. FieldLabel should be replaced with the label text which would normally appear before the field. In the case of the calculation, it is contained within the field itself, so that it does not display when the field is empty. You could use a secondary calculation field to hold the label, but there really is no need to, since you can add style to only the label and leave the field data alone.

[Crinklaw]

how do you change to real calculation fields ?

thanks,

you've been very helpful?

[-Queue-]

If you are using text fields with auto-enter calculations, just select the field in Define Database -> Fields, change the Type drop-down list to Calculation, and click the Change button. Click OK, and then make sure the calculation result is Text, and click OK.