Get data from cell in a different column but same row from first column check

[Choofa]

Hi there.
How could I make this possible. As you can see I have users(email) in Column “ID” and nicknames in column “Nicknames”.
When users pick their mail it gets data from column ID and checks if it is in list(as it creates). This works, but I want to get the data from the cell from same row as ID but from column “Nicknames”. How to do this, I have tried a few ways, but it always fails.

Any idea?

[Choofa]

I have tried this also now, but guess I’m doing something wrong

[oaltair]

Hi, I have several suggestions:

1. The ID variable must not be a LIST
2. “values” is a list, so you just have to assign it to the variable ALL_ID
3. You can get the “Row ID” by looking for the index of the ID in the ALL_ID list.
4. It uses the index obtained as parameter “Row ID” in the GET CELL block.

Best regards

[vknow360 (Sunny Gupta)]

Hi
As you want to get row id to get cell so use index in list block.
Just use ‘index in list’ block in ‘get cell’.

[Choofa]

@oaltair

Hi, I have several suggestions:

1. The ID variable must not be a LIST
2. “values” is a list, so you just have to assign it to the variable ALL_ID
3. You can get the “Row ID” by looking for the index of the ID in the ALL_ID list.
4. It uses the index obtained as parameter “Row ID” in the GET CELL block.

Best regards

Perfect Worked like a charm

[oaltair]

I’m glad you found my help useful.

Here’s a similar way to do the same thing

[Choofa]

What is respons code, and why 200?
And what does it mean in the index in list not equal to 0 blocks?

[oaltair]

What is respons code, and why 200?

Log in to Airtable, open your database and go to "Help/api/errors

[Choofa]

@oaltair

What is respons code, and why 200?

Log in to Airtable, open your database and go to "Help/api/errors

Aaaaah, so THAT’S what respons code are, never used before cuz I had no idea what it was for, ty for this tip/info

[oaltair]

And what does it mean in the index in list not equal to 0 blocks?

“index in list…” returns a number, this is the index of the item searched for in the list.

[Choofa]

Yes I know, but why not equal to 0? Cuz the list don’t start at 0 but 1?

[oaltair]

That’s right, it starts at 1.

[vknow360 (Sunny Gupta)]

Yes I know, but why not equal to 0? Cuz the list don’t start at 0 but 1

‘Index in list’ returns 0 if item is not in list.
So to avoid runtime errors there is a ‘not equal to’ block.