Hello,
I try to to implement Creator to get rid of excel spreadsheets in our everyday business workflows. However, we still need to deliver some documents in Excel format to some customers.
I used another "low-code forms application" (DoForms) which allowed me to populate a "preformated" excel file, with forms data.
This by upoading an xls template with the "data name", (or "link_name" in zoho) prepopulated to certain cells. This would give me in return an xls corresponding to the record, with data populated to dedicated cells (even with images).
Is there a way I can do this "easily" with Creator ?
the reports "xls download" option does not fit this need.
Do you have any ideas ?
Some ways of exploration maybe :
- through direct ODBC connection to excel ? is this available ?
- through a SQL server to which I connect in ODBC ? (cumbersome, I want low-code !)
- through some API magic ? (need to learn)
Many thanks for your answers !