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?
Thanks!
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โ} )
Thanks!
They are type qualifier yes/no, not text.
So same thing but use true/false instead?
@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.
@Levent_KULACOGLU thanks
-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.
Thanks!
Got if figured out now.
Thanks!
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
13 |