I have a "choice" datacard value field that has three options. The selectable choices are as follows:
Standard Depth/Velocity Confirmation
Full Velocity Profile (Flow >5in / 12.7cm)
I am trying to get a portion of my form to visible if EITHER "Standard Depth/Velocity Confirmation" OR "Full Velocity Profile (Flow >5in / 12.7cm)" is selected.
I am having trouble getting this functionality. So far I have tried the following:
If((DataCardValue36.Selected.Value = "Standard Depth/Velocity Confirmation") && (DataCardValue36.Selected.Value = Full Velocity Profile (Flow >5in / 12.7cm)), true, false)
This results in the portion of the form not being visible at all and does not change for either option. Am I doing something obvious wrong? Thanks for any help in advance.
Thanks @Eelman for the input! I gave it a try but unfortunately no luck. I will keep looking for a solution. It can't be that complicated haha.
In the Visible property of the items in question, you should be able to dispense with the If() function since the statement
DataCardValue36.Selected.Value <> "No"
reduces to either true or false. To test make DataCardValue36.Selected.Value the Text property of a label on the screen and adjust the Visible property accordingly.
Hi @SamR ,
If following your logic, the formula should look something like this, just need to satisfy one of two conditions.
If(DataCardValue36.Selected.Value = "Standard Depth/Velocity Confirmation" || DataCardValue36.Selected.Value = "Full Velocity Profile (Flow >5in / 12.7cm)", true, false)
@Drrickryp's code is more concise, the code self returns a boolean value, so IF function is not required, directly check that the "NO" option is not selected.
Hope this helps.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.