Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scipt which is,
If(Match(Book, '101', '102', '103') and Year(RecordDate) = '2016', '1') as BookRecordFlag
I want to use a input box to dynamically add more data in this statement and store as BookRecordFlag. If I enter 110 in the input box, it should add that value in the match statement where the statement will look like this If(Match(Book, '101', '102', '103', '110') and Year(RecordDate) = '2016', '1') as BookRecordFlag. I am pulling this BookRecordFlag in a frontend object and I want this object to reflect the new code. Is it possible?
You could try:
If(Match(Book, '101', '102', '103', '$(vInputboxVariable)') and Year(RecordDate) = '2016', '1') as BookRecordFlag
- Marcus
Thanks Marcos, I tried this but it did not work. I created a input box and entered a value for vInputboxVariable, it does not show the entered value. is there any other way?
Hi Enthu,
You can add a variable, and concatenate with last value of the same variable if the new input value doen't exists on it, for example:
If(Len(YourVarName)=0,InputBoxValue,
If(SubStringCount(YourVarName,InputBoxValue)=0,YourVarName&','&chr(39)&InputBoxValue&chr(39),YourVarName))
Then, on your expression, If(Match(Book, '$(YourVarName)') and Year(RecordDate) = '2016', '1') as BookRecordFlag
Regards!
What didn't work? Which client do you use? How do you execute the reloal?
- Marcus
Marcus solution solution should work
If(Match(Book, '101', '102', '103', '$(vInputboxVariable)') and Year(RecordDate) = '2016', '1') as BookRecordFlag
Have you created this variable on your machine vInputboxVariable?
OR Else please share more information which part you stucked after using Marcus solutions