@Marc_Dillon wrote:
You use dereference notation. You have given your 'call a script' task a name, I always use "script" to make it easy, and you would have also named the returned values in the return values config section. So then in a subsequent task you'd use [script].[value]
This is only if the return is an object.
In the example I provided, instead of returning an object - which allows you to include multiple data types, but it can be more technical in the implementation - I instead return an array.
- If you return an array, all types have to be the same; this is why in the script example, you can see I'm converting things to a string
If you return an array, then your dot-notation in subsequent tasks to get returned values is:
- [task_name].[output]
- Same for any regular return value as well
----------------------------------------------------------------------------------------------------------------
@Marc_Dillon wrote:
This is described in the following article:
https://support.google.com/appsheet/answer/12309564?hl=en
Best option:
Copy the contents, go to ChatGPT, paste and ask it to help you. 🤖🧠💪
LinkedIn
Twitter
