On Apr 23, 5:24=A0pm, Helpful Harry <helpful_ha...@[EMAIL PROTECTED]
>
wrote:
> In article <C435110B.25396%mr.a...@[EMAIL PROTECTED]
>, John Couani
>
>
>
> <mr.a...@[EMAIL PROTECTED]
> wrote:
> > Hi
> > I am working on a database in v8.5.
> > There is one section of the layout that the client would like to be
> > invisible or covered if there is no data entered in the field in this
> > section.
> > It doesn't need to move up, just create an "empty" space.
>
> > I thought there'd be something like
> > if x field is empty
> > set this object to no visible
>
> > Scouring the Internet, I found something I thought should also work -
> > Make a one-cell ****tal with a one row entry which, once the condition
of=
the
> > relation****p is met, would allow the piece of white box in the ****tal
ce=
ll
> > to appear and so cover the required section below.
>
> > I have that set up and ready to go but something is just not working.
Ei=
ther
> > the object doesn't disappear completely [it's fields and boxes and the
b=
oxes
> > remain], or nothing happens, or something I can't work out what's
happen=
ed!
>
> > Frustrating.
>
> > So, does anyone have any solution for this? Even a suggestion would be
g=
ood
>
> You can use a ****tal to display / hide a white box over fields to hide
> them.
>
> Instead you have to work the other way around - using the ****tal to
> display / hide the fields themselves when needed.
>
> Having said that, it's usually better to simply use two Layouts - one
> with the fields and one without, and then use a script / button to swap
> between the two Layouts.
>
> Helpful Harry =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0
> Hopefully helping harassed humans happily handle handiwork hard****ps
=A0;o=
)
Thanx everyone for your input[s]. The covering ****tal thing just
didn't want to work for me for some reason
In the end we created an off-layout table of fields for the data
entry.
Then made a text calculation field "math subjects" to bring it all
together, with a case calculation regarding "status =3D outstanding"
Then we made another status field to say "outstanding" or whatever
other status.
So, when the status field was set to "outstanding", nothing happened,
but when the status was changed from "outstanding" to "enrolled" or
"completed" the text calculation field "math subjects" was populated
with the calculated text, brought in from the subject entry fields.
This turned out to be a simpler and better solution - I'll be handing
this database onto filemaker new-users. I think this "old fa****oned"
approach will be better for later editing
|
