Apps Script Return Values and Parsing an API Response

00:00 - Intro
00:35 - Functional Demo
01:14 - Apps Script
03:55 - JSON Path Tool
07:33 - Setting up the AppSheet Automation/Bot
10:28 - Formula to Reference the Apps Script Output
12:08 - Testing the Automation
Developers can now return values from an Apps Script directly to an AppSheet app. In this example, I outline how you can have an app user enter the name of a food ingredient and return an image of that ingredient using the Spoontacular API!
If you want to learn more about Apps Script, check out the following experts:
‪@saperis‬
‪@LaurenceSvekisCourses‬

[@AndrzejNowak1975]

Excellent example

[@AutomationWithSholz]

Awesome

[@Huynh-Tan-Quoc]

THANK YOU FOR THIS VIDEO

[@the-beauty-of-creativity2083]

thank you for this video, simple and very useful. It helped me a lot. I needed to make a http post to a external service to calculate delivery price. The sumbited data should contain different informations like weight, state, town, address, zip code, how much money should the customer pay etc. In my case, the data should be taken from fields of a newly completed form. With the help of your video and chat gpt : ) I created a function that has the variable to be sent to the external service and the values to be taken from the appsheet. They will appear only if they are put in the parantheses. After that I created an automation to be triggered when data is added after I add a step to run a scipt. I added the script and for each varible I included the dataset related to each column, after that I check return value, set it to string text then added a new step to change row value, selected the column Delivery price and in the expression field I inserted the name of the previous step [name of the previous step].[output] In my case it was import to recieve JSON data as a string and in the step that runs the script, after selecting return value to select string data type.

[@JacobSaIih]

Subscribed! Thank you for what you do) it helps me a lot considering that I don't know English and don't know how to use AppSheet 😅😅😅

[@appify]

Welcome!

[@MaakBow]

Great overview Thanks
Is there anyway to customise the delete action (or others) so its not either in the header or at the top of content. A really common device UI pattern is to have the delete button at the bottom of the edit page. delete in manny use cases is an uncommon action that should be harder to get to

[@appify]

You can hide the default delete action and create a new one that is more custom.

[@jnoz9414]

Is there a way to utilise this functionality to return say an error message to the user, for a mismatched Login/Password. I can see how to return text, but unsure how to go about showing that message in Appsheet for only that user, and clearing the value on refresh (think this is the bit I a most unsure of) or subsequent correct login

[@appify]

What is the context of the mismatched Login/Password? Are they passing a pair to the app and is the app sending that data to the Apps Script function? You can always pass the useremail() as a parameter to the Apps Script. So that way the Apps Script can return that email back to AppSheet. With that you can then associate that with the user.

[@eduardobenavides5891]

Wooow I don't knew that was posible.
Can i do the same with WEBHOOK?
Congratulation from Ecuador!

[@appify]

There doesn't appear to be a way to do this yet with a webhook.