Limited fields by drop down selection
I also am doing a database where there is a form. At the top of the
form I have a drop down menu field to say what type of form it is.
There are 4 or 5 types and they all have different info. Is there a
way to have filemaker show me only the fields I need based on what I
choose from that drop down?
Matt
Re: Limited fields by drop down selection
In article
<62c109c4-e30c-4f62-8a94-09e21b89c82d [at] a39g2000pre.googlegroups.com>,
mattG <mgohring [at] gmail.com> wrote:
> I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?
You can "hide" fields by using different layouts and / or portals, but
it might be better to simply use separate tables for the different
forms, and then simply have a "Navigation" Layout with some buttons
(one for each form type). When clicked the button goes to the
appropriate table and creates a new record ready for the user's data
entry.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
Re: Limited fields by drop down selection
I have a Dynamic Value List demo at http://www.VirtualVermont.com/FMP.
Selection in first list determines selection available in second list.
Matt
on 11/29/07 9:17 PM mattG said:
> I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?
>
> Matt
Re: Limited fields by drop down selection
My mistake. Another "Read the whole thing before responding" episode...
Harry's suggestion of navigating to a specific layout depending on the
list selection is the best way to handle it.
You could actually create a pseudo-menu using a drop down coupled with a
script triggering plugin, which would eliminate having to click a button.
Matt
on 11/30/07 6:36 AM Matt Wills said:
> I have a Dynamic Value List demo at http://www.VirtualVermont.com/FMP.
>
> Selection in first list determines selection available in second list.
>
> Matt
>
> on 11/29/07 9:17 PM mattG said:
>> I also am doing a database where there is a form. At the top of the
>> form I have a drop down menu field to say what type of form it is.
>> There are 4 or 5 types and they all have different info. Is there a
>> way to have filemaker show me only the fields I need based on what I
>> choose from that drop down?
>>
>> Matt
Re: Limited fields by drop down selection
On Nov 30, 12:55 pm, Matt Wills <I... [at] witz.end> wrote:
> My mistake. Another "Read the whole thing before responding" episode...
>
> Harry's suggestion of navigating to a specific layout depending on the
> list selection is the best way to handle it.
>
> You could actually create a pseudo-menu using a drop down coupled with a
> script triggering plugin, which would eliminate having to click a button.
>
> Matt
>
> on 11/30/07 6:36 AM Matt Wills said:
>
> > I have a Dynamic Value List demo athttp://www.VirtualVermont.com/FMP.
>
> > Selection in first list determines selection available in second list.
>
> > Matt
>
> > on 11/29/07 9:17 PM mattG said:
> >> I also am doing a database where there is a form. At the top of the
> >> form I have a drop down menu field to say what type of form it is.
> >> There are 4 or 5 types and they all have different info. Is there a
> >> way to have filemaker show me only the fields I need based on what I
> >> choose from that drop down?
>
> >> Matt
If you're looking for a script-triggering plugin, look no further than
EventScript (http://www.softs4humans.com/FMPro_Plugins.html).
Using plugins is not ideal, but there are times when it is necessary,
and this would seem a valid scenario to justify using one. I've used
EventSscript many times, and can report that it's very good.
Regards,
Dan
Dan Stuchbury
FileMaker Extraordinaire
stuchburyassociates<dot>com
Re: Limited fields by drop down selection
"mattG" <mgohring [at] gmail.com> wrote in message
news:62c109c4-e30c-4f62-8a94-09e21b89c82d [at] a39g2000pre.google groups.com...
>I also am doing a database where there is a form. At the top of the
> form I have a drop down menu field to say what type of form it is.
> There are 4 or 5 types and they all have different info. Is there a
> way to have filemaker show me only the fields I need based on what I
> choose from that drop down?
>
> Matt
If you are using FMP 8.0 or later check out Tab Panels. If suitable to your
GUI needs, I think this is the simplest fix.
