Here is what I am trying to accomplish.
I have a form.
This first line allows the user to select a name from a list.
Next option is to select whether the user is โProโ or โAmโ.
This is an enum using buttons.
The next option, also enum buttons is โ$0โ, โ$6โ, โ$8โ, โ$10โ.
I would like to either remove a button for amount based on โProโ or โAmโ selection or stipple out the un-needed button.
Any suggestions?
I donโt want a list, I want buttons.
Thanks for any help.
Try to use this in the ValidIf property of the amount column: IF([UserIs] = โProโ, LIST("$6", โ$8โ, โ$10โ), LIST("$0", โ$6โ, โ$8โ)) And be sure to set EnumInputMode property to โbuttonsโ
Itโs not possible to โstipple outโ buttons, but you can remove them.
Whether the options are presented as buttons or as a dropdown menu is determined by the columnโs EnumInputMode property.
The buttons (or dropdown menu entries) displayed are determined by the defined Enum values in the column definition, or as given in a list generated by the columnโs Valid_If formula. If no Valid_If formula is defined, the user will be presented with all of the columnโs Enum values as options. If Valid_If is defined and results in a list, the user will only be presented with the values in the list as options.
For example, the entire set of options you gave can be expressed as a formula for Valid_If as:
=LIST("$0", โ$6โ, โ$8โ, โ$10โ)
You can use an IF() expression to conditionally present a different set. For instance:
=IF(
([Pro/Am] = โProโ),
LIST("$0", โ$100โ, โ$200โ),
LIST("$0", โ$6โ, โ$8โ, โ$10โ) )
If the user selected Pro for the Pro/Am column, the column would present options for $0, $100, and $200; otherwise, the column would present $0, $6, $8, and $10.
thank you gentlemen.
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |