Probably already discussed, but I really need ask ...
# advancedpdfz
Zoran Roncevic
03/25/2021, 9:32 AMProbably already discussed, but I really need ask again > Customer has customized Invoice Advanced PDF Template. There is one additional set of data, doesn't matter saved search or sublist (child records). They want to continue with using standard actions (print, email) for invoice. I have some solutions with custom script (button on the form, suitelet with rendering and adding datasources to renderer) but it is very hard to administrate this. And questions are
ā¢ is there any solutions to add additional list to record object (record object in Advanced PDF Template). What if we create custom record, make Invoice as parent, is there option to reference that sublist something like <#list record.rechmachparent_field as mylist>
ā¢ I tried, but without success, create Before Load event for invoice, and add there some object : newRecord.myobject = [{....}, {....}] and after that tried to reference in PDF Template record.myobject ... as excpeted no success
ā¢ I tried to create Inline HTML field š and again inside Before Load event, put some HTML content (just for testing), put record.myInlineHTML field in PDF Template, and as expected unfortunately, NetSuite print content as string
Any idea for this ... Once again, do not suggest scripting from the scratch, we already use that for other customer requests, and we are familiar with that. We are asking for injecting data or adding custom sublist to "standard" PDF Template functionality
s
Selcuk Dogru
03/25/2021, 10:39 AMyou should be able to add a field on before load and set value through user event script. that field including the value then becomes available on the PDF template. make sure you filter the execution context to user event so it will not run unnecessarily on record view, edit, etc.
z
Zoran Roncevic
03/25/2021, 10:45 AMThat's work... but only value from that field can be printed... Trick I was tried is InlineHTML field, and expected to "inject" html content in result of rendering. But, NetSuite do escaping string, and I got literally string value
s
Selcuk Dogru
03/25/2021, 11:12 AMI had a similar scenario. below code in the PDF template should do the trick:
<#assign fieldData = record.custrecord_field_id?replace("<", "<")?replace(">", ">")>${fieldData}Selcuk Dogru
03/25/2021, 11:13 AMI had my html content in a text area though, not inline html field
z
Zoran Roncevic
03/25/2021, 11:32 AM@Selcuk Dogru Wow it works
Zoran Roncevic
03/25/2021, 11:32 AMfyi, InlineHtml works also
Zoran Roncevic
03/25/2021, 11:33 AM Copy code
const beforeLoad = (scriptContext) => {
newRecord = scriptContext.newRecord;
newRecord.myobject = '[{"kljuc" : "Vredmost"},{"kljuc2" : "vrednost2"}]';
newRecord.setValue({
fieldId : 'custbody_rdata_inline_html',
value : '<p>Text</p>'
})Zoran Roncevic
03/25/2021, 11:34 AMmy favorite solution will be how to send JSON as string and then parse it inside Template
Zoran Roncevic
03/25/2021, 11:38 AMI found this example
Copy code
<#assign beer_json_string = '{ "name": "Imperial Stout", "description": "Tasty Stout Beer"}'>
${beer_json}
<#assign beer_map = beer_json_string?eval>
<p>
${beer_map.name}
</p>s
Selcuk Dogru
03/25/2021, 11:42 AMš you got yourself another challenge
w
Watz
03/25/2021, 7:39 PMYou can add a custpage_yourfield in before load as a long text. Insert a stringified object in it and then ?eval it. Note that it can beach sensitive to null values.
Watz
03/25/2021, 7:43 PM