Document Builder - Adobe Calculated Fields

11/10/21
Answered - Pending Review

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

  • Hi @Hannah E.

    This sounds like unexpected behaviour and potentially a bug; the Document Builder shouldn't affect PDF Fields that are not being mapped. Please reach out to Smartsheet Support with a screen recording and a copy of the PDF file so they can troubleshoot this with you in a private channel.

    Thank you!

    Genevieve

  • Hi! This must be a mistake. Try to write to Smartsheet support or change the data manually.


    Marketing specialist

    www.worktime.com

Sign In or Register to comment.