Custom Objects: Current Date and Spreadsheet

[sbudlong]

On an otherwise normally functioning form, there are two custom objects, both Current Date fields, which do not appear at all

when I Merge Data Files into Spreadsheet in Acrobat X Pro. Both fields are set to Calculated-Read Only and Runtime Property

of Current Date/Time. Is there a way to include the Current Date/Time value when the file is merged into a spreadsheet, maybe

with the script editor? And why doesn't a Current Date field show up in a spreadsheet?

[sbudlong]

I think I recently asked a similar question. I'll go back to that thread and see what I can learn. It would be great to have the current Date/Time stamp

included in the data which is exported to a spreadsheet. Then the users don't have to input this information.

[Niall_O_Donovan]

Hi,

Check that the two objects are set to a Name/Mormal binding in the Object > Binding palette. In addition, I am not sure if Master Page objects get exported to a spreadsheet. You would need to test.

Niall

[sbudlong]

Thank you, Niall! While I explore various possibilities, I'm wondering if it's possible to force the issue by using FormCalc or Javascript in the Script Editor, with something along the lines of this

form1.#subform[0].CurrentDate[1]::ready:layout - (FormCalc, client)

$.rawValue = Concat(Num2Date(Date(), "YYYY-MM-DD"), " ", Num2Time(Time(), "HH:MM:SS"))

Do this in a text field of some other object and basically create an object that does what I want it to do and the value of which will show up in a spreadsheet, just like other values (checkbox, text box, radio button, and so on).

What do you think?

[Niall_O_Donovan · Accepted solution]

Hi,

Once an object's binding is set to Name/Normal, then it should participate in the export to the spreadsheet. If you drag on a CurrentDate object from the Custom Library; select it and go to the Object > Binding palette, you will see that the binding is set to None/No data binding.

If you want an object to export, you must set the binding.

Niall