Title

How do you export multiple related tables with 1 email??

Post

Hi

I am developing a number of forms that all utilize multiple relational tables. On the iPad I want to export all tables to xls and email. Some of my forms have 6 or more tables and I have only been able to export one table at a time to date. Very inefficient!!!

How can I export multiple tables in one email?? or is it possible to roll up several tables as "sheets" in one xls file?? or can you zip several files into one and email that one attachment??

None of my forms are single tables so sure hoping there an example of some script out there that will do this!!

The form is being used by users with limited tech skills and we wanted to create a button that rolled their days field collection up into an email attachment. There are 6 tables for this particular form we are working on currently.

The data is ultimately going into an MS Access database and we have a developer that has already created a script that will import xls spreadsheets from a folder or zip file and import them into the Access database appending them to the appropriet tables.

I am definietly open to other suggestion for this process as this is a common challenge on a number of forms we are developing? CSV or XML perhaps ??

That is an option we can fall back on but unfortunately not very efficient for us as we want the iPad user to be independent and be able to upload their days work to MS access on there own. Sending the files all to one computer means one person has to do all the uploads and this is not very workable for us.