Multiple Condition IF formula

[Mariano]

Hey everybody-

I am using 3 different drop down menus, i cant for the life of me figure out how to set it up so each combination of drop downs will return a different result. I could do it with IF AND functions, but that would be really tedious. Is there a quicker way to do it then touch each different combination with an if formula?

Mark

[Mariano]

Hey everybody-

I am using 3 different drop down menus, i cant for the life of me figure out how to set it up so each combination of drop downs will return a different result. I could do it with IF AND functions, but that would be really tedious. Is there a quicker way to do it then touch each different combination with an if formula?

Mark

[Mariano]

Hey everybody-

I am using 3 different drop down menus, i cant for the life of me figure out how to set it up so each combination of drop downs will return a different result. I could do it with IF AND functions, but that would be really tedious. Is there a quicker way to do it then touch each different combination with an if formula?

Mark

[IOkate]

Yes, I'm trying to do this too. Being brand-new to FMP, I have no idea if this is a practical thing to do or not. I want to have 3 drop down boxes in sequence - for example:

DB1 will have choices: fruit, veggies, rocks

After picking "fruit", DB2 will show choices: apples, oranges. If "veggies" was picked, it would show: okra, broccoli, lettuce

DB3 after picking "apples": gala, braeburn, granny smith

Is this the kind of thing you're trying to do?

Kate.

[IOkate]

Yes, I'm trying to do this too. Being brand-new to FMP, I have no idea if this is a practical thing to do or not. I want to have 3 drop down boxes in sequence - for example:

DB1 will have choices: fruit, veggies, rocks

After picking "fruit", DB2 will show choices: apples, oranges. If "veggies" was picked, it would show: okra, broccoli, lettuce

DB3 after picking "apples": gala, braeburn, granny smith

Is this the kind of thing you're trying to do?

Kate.

[IOkate]

Yes, I'm trying to do this too. Being brand-new to FMP, I have no idea if this is a practical thing to do or not. I want to have 3 drop down boxes in sequence - for example:

DB1 will have choices: fruit, veggies, rocks

After picking "fruit", DB2 will show choices: apples, oranges. If "veggies" was picked, it would show: okra, broccoli, lettuce

DB3 after picking "apples": gala, braeburn, granny smith

Is this the kind of thing you're trying to do?

Kate.

[Mariano]

yes.. thats pretty similar... theres got to be an easier way.

[Mariano]

yes.. thats pretty similar... theres got to be an easier way.

[Mariano]

yes.. thats pretty similar... theres got to be an easier way.

[IOkate]

I hacked it up with simple scripts, but discarded the solution as bad design. For my purposes, I'm just having 3 tiers of checkboxes because my users said it was helpful to see all the categories laid out at a glance. They said the drop boxes were too "mysterious" and checkboxes were way easier to use.

Maybe you can do the same kind of thing?

[IOkate]

I hacked it up with simple scripts, but discarded the solution as bad design. For my purposes, I'm just having 3 tiers of checkboxes because my users said it was helpful to see all the categories laid out at a glance. They said the drop boxes were too "mysterious" and checkboxes were way easier to use.

Maybe you can do the same kind of thing?

[IOkate]

I hacked it up with simple scripts, but discarded the solution as bad design. For my purposes, I'm just having 3 tiers of checkboxes because my users said it was helpful to see all the categories laid out at a glance. They said the drop boxes were too "mysterious" and checkboxes were way easier to use.

Maybe you can do the same kind of thing?

[-Queue-]

Do a search for +conditional +value +list. This is a relatively easy task.

[-Queue-]

Do a search for +conditional +value +list. This is a relatively easy task.

[-Queue-]

Do a search for +conditional +value +list. This is a relatively easy task.

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe/Fred

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe/Fred

[silose]

I am new to FM 7.0 and have accepted a projet from my employer to create a set of forms that are printable. I could really use help with a few things like creating a drop down list box then when value in drop down list box is a,b,c,d,e put text in space 1 on form/page 1 2 3 or 4....

any help would be great

tyvm

Siloe/Fred

[bikergeek]

Try this. [attachment]

[bikergeek]

Try this. [attachment]

chain.fp7.zip