Forum Discussion
MarkShnier__You
Qrew Champion
You have not provided the error message but if you erase the stand alone line
var text
which is sandwiched between the two blocks of code, it will probably work.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var text
which is sandwiched between the two blocks of code, it will probably work.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
LukeFuruto
3 years agoQrew Trainee
Thanks again for your help. I think we are close. I removed the var text, and I receive no error code now, but the field always answers "yes" even when it is not the case. Any thoughts?
- MarkShnier__You3 years agoQrew ChampionTry this one. It tests OK for me.
var text MultiA = ToText([Secondary Risk Categories]);
var text MultiB = ToText([Reporting - Secondary Risk Category]);
var text BOne = Trim(Part(ToText([Reporting - Secondary Risk Category]),1,";"));
var text BTwo = Trim(Part(ToText([Reporting - Secondary Risk Category]),2,";"));
var text BThree = Trim(Part(ToText([Reporting - Secondary Risk Category]),3,";"));
var text BFour = Trim(Part(ToText([Reporting - Secondary Risk Category]),4,";"));
var text BFive = Trim(Part(ToText([Reporting - Secondary Risk Category]),5,";"));
var text BSix = Trim(Part(ToText([Reporting - Secondary Risk Category]),6,";"));
var text BSeven = Trim(Part(ToText([Reporting - Secondary Risk Category]),7,";"));
var text BEight = Trim(Part(ToText([Reporting - Secondary Risk Category]),8,";"));
var text BNine = Trim(Part(ToText([Reporting - Secondary Risk Category]),9,";"));
var text BTen = Trim(Part(ToText([Reporting - Secondary Risk Category]),10,";"));
var text BEleven = Trim(Part(ToText([Reporting - Secondary Risk Category]),11,";"));
var text BTwelve = Trim(Part(ToText([Reporting - Secondary Risk Category]),12,";"));
var text BThirteen = Trim(Part(ToText([Reporting - Secondary Risk Category]),13,";"));
If(
$BOne <>"" and Contains($MultiA, $BOne), "Yes",
$BTwo <>"" and Contains($MultiA, $BTwo), "Yes",
$BThree <>"" and Contains($MultiA, $BThree), "Yes",
$BFour <>"" and Contains($MultiA, $BFour), "Yes",
$BFive <>"" and Contains($MultiA, $BFive), "Yes",
$BSix <>"" and Contains($MultiA, $BSix), "Yes",
$BSeven <>"" and Contains($MultiA, $BSeven), "Yes",
$BEight <>"" and Contains($MultiA, $BEight), "Yes",
$BNine <>"" and Contains($MultiA, $BNine), "Yes",
$BTen <>"" and Contains($MultiA, $BTen), "Yes",
$BEleven <>"" and Contains($MultiA, $BEleven), "Yes",
$BTwelve <>"" and Contains($MultiA, $BTwelve), "Yes",
$BThirteen <>"" and Contains($MultiA, $BThirteen), "Yes", "No")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- LukeFuruto3 years agoQrew Trainee
Works like a charm! I'm so grateful. Thanks so much for all your help on this.