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.
1 person found this helpful
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.