Invantive Control is an Excel add-on which allows two-way synchronization between Excel and traditional databases as well as cloud-based applications, using native SQL or Invantive SQL. Include SQL statements and/or block definitions to reproduce the problem, when possible on the reference database Dummy. Also include appropriate tag(s) for the platform you are querying, like exact-online or freshdesk. For product use questions use Super User.
Questions tagged [invantive-control]
32 questions
0
votes
1 answer
Alternative approach to parameters in Invantive Control to control query outcome
I would like to use parameters in Invantive control.
For example, I would like to retrieve only the hours, of Exact Online Project management which, are in the given data parameters.
Bram Reemers
- 99
- 4
0
votes
1 answer
Performance of many Exact Online excel formulas for sales transactions
We have an Excel spread sheet which has horizontally all financial periods considered (13, one year plus one month) and vertically a list of article codes. The intersecting cells contain the sold quantity in that period of an article, using General…
Guido Leenders
- 4,232
- 1
- 23
- 43