# How to code a lookup function **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [July 9, 2022, 3:32pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400 "2022-07-09T15:32:56Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![andre2sampson3](https://avatars.discourse-cdn.com/v4/letter/a/7c8e57/32.png) [@andre2sampson3](https://community.thunkable.com/u/andre2sampson3)\ **Post date:** [July 9, 2022, 3:32pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/1 "2022-07-09T15:32:56Z")
Hello guys, I hope everyone is enjoying the weekend so far. My name is Andre and I’m new to Thunkable, learning a lot and loving it! Although, I do need some help or advice if possible? I’m trying to build an app whereby my second page asks for the users email address, it will run a search function in Airtable to check if they’re in the database, if true then they move onto the welcome back screen, and if false they will be directed to the registration screen. The issue I’m dealing with is that at first I could get to the registration screen as the “check” was false, but no info captured saved to Airtable, nor firebase. I’ve change the blocks so many times and now I’m just stuck and in need of some help. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 9, 2022, 3:43pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/2 "2022-07-09T15:43:40Z")
Welcome to Thunkable. Your question is so general but if you can show what you tried and share the project link then one can see what is doing on and provide you with suggestions. No one will know what “check” was false and in what screen and what is it for until you share the blocks or better share the project link. ---
**Author:** ![andre2sampson3](https://avatars.discourse-cdn.com/v4/letter/a/7c8e57/32.png) [@andre2sampson3](https://community.thunkable.com/u/andre2sampson3)\ **Post date:** [July 12, 2022, 5:01pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/3 "2022-07-12T17:01:25Z")
![PP1_unsolved](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/a/4a10c8e2502de1b1baf5b7c67ff08f91d737c4ac.png) In the first image the app is only supposed to do a basic check, so when the client enters their email address and click next, it will run the basic blocks ![PP3_unsolved](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/f/8f3c83fd87e1d6588812958a943162b59e4b4983.png) If their info is in Airtable, then it should take them to the Welcome back screen ---
**Author:** ![zander](https://avatars.discourse-cdn.com/v4/letter/z/ecb155/32.png) [@zander](https://community.thunkable.com/u/zander)\ **Post date:** [July 12, 2022, 6:26pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/4 "2022-07-12T18:26:34Z")
I havent used aur table but according the below link (Thunkable Air table documentation), you dont need the create object just the text. > **[Airtable](https://docs.thunkable.com/spreadsheet)** ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [July 12, 2022, 6:41pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/5 "2022-07-12T18:41:36Z")
perhaps this will be helpful for you? > [@Performing a VLOOKUP in LocalDB](https://community.thunkable.com/t/performing-a-vlookup-in-localdb/66057/20): > > [print1] I solved it using the codes from the first image. Thus, when the student clicks on his name, he pulls the “current training” column on the same line as the name and shows the column items in the listviewer. BUT I used the “access filter” block so that when the person enters, only their name appears in the listviewer, preventing them from seeing someone else’s training. But that doesn’t work, because the variable “line” is always 1, which makes each person click on their own… If you read through the thread it mentions how to do a lookup in airtable also. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [July 12, 2022, 8:39pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/6 "2022-07-12T20:39:13Z")
Do something like this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/7/273a396be7fe6b52b7242ebf54092abb025c67ff.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [October 10, 2022, 8:39pm UTC](https://community.thunkable.com/t/how-to-code-a-lookup-function/1958400/7 "2022-10-10T20:39:50Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.