Show hide fields

Hello everybody

I need to show/hide a field in a table, according to its value.
I mean , if the value is null I wish to hide the feld, otherwise show
it.
I can I do this?

Best regards

Re: Show hide fields

elisacarli wrote:

> I need to show/hide a field in a table, according to its value.
> I mean , if the value is null I wish to hide the feld, otherwise show
> it.
> I can I do this?

With a second field that calculates the result you want, depending on
what is in the first field.
--
http://clk.ch

Re: Show hide fields

On Apr 12, 3:47 am, elisacarli wrote:
> Hello everybody
>
> I need to show/hide a field in a table, according to its value.
> I mean , if the value is null I wish to hide the feld, otherwise show
> it.
> I can I do this?
>
> Best regards

What version of Filemaker? FM 9 has the very useful Conditional
Formatting.

Re: Show hide fields

On 12 Apr, 15:22, Grip wrote:
> On Apr 12, 3:47 am, elisacarli wrote:
>
> > Hello everybody
>
> > I need to show/hide a field in a table, according to its value.
> > I mean , if the value is null I wish to hide the feld, otherwise show
> > it.
> > I can I do this?
>
> > Best regards
>
> What version of Filemaker? =A0FM 9 has the very useful Conditional
> Formatting.

I've FM 9 and I've seen Conditional Formatting but I'm not able to set
it for this purpose.
Could you kindly give me any suggestion?

Thank you

Re: Show hide fields

On Apr 12, 7:50 am, elisacarli wrote:
> On 12 Apr, 15:22, Grip wrote:
>
> > On Apr 12, 3:47 am, elisacarli wrote:
>
> > > Hello everybody
>
> > > I need to show/hide a field in a table, according to its value.
> > > I mean , if the value is null I wish to hide the feld, otherwise show
> > > it.
> > > I can I do this?
>
> > > Best regards
>
> > What version of Filemaker? FM 9 has the very useful Conditional
> > Formatting.
>
> I've FM 9 and I've seen Conditional Formatting but I'm not able to set
> it for this purpose.
> Could you kindly give me any suggestion?
>
> Thank you

How is the field currently displaying? Is it in Form View, List View,
or Table view? What does "hide the field" mean to you?

Re: Show hide fields

On 12 Apr, 16:15, Grip wrote:
> On Apr 12, 7:50 am, elisacarli wrote:
>
>
>
>
>
> > On 12 Apr, 15:22, Grip wrote:
>
> > > On Apr 12, 3:47 am, elisacarli wrote:
>
> > > > Hello everybody
>
> > > > I need to show/hide a field in a table, according to its value.
> > > > I mean , if the value is null I wish to hide the feld, otherwise sho=
w
> > > > it.
> > > > I can I do this?
>
> > > > Best regards
>
> > > What version of Filemaker? =A0FM 9 has the very useful Conditional
> > > Formatting.
>
> > I've FM 9 and I've seen Conditional Formatting but I'm not able to set
> > it for this purpose.
> > Could you kindly give me any suggestion?
>
> > Thank you
>
> How is the field currently displaying? =A0Is it in Form View, List View,
> or =A0Table view? =A0What does "hide the field" mean to you?- Nascondi tes=
to tra virgolette -
>
> - Mostra testo tra virgolette -

The field is in a form view. I like to hide it every time its value is
null or empty. (not visible on the screen)

Re: Show hide fields

On Apr 12, 8:37 am, elisacarli wrote:
> On 12 Apr, 16:15, Grip wrote:
>
>
>
> > On Apr 12, 7:50 am, elisacarli wrote:
>
> > > On 12 Apr, 15:22, Grip wrote:
>
> > > > On Apr 12, 3:47 am, elisacarli wrote:
>
> > > > > Hello everybody
>
> > > > > I need to show/hide a field in a table, according to its value.
> > > > > I mean , if the value is null I wish to hide the feld, otherwise show
> > > > > it.
> > > > > I can I do this?
>
> > > > > Best regards
>
> > > > What version of Filemaker? FM 9 has the very useful Conditional
> > > > Formatting.
>
> > > I've FM 9 and I've seen Conditional Formatting but I'm not able to set
> > > it for this purpose.
> > > Could you kindly give me any suggestion?
>
> > > Thank you
>
> > How is the field currently displaying? Is it in Form View, List View,
> > or Table view? What does "hide the field" mean to you?- Nascondi testo tra virgolette -
>
> > - Mostra testo tra virgolette -
>
> The field is in a form view. I like to hide it every time its value is
> null or empty. (not visible on the screen)

I'm assuming you have a border around the field with a line color
different than the background color or that the field has a fill color
that is different than the background color. If it's the latter, you
can set the Conditional Formatting for the field to a formula
IsEmpty(field) and set the fill color the same as the background it's
a border issue, you need to turn off the border and recreate it using
a text box. The text box need only contain a single space. Set the
fill color for the box to what you want the border color to be and
make it 2 pixels bigger in each dimension than the field. Bring the
field in front of the text box and center it. Now you have a new
border made from a text box and can set the conditional formatting to
the background color as above.

This process is easier if you zoom in 300 or 400 %.

Re: Show hide fields

On Apr 12, 11:55 am, Grip wrote:
> On Apr 12, 8:37 am, elisacarli wrote:
>
>
>
> > On 12 Apr, 16:15, Grip wrote:
>
> > > On Apr 12, 7:50 am, elisacarli wrote:
>
> > > > On 12 Apr, 15:22, Grip wrote:
>
> > > > > On Apr 12, 3:47 am, elisacarli wrote:
>
> > > > > > Hello everybody
>
> > > > > > I need to show/hide a field in a table, according to its value.
> > > > > > I mean , if the value is null I wish to hide the feld, otherwise show
> > > > > > it.
> > > > > > I can I do this?
>
> > > > > > Best regards
>
> > > > > What version of Filemaker? FM 9 has the very useful Conditional
> > > > > Formatting.
>
> > > > I've FM 9 and I've seen Conditional Formatting but I'm not able to set
> > > > it for this purpose.
> > > > Could you kindly give me any suggestion?
>
> > > > Thank you
>
> > > How is the field currently displaying? Is it in Form View, List View,
> > > or Table view? What does "hide the field" mean to you?- Nascondi testo tra virgolette -
>
> > > - Mostra testo tra virgolette -
>
> > The field is in a form view. I like to hide it every time its value is
> > null or empty. (not visible on the screen)
>
> I'm assuming you have a border around the field with a line color
> different than the background color or that the field has a fill color
> that is different than the background color. If it's the latter, you
> can set the Conditional Formatting for the field to a formula
> IsEmpty(field) and set the fill color the same as the background it's
> a border issue, you need to turn off the border and recreate it using
> a text box. The text box need only contain a single space. Set the
> fill color for the box to what you want the border color to be and
> make it 2 pixels bigger in each dimension than the field. Bring the
> field in front of the text box and center it. Now you have a new
> border made from a text box and can set the conditional formatting to
> the background color as above.
>
> This process is easier if you zoom in 300 or 400 %.

Is there not a way to actually show or hide a field? I'm working in FM
Pro 7 and would like to do the same thing. The only way I've thought
of to do it is make a whole new layout, then just have my button
switch me over to that layout. There should be a better way, no?

Re: Show hide fields

> Is there not a way to actually show or hide a field? I'm working in FM
> Pro 7 and would like to do the same thing. The only way I've thought
> of to do it is make a whole new layout, then just have my button
> switch me over to that layout. There should be a better way, no?

Hello,

I haven't follow this discussion, but youmay want to search the archive
for the so-called "visibility trick". I've used this method in previous
and current versions of Filemaker without problems.

HTH

Marc

Re: Show hide fields

In article
,
tdavie wrote:

> On Apr 12, 11:55 am, Grip wrote:
> >
> > I'm assuming you have a border around the field with a line color
> > different than the background color or that the field has a fill color
> > that is different than the background color. If it's the latter, you
> > can set the Conditional Formatting for the field to a formula
> > IsEmpty(field) and set the fill color the same as the background it's
> > a border issue, you need to turn off the border and recreate it using
> > a text box. The text box need only contain a single space. Set the
> > fill color for the box to what you want the border color to be and
> > make it 2 pixels bigger in each dimension than the field. Bring the
> > field in front of the text box and center it. Now you have a new
> > border made from a text box and can set the conditional formatting to
> > the background color as above.
> >
> > This process is easier if you zoom in 300 or 400 %.
>
> Is there not a way to actually show or hide a field? I'm working in FM
> Pro 7 and would like to do the same thing. The only way I've thought
> of to do it is make a whole new layout, then just have my button
> switch me over to that layout. There should be a better way, no?

You can do a similar trick using a Calculation field with a Container
result behind the normal field that displays an image to fake the field
border, but neither way really hides the field - users can still click
in it or tab into it (if the field is in the Tab Order).

A better trick is to put the field(s) inside a Portal, that way you can
"show" or "hide" the field(s) by making the Portal's Relationship valid
or invalid. This "Portal trick" is explained further down.

The problem with all of these methods is that you can't overlap fields
(while still able to click in them) nor overlap Portals, so whenever
the field is "hidden" you are left with a blank space on screen.

A better method is usually to use separate Layouts as you already do.
To ease the complexity from the user, you may not need to bother with
an actual button. You can use 'invisible' buttons (no fill or line
colour) over a field that run scripts to set the appropriate data and
change Layouts.
eg.
Have a Gender radio button field and put 'invisible'
buttons over each option that run an appropriate script.
One button sets the field to "Male" and changes to the
Male Layout, while the other button sets the field to
"Female" and changes to the Female Layout

Unfortunately this only works for Radio button or Check box fields (or
fields you 'toggle' by just clicking on them), unless you use a plug-in
to run a script when data in a field is changed.

I'm not sure how the Tabbed Layouts in newer versions of FileMaker
work, so they might or might not be another method of displaying
different fields.


"Portal Trick"
--------------
First you need a field that is a unique ID for each record so that only
data from the current record is shown in the Portal.
eg.
ThisRecord Number
Auto-enter Serial Number
Start R1 Increment by 1

Then you need two fields to act as the Key / Link fields for the
Relationship - both fields will use the unique ID above combined with
the text of "Show" or "Hide".

One field will ALWAYS be set to specific data to act as the Child-side
link.
eg.
ShowHideConstant Text
Auto-enter Calculation: ThisRecord & "-Show"

The second field can be either a normal field (if using a button to
change visibility of the field) or a Calculation (if using another
field's data to alter visibility). Either way this field will be used
as the Parent-side of the Relationship link.
eg.
ShowHideToggle Calculation, Unstored, Text Result
= ThisRecord & If (Gender = "Male";
"-Show";
"-Hide")

Now you can define a Relationship within the same Table (a "self-join"
Relationship).
eg.
rel_ShowPortal Match records in MyTable with records
in MyTable
when ShowHideToggle = ShowHideConstant

This Relationship can be used by a one-row Portal on your Layout and
the field you want to be able to hide put inside the Portal (making
sure it too uses the Relationship).

When the Gender field is set to "Male", both ShowHideConstant and
ShowHideToggle are "R1-Show", so the Relationship is valid and the
Portal displays the 'related' fields (which are in reality fields from
the same record).

When the Gender field is set to "Female", ShowHideConstant is "R1-Show"
while ShowHideToggle is "R1-Hide", so the Relationship is invalid and
the Portal is empty ... and the field is 'invisible' and cannot be
clicked or tabbed into.





Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)