Launching Custom Apex / Visualforce

By using the custom action function, it is also possible to call Apex code and Visualforce pages developed on Salesforce from Mashmatrix Sheet.

Invoke Visualforce Page

To invoke a Visualforce page, enter the URL in the following format in the Page URL from the Open URL action.

/apex/{Visualforce Page Name}

If it has a namespace, such as a Visualforce page included in the management package, enter the URL in the following format:

/apex/{Namespace Prefix}__{Visualforce Page Name}

Specify the parameter name appropriately from the detail setting of the action. From the Apex controller of the Visualforce page, it is possible to get the parameter value with the following code.

ApexPages.currentPage().getParameters().get('id');

Invoke Apex Code

If you want to invoke custom logic written in Apex from the Sheet, it is most effective to start it once via a flow. See "Startup Flow" for information on how to start a flow with a custom action.

To call Apex from a flow, you must have an Apex class with a static method that implements @InvocableMethod. For more information, please refer to Salesforce's help and developer documentation.