AnsweredAssumed Answered

How can I export only some fields of a database record to an external Excel file?

Question asked by ChristofBirkenmaier on Jul 27, 2015
Latest reply on Jul 29, 2015 by ChristofBirkenmaier

Title

How can I export only some fields of a database record to an external Excel file?

Post

Hi there, I am back after a long stretch of no unresolved issues. But this one is to hard for me and I couldn't find an appropriate answer in the forums:

My database is rather complex and efficient, it does many things by the click of a button.

But for every record that I process, I still need to fill out an external Excel spreadsheet and submit it together with the email that my database generates automatically.

Since there are really only 4 fields I would need to export (name, first name and 2 dates), I believe there should be a way to also automate this part of the process.

Is there the possibility to (by button or script) to open a new Excel spreadsheet from a pre-designed Excel template file and to automatically take the contents of these 4 fields only and fill them into the matching fields of the Excel spreadsheet?

So the idea being that there is a pre-designed Excel template file which will be used to generate an individual Excel file for each database entry, when a button is pressed or a script is called.

Thanks! Chris

Outcomes