Main differences between XL-Connector and XL-Connector 365: XL-Connector 365 works in any Excel (Excel for Windows, Excel for Mac, Excel Online), while XL-Connector only works on Windows XL-Connector 365 can…
If you are utilizing the AccountingSeed application, XL-Connector provides a way to pull summary Financial Cube data using cell-level formulas. The formula syntax is as follows: =XAPPEX.ASFC(“<Ledger>”, “<GL Account>”, “<GL…
If you are utilizing the AccountingSeed application, G-Connector for Salesforce provides a way to pull summary Financial Cube data using cell-level formulas. The formula syntax is as follows: =ASFC(“<Ledger>”, “<GL…
Users utilizing multiple Salesforce orgs will find this particularly useful, but even if you are logging in to the same org every day, logging in via SSO takes some time…
Web Hooks provide the ability to run G-Connector operations on demand from anywhere: your custom Apps Script, your web site, your server, anywhere you can issue a POST request from.…
G-Connector has a built-in formula that you can use to run SOQL queries to populate cell-level data. Here’s an example of one: =RUNQUERY(“SELECT sum(amount) FROM opportunity WHERE stagename =’”&B1&”‘”) This…
You can now view and manage all your data sources across all workbooks using the new Manage Data Sources function: The monthly schedule now has an option to select the last…
You now have an option to disable some of the report columns when pulling and refreshing reports from Salesforce: New possibilities with using Dynamic SOQL. The following syntax is now…
You can now view and delete all your data sources across all workbook with the help of the new Manage Data Sources feature:
bool LogInWithAlias(string alias, out string error) VBA call is now available. This will help you build automations without keeping the login information in your script. You can now control which…