Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Document Builder - Adobe Calculated Fields

✭✭
edited 06/14/22 in Add Ons and Integrations

Hello community,

I am currently loading a PDF that was made using adobe acrobat pro into the Document Builder as a template. There is a date field that always needs to default to today's date. I currently have the field calculating off the following script:

var today = new Date();

event.value = util.printd("m/d/yyyy", today);

However, I lose the functionality when I load it into the document generator. I have noticed if the field is not locked, I can click and unclick it in Firefox to show the date. In Chrome it doesn't show the date at all.

I cannot use a =TODAY() field in Smartsheet and map that in because (1) it is messing with the row's last modified date and (2) it will only be the date the report is generated not updated every time the pdf is opened.

Are there any work arounds to this?

Answers

Trending Posts