DO NOT USE THIS TAG ALONE. Unlike built in functions where the functions are designed by the product designers for mass use, Custom functions are functions that are custom designed for only a subset of end users. Use for questions relating to such functions along with the product in question(eg [sql], [google-sheets],[excel]).
Questions tagged [custom-function]
545 questions
4
votes
1 answer
Toggle out of stock items on front end - woocommerce
I wish to include a button on the website so that users can toggle out of stock items on and off.
By default, I want the out of stock items to be false. When the user browses around I need the setting he applies to be consistent. Is this…

Stephen Said
- 97
- 7
4
votes
4 answers
Jmeter: How to reuse custom java function between different JMX file
Requirement: Post response time of every sampler to Mongo DB, for that created an HttpClient java code(Class function).
Problem: Need to call the custom (reuse same code between 150+ jmx file) Java function to be called from Beanshell after every…

Load Stitch
- 167
- 2
- 11
4
votes
2 answers
Update ImportJSON automatically
I setup importing JSON to Google Spreadsheets by following this sweet Medium tutorial.
It does it's job well - taking this API call
[
{"day":"2015-08-05","new_users":103},
{"day":"2015-08-06","new_users":255},
…

davegson
- 8,205
- 4
- 51
- 71
4
votes
3 answers
How to use for to sum a range in google app script?
I want create a simple custom sum formula in google Spreadsheets using google app Script.
function somaDias(range, days) {
var sum = 0;
for(i=0; i

user3347814
- 1,138
- 9
- 28
- 50
4
votes
1 answer
Not allowed to execute sendEmail() from custom function, but OK in script editor
I have been trying to find a way to send single row of data to a specific email address in a "live/running" spreadsheet that I am using within my domain, to keep track of truck drivers and their pick up numbers. I managed to piece together this…

DaxqWork
- 41
- 1
- 3
4
votes
2 answers
Calling a Google App Script library from a Google spreadsheet cell
Trying out the new library feature in a Google spreadsheet. I have include a library with the identifier of "Test" and the library implements the function "foo()"
entering =Test.foo() into a spreadsheet cell gives the error : "unknown function…

Hilo
- 869
- 2
- 9
- 24
3
votes
1 answer
Function Returning #NUM! Error When I Call It from a Cell
I have a function that has two passed in parameters--one is a single number from a single cell, and the other is a range, but all numbers. The function calculates the percent change between each of the passed in numbers and finds the average. It's…

j450n
- 33
- 2
3
votes
1 answer
Putting a levene test and two-way ANOVA into a user-define function in R
I have been trying to make a custom/user-defined function to perform a levene test and a two-way ANOVA. I am struggling to make the formula factors unique in the {aruguments} in the function. After looking at this post:
Error: Custom function that…

MM1
- 478
- 15
3
votes
1 answer
How do I take a custom function and use it with dplyr group_by in r?
Sorry for asking the same type of question, but I just can't wrap my head around how to take my custom function and iterate it over grouped data. So bonus points if anyone can point me to some in-depth resources.
This works as…

seansteele
- 619
- 3
- 10
3
votes
1 answer
AppScript UrlFetchApp quota limitation
I currently have an Apps Script Editor add-on that works with Google Sheets. It has a custom function implementation that uses the built in UrlFetchApp.fetch() to fetch external data. The add on is growing quickly and pretty much daily I'm seeing…

Sheldon
- 175
- 9
3
votes
0 answers
Google Sheets Workspace Add-on versus Editor Add-on for custom functions
I have a published Editor Add-on for Google Sheets. It is deployed via the Sheets Add-on section within the App Configuration page of the Google Workplace Marketplace service on GCP.
I have been thinking about moving it to a Workspace Add-on in…

George Dietrich
- 39
- 1
3
votes
1 answer
How to call a Google Sheet formula from within a custom function?
Is it possible to call any of the Google Sheets formulas from within your own Google Apps script custom function? If so, how?
It obviously doesn't work to merely use the formula name like you would inside the sheet. Like this, which is what I was…

Magne
- 16,401
- 10
- 68
- 88
3
votes
1 answer
How to fix a function to get the text color of a cell
I have created a function to get the text color of a cell when I insert the formula in another cell. My aim is to filter rows by color.
Steps:
1. Create the code:
function getHex(input) {
return…

Bernardo Giarola
- 303
- 1
- 2
- 9
3
votes
3 answers
How to get the user property for the "active user" in google apps script custom function
I've published a Google Apps Script standalone spreadsheet add-on, while I met some problem using PropertiesService.getUserProperties() in a custom function.
If User A has installed the add-on and saved some data in the user property.
Then User A…

Frank
- 159
- 3
- 14
3
votes
4 answers
Replace placeholders in text by referencing a translation variable
I'm trying to remove eval from the following function. I tried with sprintf and ${} , but still cannot find a solution.
Here the function:
function parseDbString(string $value = 'Looking for a good {{ $pippo }}'){
$pippo='Pizza';
return…

Vixed
- 3,429
- 5
- 37
- 68