Hi All
I have a label that i would like to appear based on a condition
so my scenario is
i have to people selection Comboboxes
if they contain duplicate names the label should appear but it is appearing when both fields are empty.
my formula is
If(
DataCardValue8.Selected.DisplayName = DataCardValue7.Selected.DisplayName,true,
IsEmpty(DataCardValue8.Selected.DisplayName = DataCardValue7.Selected.DisplayName),false)
Is my logic flawed?
Help Gratefully received 🙂
Gary
Solved! Go to Solution.
@BCLS776
it looks like its a circular formula
if box A is blank and Box B is blank then the formula is correct they are both blank so its true
but i am trying to say if they are blank that is false
HEADACHE beginning lol
I have done a very nasty hack but it works
I have just created another label that covers the original with same colour as background and used it to cover if the fields are blank
Gary
Hi Gary, I got this version to work on a test app - order of operations was biting us:
If(
IsBlank(DataCardValue8.Selected.DisplayName) && IsBlank(DataCardValue7.Selected.DisplayName),
false,
DataCardValue8.Selected.DisplayName = DataCardValue7.Selected.DisplayName,
true,
false
)
DOH!!!!!!!
Of course
you have to follow the logic of what you want to achieve!!!
Unbelievable how sometimes we look for the complex solution!!
thank you for the help
that gave me the basis to complete the whole form (5 more fileds to compare)
All working now 🙂
User | Count |
---|---|
260 | |
109 | |
93 | |
57 | |
41 |