Best method that prevents user from selecting...

(Tim Meske) #1

Best method that prevents user from selecting ‘yes’ to two fields in a form.

If user wants to select ‘yes’ in one of the fields then the other must be ‘no’.

Or both must be ‘no’.

Not having success with if OR/AND formula in Type Qualifier ‘Valid_If’.

Also, I am not using virtual columns for this, maybe this is required too?


(Levent KULAÇOĞLU) #2

Considering both columns’ type qualifier is Text:

In [Column1] Valid_if;

IFS( AND([Column1]=“No”, [Column2]=“No”),{“Yes” , “No”}, [Column2]=“No”, {“Yes”} )

In [Column2] Valid_if;

IFS( AND([Column1]=“No”, [Column2]=“No”),{“Yes” , “No”}, [Column1]=“No”, {“Yes”} )

(Tim Meske) #3


They are type qualifier yes/no, not text.

So same thing but use true/false instead?

(Levent KULAÇOĞLU) #4

@Tim_Meske yes you can use true/false but don’t put them inside the quotes, with Yes/No it’s not required. Though I suspect that you might receive a “circular dependency” error but not so sure. I’m out therefore haven’t tested my suggestion.

(Tim Meske) #5

@Levent_KULACOGLU thanks

(Tim Meske) #6

-The recommended formulas cause the yes no buttons to be removed from the display.

Is there a way to keep the yes no buttons displayed for both columns regardless the selection?

This way the user can see the status of both columns.

-the goal is… the buttons are allowed to be both false OR either button true while the other button is false (both buttons can NOT be true at the same time). If user tries to set both true then the app tells the user the configuration is not allowed.


(Tim Meske) #7

Got if figured out now.