Firstly forgive my naivety, but I'm fairly new to the use SuperOffice, but as I'll use it extensively in the upcomming months, I'm looking for an answer to a question, which may optimize my ongoing data extraction. I couldn't find another post on this topic, so I'm adding one now.
Each week I've to extract data from SuperOffice into an Excel-file.
The standard approach to doing this in our company, has been to use the "export" button shown below.
However, I'd like to make my Excel-sheet a bit more advanced if at all possible and to automatically import data into Excel from SuperOffice, by using the tools in Excel shown below:
I've made data-connections between sheets and used PowerQuery - But I've never managed to establish a data-connection to a website or a CRM-system such as SuperOffice. My question therefore is, whether it's possible for me to establish this data connection - and if it is, how do I do it?