Hi everyone, I am using Airtable to keep usernames and passwords. Is there a way to find which row a specific username is in? For example, if the first username is Maria and password is puppy123, then the block would find which row the username Maria is in. (In this case it is row 1)

Hi, @mtechnovationgirlsuw ! :wave: Try these blocks - [image] Hope I helped you :blush: Good Luck! :star2: Thanks! :blush:

Thank you all! I will try both suggestions!

Is x the “username” column and is y the password??

Hi, @mtechnovationgirlsuw ! :wave: The x is the list you are providing to look up a value, and y is the value to lookup. After getting the row, use this block to obtain password - [image] These blocks might be your full blocks. Note - You can rename the do something function to “find in list”,…

In your function, why do you add the first occurence of item value with (1-(first occurence of a in list [a,b]))?

Hi, @mtechnovationgirlsuw ! :wave: I too agree, it’s senseless. But, magically it returns the perfect index. Earlier, the raw block - [image] returned the wrong index. Like, you are looking for Indiana, and it returns the index of India; what they have in common is, the first few letters (I N D I A…

Also, when I do the same code, I get an [Object object] error? What can I do to fix it?

AirTable Login Help!

Questions about Thunkable

jared February 19, 2020, 5:14am 3

If @kartik14 suggestion does not work, or you’d like to see another approach. See my post on that Here

Topic		Replies	Views
Airtable Find row number based on text input Questions about Thunkable	5	1292	November 8, 2024
[SOLVED] I want to make a login system with the air table, but I have a problem Questions about Thunkable beginner , airtable	5	193	May 30, 2024
How do you use air table to target a particular cell Questions about Thunkable	3	474	November 8, 2024
[Solved] Getting the Row number of a particular name in Name Column of Airtable Questions about Thunkable solved , lists , airtable	12	1945	November 8, 2024
[Solved] Help with the Airtable Questions about Thunkable solved	5	510	November 8, 2024

AirTable Login Help!

Related topics