Bruce Robertson emailed me off list with an improved version of my demo from part 1, excel exports, part 1.1, which I am sharing with his permission. The improvements are…
a) live preview fields showing the data to be exported.
b) an “Eval Error Tester” script to make sure the output code in the alias table is well-formed.
Thank you Bruce for making this available.
3 thoughts on “User-Friendly Excel Exports, part 1.1”
Im trying to implement your technique to my database. but if Im giving a different name to the CON table the calculation fields (zz_xl_01 – zz_xl_10) giving me a question mark result (?).
Can you please help me so that it will display the right data on the specific field.
Thank you so much.
Make sure the table occurrence portion of your entries in aliases::output exactly matches the table occurence name you are using for Contacts, e.g., if your table occurrence name is “Contacts” instead of “CON”, then each entry in the aliases table should reference “Contacts::” rather than “CON::”.
Hope this helps,
Thank you so much. That solved my problem.