This topic contains 1 reply, has 0 voices, and was last updated by fredpope 8 years, 9 months ago.

  • Author
    Posts
  • #9943

    alexonthe12th

    Hello,

    I’m trying to figure out a way to set the Class field on the item record by concatenating 3 fields with a colon delimeter.

    What I have tried so far is a suiteflow that will trigger on save to take field-A and concatenate ‘ : ‘ and field-B and ‘ : ‘ and field-C.

    {field-a}||’ : ‘||{field-b}||’ : “||{field-c}

    What appears to be happening is that when I use suiteflow to populate the field, it’s looking for the Class ID, not the class itself.

    I know this works because when I feed the ID, it takes and the value for the ID pops up on the UI.

    Does anyone know how to take the 3 fields, do a lookup first, then figure out what the ID is and send that ID during the save? I’m sure you can do this with a suitescript, but I haven’t learned that yet so I’m trying to accomplish this in suiteflow.

    Thanks.
    This is a cached copy. Click here to see the original post.

  • #9944

    fredpope

    You should be able to write a function that grabs the variables that you want from the record :

    for example :

    function myFunction() {

    var fielda = nlapiGetFieldValue(‘custbody8’);

    var fieldb = nlapiGetFieldValue(‘custbody9’);

    newField = fielda.concat(fieldb);

    }

    Then call that in a file that is called form the custom code section in your form, and then perform that method on save, or on load, or with a custom action.

You must be logged in to reply to this topic.