showing a field depending of the value of another

[miguel01]

[color:blue]My main question is:

Is it possible to show in the Layout a certain field only if another field has a content?

Does someone have experience with this kind of solutions?

thank you in advance!

miguel

[color:blue]

My problem in detail:

I'm doing a database for i ging queries

case 1

If i.e the first line of the hexagram changes, the field "line1_changing" is showing his number (for example 34.1 for hexagram 34 line 1) Otherwise I keep the field "line1_changing" empty.

Now I want to show the field "line1_comment" only if the field "line1_changing" has a entry.

case 2:

the 64 hexagrams and their 6Lines have one table together (they have IDs (up to 448) but also an ID 1, 1.1, 1.2, 1.3, 1.4, 1.5, 1.6, 2, 2.1...64.6). When it is a line I would like to show the field "text_of_the_line" when it is the hexagram I would like to show the field "hexagram_judgement".

[aldipalo]

Welcome to the Forum.

The simple answer is in FM 9, Yes. It is called conditional formatting.

See attached file.

hth

Dissappearing_Field.zip

[miguel01]

Thank you aldipalo!

I did it sucessfully like this.

Does someone know [color:orange]anotherway to show a field only under the circumstance of another field?.

With the solution of conditional formating we have to keep the space reserved for the field appearing. But I would like to have a same space where diffrent fields could appear.

In details:

I have 6 diffrent fields: "line1" "line2" ..."line6" which use to be shown or not. Sometimes there is only one of the fields showing.

If i.e. only "line6" shows up I would like to show the content of "line6" on top.

(With conditional formatting I have to keep the space for "line1" to "line5" open, therfore "line6" shows up only at the end of page, even if "line1to5" don't have content)

thank you in advance to everybody who knows a solution!

[comment]

If this is for display only, you could use a calculation field, e.g.

List ( Line1 ; Line 2 Line 3 ; ... )

[miguel01]

Thank you comment for your suggestion. For the moment I use the conditional formatting. Because I use some header between the lines, if they appear. in a calculationfield I can't programm diffrent formating of the text in a same field. Isn't it?

Or can you include html like formatting in a calculation field or a script:

If (Line1 = "";"[b]On Line 1 we have[/b]"; "")Line1

Titanium mailed me, having the same problem

Hi, I haven't got the solution, simply posting since i have the same issue. Im still getting the hang of FM, but im sure this is a possible feature.

I want to display a field only if the value of a radio button is yes. If chosen no then not display the field.

I expect this is in a script somewhere but so far no luck.

Any thoughts or ideas would be great.

I’ve only found the possibility to hide

a field (giving to it the same color as the background) or showing it, when it has content.

But this way you will always have to reserve the space in your layout for the field.

This solution you realize by right-clicking on the field ( in layout modus) and choosing “conditional formatting”.

On the popping up window you can adapt all your needs for conditional formatting.

What I was interested in, was to not display the field at all, when it is empty. For that I didn’t find a solution...yet

[Raybaudi]

...Because I use some header between the lines, if they appear. in a calculationfield I can't programm diffrent formating of the text in a same field. Isn't it?

You can !

Try this calculation, result text:

Let(

result =

              If ( not IsEmpty ( Line1 ) ; TextStyleAdd ( "On Line 1 we have " ; Bold ) & Line1 & ¶ )

              & 

              If ( not IsEmpty ( Line2 ) ; TextStyleAdd ( "On Line 2 we have " ; Bold ) & Line2 & ¶ )

              &

              If ( not IsEmpty ( Line3 ) ; TextStyleAdd ( "On Line 3 we have " ; Bold ) & Line3 & ¶ )

              &

              If ( not IsEmpty ( Line4 ) ; TextStyleAdd ( "On Line 4 we have " ; Bold ) & Line4 & ¶ )

              & 

              If ( not IsEmpty ( Line5 ) ; TextStyleAdd ( "On Line 5 we have " ; Bold ) & Line5 & ¶ )

              &

              If ( not IsEmpty ( Line6 ) ; TextStyleAdd ( "On Line 6 we have " ; Bold ) & Line6 & ¶ );

Left ( result ; Length ( result ) - 1 )

)

[miguel01]

thank you very much raybaudi! It works!

I had to let away the result()tag, because a popup window asked me for a calculation(+,-,&)instead of:

Left ( result ; Length ( result ) - 1 )

.

But as long it works without result(), that's fine.

Now I'm just wondering how to show the nice textformat without clicking on the field...

I've put a new thread on this question:

http://fmforums.com/forum/showtopic.php?tid/200453/

thank you for your advice!

m

[Raybaudi]

Now I'm just wondering how to show the nice textformat without clicking on the field...

No need to click on the field...

Lines.zip