Hey everyone, I’m trying to add a condition to a c...
# administrationr
Ryan Longenecker
03/19/2021, 6:08 PMHey everyone, I’m trying to add a condition to a customer workflow. I have a multi-select field and trying to use the following condition - CASE WHEN INSTR({custentity25}, ‘OPTION 1’, 1) > 0 THEN 1 ELSE 0 END. It says it’s invalid expression. Any help would be great!
k
KevinJ of Kansas
03/19/2021, 8:31 PMYou need it to evaluate to true.
KevinJ of Kansas
03/19/2021, 8:31 PMor false - so using a case statement doesn't quite process.
KevinJ of Kansas
03/19/2021, 8:32 PMthe way you have done it. Also there's probably more you want to do with it to ensure you don't get false positives.
KevinJ of Kansas
03/19/2021, 8:32 PMTO_CHAR(INSTR({multiselect field}||',',{comparison field}||','))
KevinJ of Kansas
03/19/2021, 8:33 PMThe reason for the concatenation with commas (using pipes) is so that your string always ends in a comma, and your multiselect field ends in a comma - reducing the likelihood of a false positive (assuming your data doesn't contain commas)
KevinJ of Kansas
03/19/2021, 8:34 PMso then your actual formula looks like this
TO_CHAR(INSTR({multiselect field}||',','OPTION 1'||','))>0TO_CHAR(INSTR({multiselect field}||',','OPTION 1'||','))=0KevinJ of Kansas
03/19/2021, 8:35 PMthen it will evaluate to true or false - which will trigger the workflow appropriately.
KevinJ of Kansas
03/19/2021, 8:36 PMOf course - if you are using this in a client action (like a before submit check, or after field edit) then you have to use Javascript logic to perform the comparison
KevinJ of Kansas
03/19/2021, 8:36 PMHere's a sample of something I did loading a customer record to compare their free shipping methods against the ship method on the sales order.
Copy code
(nlapiLookupField('customer',nvl(nullIfEmpty(nlapiGetFieldValue('entity')),-1),'custentity_po_free_ship_methods',false).concat(',')).
indexOf(nlapiGetFieldValue('shipmethod').concat(','))>=0KevinJ of Kansas
03/19/2021, 8:37 PMI have a whole write up I probably need to post as a blog at some point... cause man, that was fun to come up with.
r
Ryan Longenecker
03/22/2021, 3:37 PMHey @KevinJ of Kansas thank you very much for the help!
k
KevinJ of Kansas
03/22/2021, 10:38 PMSo what did you end up doing
r
Ryan Longenecker
03/22/2021, 10:38 PMI was able to get a search to pull up the right fields selected and used that as my condition
4 Views