Sorry I havent had the need myself for multiple formula field columns.

What are you doing in the formula fields?

concats, substrs etc

so the data are compatible with external sources

Right. That should be easy enough to do in the script.

Pull the value in the database column and then do the changes before sending it.

You definitely can use multiple formula fields in a search and grab from a script. You just need to label those search columns unique names and then do a check for the column name in script to make sure you grab the correct one.

I use this function to pass in a result and grab the column with the specified label.

I've tried to strip out most of our extra code here to show how we handle the column values and push.

Hi all - is there a way to programatically remove Roles from Employees using SuiteScript? We have a client looking to temporarily assign roles to employees and for the role to expire after a set date and automatically be removed I believe I’ve asked about this before but can’t find it in the search 😛

I'm getting a "Uncaught Error: Load timeout for modules: N/render" error when running this script. The script is invoked by a button created by a User Event script. When I take of the render module I see the console logs, and I even added in the N/ui/message module to make sure another module works, which it does. Anyone encounter this before?

N/render is not supported in client scripts.

@Lea CC, Thanks. What I'm trying to do is have a button on an estimate which loads a different template for printing. Is the only way to do this by creating button with UE, sending to CS, and then redirecting to SL? I'd think there might be a simpler way which hopefully someone knows before I develop three scripts to do something that sounds rather simple. lol

@jarens I have buttons on item records to print but I just have a UE and a suitelet.

@jarens Here is a snippet for adding a beforeLoad

@jarens

renderer.setTemplateByScriptId("CUSTTMPL_NFG_PICKING_SHEET")

Using name ID never worked for me... I use internal ID of the template... others report it works but not for me...

@rant uploaded a file: Untitled

Ahh so I just add and IFFE as the functionName?

@alien4u Not to rub it in but template name works for me as well.

@jarens And I don't know why you need this:

renderer.templateContent = renderer.renderAsString();

@karlenigma I will have to make few more tests but I never got it to work... maybe was fixed with 2018.1?

Possibly.

Ahh my bad, you don't want to do it from the UE, ignore my snippet then =D

@rant This

functionName: "(function() {" +"window.open('" + printHandler + "')" +"})"

is not documented anywhere, also some people report it works but it may not work... the docs show you just use there the function name...

@alien4u why wouldn't it work? its just a URL. it doesn't work if you try to put a function that does something there

Because this parameter

functionName:

according to the documentation accept the function name but not parameters...

Not sure I understand... i'm not sending parameters, im just sending a long string (printHandler is a url)

function()

This is a function without name or anonymous function that will auto-return, not sure if that is going to work...

Works for me every time =D

Great, good to know...