This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

*FreeMarker templates:* If I have this list (screenshot below), and I declare

&lt;#list record.apply as apply&gt;

Should I then be able to declare

apply.tranid

and get the value of the tranid field on the Bill record?

This if statement &lt;#if apply.tranid?starts_with("PO28")&gt; is failing because it can't see apply.tranid (coming back as empty/blank). It appears there are multiple fields that cannot be pulled out from apply (record.apply) and I can't work out why.

Have you tried printing out the different keys? is tranid really available? <#C466X49JB|> <https://freemarker.apache.org/docs/ref_builtins_hash.html#ref_builtin_keys>

I've always delegated freemarker until today, I'm just learning it.

so does record.apply give me access to all fields on the related record?

Yeah, looks like it doesn't. How do I know what it does and does not give access to?

Hey, this is <#C29HQS63G|> Slap on a beforeLoad that runs on PRINT and add whatever you want :slightly_smiling_face:

If there was a field not in the above list, is there a way to get that field?

I'm a hammer and everything is a nail afterall!

Dealing with this same type of issue with email templates. Gave up and wrote a ue script that just pastes all the fields i need in a text area on the record, then use a ?eval_json on that field.

How are you pushing the fields back to the template?

add a custom field to the form on beforeLoad and set a defaultValue on it with whatever you need. Usually a JSON.stringiify(Object). Then run eval_json as Nathan wrote.
custpage_your_field?eval_json.

<https://freemarker.apache.org/docs/ref_builtins_expert.html#ref_builtin_eval_json>

```// get the custom field value with the strigified json object
&lt;#assign emailObj = transaction.customFieldName?eval_json /&gt;

// reference the fields in the emailObj
${emailObj.subsidiaryName}```