I like the idea, but it's still VERY early days and the integration of the type is still a little "too manual" for me. ;) - But there's a TON of potential here (especially if you bring Ai into the mix)
Make sure that you're copying the return formula output formula from your 'Get Response' automation task. - It will be at the bottom of the task, in a blue highlighted box - Something like: [__NAME_OF_YOUR_TASK__].[Output] (NOTE: if you've called your task that get's the response from OpenAI something else other than 'Get Response', you'll need to use THAT in the formula to use the return output. This should be reflected in the value you're given in the blue box.) Let me know if you have any other difficulties!
@@MultitechVisions Not working anyways. One think Ive noticed too is that your script code was different from the one the GPT generated for me. I also copied your code myself, no success
@@comercialmaqstone7343 Hm... 🤔 Fiddly bits can sometimes be a challenge. If you're following what I've laid out here, you'll want to ensure the following is just so: - The script returns an array, both items being a string - The task that runs the script (in AppSheet) needs to return an array of LongText types (make sure you set the "list" type to LongText) - In the task that records the output of the script (in AppSheet), make sure you're using the output formula from the script task - [Your_Script_Task].[output] - When actually recording the individual items from the returned array, you'll need to use Index() to extract the individual items out - To get the number into a number-type column, you'll need to wrap the Index() with a Number() conversion formula to convert the string into an integer. ----------------------------- If you have further difficulty, it's probly best to get a bit more specific information about your setup - this way I can help you in a more direct way. - Check out www.MultiTechVisions.com/Answers - You can freely submit your questions there, follow up with additional queries, include screenshots, links to videos/apps/sheets/resources, etc.
Hahaha, l know where the problem lies... it's because you selected string type under return value ( at get response), kindly change it to array and select the list as the specific type and don't forget to select long text as the element type
Extraordinario.... Gracias por todos tus aportes.
De nada!
Great 👍
Thank you 👍
Great Video!
What do you think about the new feature "Chat apps"?
I like the idea, but it's still VERY early days and the integration of the type is still a little "too manual" for me. ;)
- But there's a TON of potential here (especially if you bring Ai into the mix)
Hi, this is not working, when I insert the 2 columns and use the index expression. It returns that there isnt a Get response column.
Make sure that you're copying the return formula output formula from your 'Get Response' automation task.
- It will be at the bottom of the task, in a blue highlighted box
- Something like: [__NAME_OF_YOUR_TASK__].[Output]
(NOTE: if you've called your task that get's the response from OpenAI something else other than 'Get Response', you'll need to use THAT in the formula to use the return output. This should be reflected in the value you're given in the blue box.)
Let me know if you have any other difficulties!
@@MultitechVisions Not working anyways. One think Ive noticed too is that your script code was different from the one the GPT generated for me. I also copied your code myself, no success
@@comercialmaqstone7343 Hm... 🤔 Fiddly bits can sometimes be a challenge. If you're following what I've laid out here, you'll want to ensure the following is just so:
- The script returns an array, both items being a string
- The task that runs the script (in AppSheet) needs to return an array of LongText types (make sure you set the "list" type to LongText)
- In the task that records the output of the script (in AppSheet), make sure you're using the output formula from the script task - [Your_Script_Task].[output]
- When actually recording the individual items from the returned array, you'll need to use Index() to extract the individual items out
- To get the number into a number-type column, you'll need to wrap the Index() with a Number() conversion formula to convert the string into an integer.
-----------------------------
If you have further difficulty, it's probly best to get a bit more specific information about your setup - this way I can help you in a more direct way.
- Check out www.MultiTechVisions.com/Answers
- You can freely submit your questions there, follow up with additional queries, include screenshots, links to videos/apps/sheets/resources, etc.
Hahaha, l know where the problem lies... it's because you selected string type under return value ( at get response), kindly change it to array and select the list as the specific type and don't forget to select long text as the element type