Custom Functions
What is a Custom Function?
A custom function in Google Sheets is a user-defined function created using Google Apps Script, which allows you to extend the functionality of Google Sheets beyond its built-in features. These functions operate similarly to standard functions in Sheets (like SUM, AVERAGE, etc.) but are tailored to specific needs or repetitive tasks you want to automate.
How is this working on Google Sheets with Sheet Director?
In Sheet Director, the custom function is implemented to get the configured service data without even opening the addon/extension. In this way, you can directly query your app records from Google Sheets.
What are the available custom function?
Custom functions on AI Capabilities, you can perform any Generative AI-related activities using custom functions. please read more about that under our AI capabilities.
Custom functions to query app by configured service, users can easily call the configured service without opening the addon/extension.
Available Functions
GET_APP():
GET_APPDATA functions takes 6 paramters
ServiceName: Provide the configured service name (required)
Field1...n and Value1 ....n: You can pass the filter names and their respective values sequentially
Here is an example request.
** These features may not be applicable to all plans