
Announcements
If(DataCardValue59.Selected.Value <> ("9" || "10") && ICEVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), DataCardValue59.Selected.Value = ("9" || "10") && ICEVar = 1 && EMOBVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), Set(PPEVar,1))
This section of code is just used to adjust 'Var' values to change the text in a label. When I try to compare DataCardValue59 to 9 or 10, I get a blue underline under the "<>" and "=" operators with a warning saying I can't compare text to boolean. I can't figure out what I'm doing wrong since the DataCard and 9 and 10 are all text values.
The syntax for 9 or 10 doesn't work that way, you could use:
If((DataCardValue59.Selected.Value <> "9" && DataCardValue59.Selected.Value <> "10") && ICEVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), (DataCardValue59.Selected.Value = "9" || DataCardValue59.Selected.Value = "10") && ICEVar = 1 && EMOBVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), Set(PPEVar,1))
or alternatively change it to an in operator
If(DataCardValue59.Selected.Value not in ["9", "10"] && ICEVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), DataCardValue59.Selected.Value in ["9", "10"] && ICEVar = 1 && EMOBVar = 1, SubmitForm(EditForm2) && Set(PPEVar,2), Set(PPEVar,1))