Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

# Thread: Disable other yes/no parameter when checked without interrupting default not formula

1. ## Disable other yes/no parameter when checked without interrupting default not formula

Hello Reddit Gurus,

I've researched through a lot of posts about parameter formulas and syntax today and have not found the full solution to the problem I am attempting to solve. I have three parameters that define three different door types so they can be scheduled independently. Each of which are a yes/no parameter. If none are checked, there must be a default. As of now, I am using a not formula to define the Unit Door as the default, "not(or(Commercial Door Schedule, Amenity Door Schedule))". This solves half of my problem. The other half is that when you select either Amenity or Commercial Door, you should be unable to select the other. As of now, you can select both Amenity and Commercial at the same time. Which will result in the door being schedule in both schedules. Every solution that I have found has been to use a not statement to void the other option, but most of those solutions only have 2 yes/no parameters. Doing this voids my default unit formula.

In red below is what requires a formula or two. I know it will be a simple if statement if its possible. I just cannot figure it out.

Amenity Door Schedule (Can be checked, but will disable Commercial checkbox)
Commercial Door Schedule (Can be checked, but will disable Amenity checkbox)
Unit Door Schedule (Default value if other two are not checked, if other option is selected then the checkbox is disabled)

Any thoughts will be appreciated. Thanks for your time,

Corey

2. To put it bluntly, you can’t do what you want the way you want. You can use another parameter, however, as a go between. Make an integer parameter control the yes/no’s, for example.

3. Thanks for confirming that Greg. I figured with three yes/no variables it would be difficult or not possible. I've seen plenty of the integer examples you're mentioning but have wanted to keep it as simple as possible for the user. So I went with another example I've seen here which is the show warning label. It doesn't prevent a user from selecting both options but does notify them and others if they do. That will just have to work for now.

For anyone curious, steps below:

- Add yes/no visibility parameter with And() formula for both options that you do not want to be selected at the same time.
- Add generic label to the family and define text, assign parameter from above.
- If both yes/no parameters are checked then the label warning will display on the family.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•