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?
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.
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.
form1.#subform.CurrentDate::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?
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.
Europe, Middle East and Africa