Hi, I was wondering if there was a way to set up some form of task or other function that would take a table view, turn it into a csv, and then email it automatically in a given time interval? I have a table view in my app with the setting enabled that allows a user to export it as a csv file. Would it be possible to have the app itself generate the file and send it in an email? If this is something that can be done using the API, code I can copy would be helpful since I’m unfamiliar with Javascript and CSS.
Definitely not a native Knack feature
Highly likely to be a code based solution but it’s beyond my “snippet” skills and ChatGPT help.
Hi @Evelyn, it should definitely be achievable through a bit of code.
I imagine the following workflow:
- User filters a grid (optional) and clicks a menu button above the grid that opens a form.
- On form load, the grid data (with filters) is retrieved, and created into a CSV file which gets stored in a hidden file input on the form
- The user enters the email address to send to and clicks submit
- The recipient receives an email with a link to the file (stored in Knack and not as email attachment)
Feel free to DM me if you’d like my assistance!