I understand from documentation that there is no Servoy script for exporting records but I can't imagine it's impossible since this is so core. I want to duplicate a functionality I have in FM like this:
A user selects and sorts a found set and then exports a text file and then uses send message to open up an Excel template that is set to auto-import that text file (through "get external data"). This way, users can, with 1 click, work with their data in Excel, without having to go through a manual export and manual import into Excel.
There are also a 100 other ways in which I'd like to script imports and exports, like users who need to import data from a partner company each day, etc.
Would love to know how. Thank you.