Expand my Community achievements bar.

SOLVED

Custom Objects: Current Date and Spreadsheet

Avatar

Level 4

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?

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

4 Replies

Avatar

Level 4

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.

Avatar

Level 10

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

Avatar

Level 4

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?

Avatar

Correct answer by
Level 10

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