Hi! This plugin is working great for me. Quick question - is it possible to add support of the excel file to be emailed? I would like to be able to run the export in a backend workflow and email the result to the user.
hi, I just started trying it out and so far I like it. a couple questions:
I have a varying number of rows and of columns (this is a time shift report, where thereās one row per employee, one column per date (user selects the date range, hence why the column count also varies):
is there any way to add an āarray of arraysā with this entire matrix? (I have a JSON I generated w Javascript)⦠otherwise,
or, a way to iteratively add each row? (or, each column)
also, are there plans to add capability to add images, or alternatively, to add pre-built xlsx templates?
quick update on my question above regarding the array of arrays, I was able to get this working with a loop using listshifterKW. if anybody needs a walkthrough lmk, it is fairly simple
seems to me like having the ability to start with an uploaded template would address a lot of peopleās wish lists. adding filters, conditional formating, etc etc etc, basically limitless. not sure how difficult that would be.
that said, the current functionality works well. and I had looked at all other plugins, didnāt find some of these features I needed in any other one. good job!
Thank you @alfonso.galindo for using my plugin!
I was going to suggest listshifter for your first question, Iām happy that you found the solution by yourself!
Right now Iām probably going to invest some time in improving this plugin, adding some functionalities such as conditional formatting, images, etc.
Maybe Iāll add the chance to upload a custom xlsx and edit that.
Hello @shashi , I just implemented that feature. When downloading a file, flag the field āJust create linkā.
The user will not download the xlsx, but the file will be accessible in the Bubble element state āExported fileā. An event (āFile url generatedā) will be triggered when the file is ready. Use that to send it via email
Hey! This is great - thanks! I tested it and it works really well.
Other than being able to email instead of download, the other reason I was thinking to have this run as a background workflow is because some of the data processing Iām doing (eg: collapsing a sub-table into a single field using āformat as textā) takes a while, and the plugin times out if there are too many records. So I thought if thereās a way to offload that processing to a background workflow and then emailing it to the user, that would avoid any issues with how long it takes to export.
Since the plugin uses a UI element, Iām not sure if itās possible to move it to the background, but figured Iād ask anyway!
Thatās true, right now you need the UI element to generate the XLSX. But I think that a process that runs in the background could be very useful, Iāll see what I can do!
just an idea, maybe you could trigger the data processing you are doing in the background, say whenever the user requests the report⦠then at the end of that backend workflow, you could set a state in the front end (call it, āreport readyā) to yes, which will then make a appear a button ādownload reportā in the front end⦠and once user clicks that ādownload reportā button then the XLSX workflow starts, pulling the processed data from some intermediate place where you saved the data that you staged in the backend workflow?
@alfonso.galindo - thank you for this idea. My one question about this is: how do you set the state of a front end element when a backend workflow completes?
@alfonso.galindo, I tried this out and it works! Thanks for the tip.
@Cosmic.Steve - Iām getting an excel error now when I open my excel export file.
And then if I say Yes, I get this:
If I View, I get the following xml file:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">.
<logFileName>
Repair Result to [redacted]
</logFileName>
<summary>
Errors were detected in file '/Users/[redacted]/Downloads/[redacted]..xlsx'
</summary>
<repairedRecords summary="Following is a list of repairs:">
<repairedRecord>
Repaired Records: Cell information from /xl/worksheets/sheet1.xml part
</repairedRecord>
</repairedRecords>
</recoveryLog>
Do you know what could be causing this? Am I doing something wrong? Happy to send you the document and more details separately if that would be helpful.
Thank you @shashi for your feedback. That is typically an issue with some formulas. Please send me some details via PM and Iāll be happy to help out.