Getting a value from Google Sheets based on another value in the same sheet

(Yun) #1

I intend to get the value inside the cell highlighted in blue from the image above.

However, the code that I’m trying to use is not working:

{{connect_to_stocks_for_chicken.results_+_gsx:type == 'Wings'}} + {{connect_to_stocks_for_chicken.results_+_gsx:description 1}}

Are there any other ways that I can accomplish this action?

(Kellsey Shaw) #2

Hi Yun,

You can’t perform operations on Google Sheets results, sorry :disappointed:

If you were to use the results in the Code service you could parse them as an array and then loop through the array until you found the matching row. :thumbsup:

(David Planchot) #3

I’ve found a solution. You have to create a sheet for each 2 second value you want to search.
After, you will create a trigger “search row” and you will filter with your variable.
Exemple:Create a sheet with only type “Leg”. and create a second sheet with only type “Wings”.

Then, create a trigger “search rows” and search in the sheet “Type:Wings” with the filter : Type=Wings :slight_smile:

(Botdude) #4

Do you mind showing how to do all that from scratch? that sounds good

(Daniele Spadafora) #5

hi @David_PLANCHOT, can you share with us your flow?
Thank you

(Rotakoi) #6

well , there is a easier solution but i guess no one care , you just have to use get a row and search a row together :roll_eyes: