4 Replies Latest reply: Mar 12, 2012 1:06 AM by Niall O'Donovan RSS

    Custom Objects: Current Date and Spreadsheet

    sbudlong Community Member

      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. Re: Custom Objects: Current Date and Spreadsheet
          sbudlong Community Member

          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.

          • 2. Re: Custom Objects: Current Date and Spreadsheet
            Niall O'Donovan Community Member

            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

            • 3. Re: Custom Objects: Current Date and Spreadsheet
              sbudlong Community Member

              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?

              • 4. Re: Custom Objects: Current Date and Spreadsheet
                Niall O'Donovan Community Member

                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