Mass-managing Field-Level Security Settings

Assign Access Rights to your Fields Quicker Announcing another great addition to our Windows version of XL-Connector (COM add-in): a new tool to mass manage Field-Level Security for your Salesforce fields…

Terms of Service

Last Updated: June 17, 2022 Terms of Service (“ Agreement ”) constitute a contract between Xappex LLC (“ Xappex ”), and you, the customer that has signed up for the…

Xappex’s Sub-processors List

      Sub-processor Purpose Data centers Amazon Webservices, Inc. Cloud infrastructure provider for XL-Connector 365 and Xappex’s customer portal. US SendGrid, Inc. SMTP for sending emails to our customers.…

Integration with Accounting Seed

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…

Integration with AccountingSeed

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…

In XL-Connector version 3.3.6.7

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…

Utilizing Web Hooks to trigger automatic jobs

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.…

Using Custom Formulas to Dynamically Pull Data From Salesforce

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…

In G-Connector version 210302

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…

In XL-Connector 365 version 1.8.8

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…