About nico

nico · 07-21-2022

We're happy to announce an enhancement to Apps Script Tasks that will allow you to use the return value of a Google Apps Script function within your AppSheet automation and pass it to a later step in the same automation process. Example uses: Write t...

nico · 03-16-2022

We're happy to announce that Apps Script Tasks be rolling out for all users in AppSheet this week! This will allow you to natively call Google Apps Script functions within your AppSheet automation workflows, enabling your apps to tightly integrate wi...

nico · 05-01-2020

Starting next week, we will be updating our default color palette and rolling out a feature that allows you to select a custom primary color for your app along with the new option to color the footer and header you may have seen released today. This ...

nico

Your Apps Script Task configuration looks fine, can you also send a screenshot of the bot you're trying to run as well as the task/action that's reporting the error? It appears from the error message that it's looking for the `geocode Output` table w...

nico

Two ideas: 1. is the Task configured as a "string" return type in the Apps Script Task? Should look like this: 2. Like Marc is alluding to, you can only use this return value in the same process as you're calling the script in (but you can write it b...

nico

Thanks for the report, added a bug in our internal tracking system for further investigation. No ETA on it yet. Please use the workaround to set up the return value again after duplicating the task.

nico · 11-30-2023

Yes, to get individual values you can use the INDEX() function. So for example `INDEX([ReturnValue].[Base Tariff], 1)` to get the first base tariff.

nico · 11-29-2023

As an addendum, here is some Javascript code to do the transformation from an array of objects to an object with array values if you'd like (for use in Apps Script): // Any number of objects here const arrayOfObjects = [ { "Validation Status": "Valid...

My Stats

whostean's Bio

Badges nico Earned

Recent Activity

Return Values in Apps Script Tasks

Apps Script Tasks are now available: Call Apps Script functions in AppSheet Automation

Upcoming Feature: Custom Color Picker

Re: Return Values in Apps Script Tasks

Re: Return Values in Apps Script Tasks

Re: Return Values in Apps Script Tasks

Re: Return Values in Apps Script Tasks

Re: Return Values in Apps Script Tasks