Can't get a value using GET A ROW

(Ilaria Di Lecce) #1

Hello,
I’m trying to verify what value there is in a specific column in order to ask a specific question to the user.

The process I’ve used is:

  • Search if the user is already registered
  • Get the row selecting the column (without inserting the value because I want to know which value there is in)
  • Ask a question based on one of the type of values I know it could contain.

The problem is that it doesn’t run the question like it can’t find/verify the value. I’ve also tried to add GET THE ATTRIBUTE before asking the question, but the result is the same. Am I doing something wrong?

(Karen Barker) #2

Hi @Ilaria_Di_Lecce,

When using the Get A Row option with Google Sheets if you specify a column you do need to include the value that you are expecting in that specific column. Is the row you’re looking for the same row as when you search if the user is already registered? If so then the output of this task would give you the value of the column that you could use without needing to Get the row again.

If this isn’t the case can you give me a little more information about how the sheet is filled in and what rows you are hoping to retrieve. :slight_smile:

(Ilaria Di Lecce) #3

Hi Karen,
here I attach a screen in order to be clearer.

I want to find if the value in the blue cell is “Yes” or “No”. To do this, I check the user registration through Search a row and then Get a row referring to the same row and column named “abb x4 - si/no”.

(Karen Barker) #4

Hi @Ilaria_Di_Lecce,

Your search row will return every value stored in that row. To access it you’ll be able to use the Flow XO icon on the right hand side of any input field in order to view the possible outputs. As part of the Search Rows outputs you’ll see your column name “abb x4 - si/no”. If you click on this then you’ll be able to use the value as a filter for your question you need to ask next. :slight_smile:

(Ilaria Di Lecce) #5

It works! Thank you :slight_smile: