Hi! I am trying to use a workflow to populate a te...
# suiteflowm
Manda
03/05/2021, 9:06 PMHi! I am trying to use a workflow to populate a text field with values from a multi-select field. On the first attempt I was able to get the field populated just using the multi-select fields internal ID. However, it came out looking like this... Anyone know what I need to do to change this? At the minimum I'd like to at least replace the characters with commas, ideally I'd like just the item numbers as comma separated.
k
KevinJ of Kansas
03/05/2021, 9:33 PMMine did this when I concatenated - if I removed concatenation it solved the issue.
KevinJ of Kansas
03/05/2021, 9:34 PMwhen are you doing the field sourcing?
m
Manda
03/05/2021, 9:37 PMSourcing is after record submit. I didn't try any concatenating I just used the field id in the formula field.
k
KevinJ of Kansas
03/07/2021, 9:40 PMCan you do the sourcing before record submit and use a client event? I was able to make this work.
KevinJ of Kansas
03/07/2021, 9:42 PM(nlapiLookupField('customer',nvl(nullIfEmpty(nlapiGetFieldValue('entity')),-1),'custentity_po_free_ship_methods',false).concat(',')).indexOf(nlapiGetFieldValue('shipmethod').concat(','))>=0KevinJ of Kansas
03/07/2021, 9:43 PMThat is plugged into the criteria field of an action in client - and it's comparing against the ship method.
KevinJ of Kansas
03/07/2021, 9:44 PMso if we pull out all my comparison stuff...
(nlapiLookupField('customer',nvl(nullIfEmpty(nlapiGetFieldValue('entity')),-1),'custentity_po_free_ship_methods',false)m
Manda
03/08/2021, 5:27 PMYou went over my head on this. 🙂 We still talking about a workflow or do I need to look at a script?
k
KevinJ of Kansas
03/08/2021, 5:38 PMHybrid. Using script within workflow
m
Manda
03/10/2021, 7:36 PMSo I've been trying to find more on this to make sure I understand. But I think I'm still lost, sorry. Are you putting that code somewhere within a workflow field or is it a script triggered by a workflow?
k
KevinJ of Kansas
03/10/2021, 7:57 PMIt would go in where you set the field value instead of just the field reference
m
Manda
03/10/2021, 8:04 PMOk, so I'm sure I botched this...I'm getting an ERROR: Invalid Expression
(nlapiLookupField('item',nvl(nullIfEmpty(nlapiGetFieldValue('item')),-1),'custitem_ifd_suggested_sub',false)
k
KevinJ of Kansas
03/10/2021, 8:25 PMPut your desired field in a criteria... And then switch from builder to custom formula
KevinJ of Kansas
03/10/2021, 8:26 PMIt should give you better idea how to fill out
m
Manda
03/10/2021, 9:12 PMThank you for your time and assistance!!
3 Views