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 X

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 X	4	1300	February 12, 2020
[SOLVED] I want to make a login system with the air table, but I have a problem Questions about Thunkable X beginner , airtable	4	198	May 29, 2024
How do you use air table to target a particular cell Questions about Thunkable X	2	479	January 8, 2019
[Solved] Getting the Row number of a particular name in Name Column of Airtable Questions about Thunkable X solved , lists , airtable	11	1962	December 25, 2020
[Solved] Help with the Airtable Questions about Thunkable X solved	4	520	November 27, 2019

AirTable Login Help!

Related topics