DigiXport will store all the saved queries in a single saved _queries sheet. (even if you have a different sheet as the destination sheet).
How To Quickly Refresh All Queries?
Option 1:
You can click on DigiXport > Run Saved Queries. Once the modal opens, you can type your query name and click on select all. After selecting, simply click on Export Selected Queries.
Currently, there are 2 options available in the modal:
- Export Selected Queries
- Delete Selected Queries
Option 2:
The other option available is you can go to the scheduling tab in digixport UI. Then click on Test queries.
You can follow the same instruction as above.
How To Quickly Refresh Queries from the current sheet?
You can simply click on the DigiXport > Run Saved Queries. That will open a pop-up where you can click on select current sheet queries.
That will select the queries which have the destination sheet as the current sheet. Then click on export selected queries
Another option is to Open Sidebar, Got To 3rd Tab, Click on Test Queries and then follow the same process as above.
Why are some Queries missing from the dropdown?
On clicking “Test Queries” a modal box will open & validate your queries. If all the queries are valid, they will be populated in the dropdown.
If you don’t see all the saved queries, the reason might be as follows:
- Only the queries (from the query sheet) starting from the cell A8 to the bottom will be populated in the dropdown.
- If you are a user with a free plan, only a single active query will be populated.
- If the queries are turned off, they won’t be populated.
- If the queries are not saved in the query sheet, they won’t be used.
- If the queries are deleted or missing from the query sheet, they won’t be populated.
- If you edit the query directly from the sheet and if there is any error (EG: formatting error), they won’t be populated. If the queries are present in the sheet and not getting populated, the error reason is mentioned in the status column.