# Airtable Query: Project on e-voting
**URL:** https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148
**Category:** Questions about Thunkable X
**Tags:** beginner, airtable
**Created:** [September 1, 2020, 10:58pm UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148 "2020-09-01T22:58:27Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 1, 2020, 10:58pm UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/1 "2020-09-01T22:58:27Z")
In order let my users log into the application, they require a number and a password. These are saved on my airtable spreadsheet.
Here is what it looks like;
Note: the other columns are irrelevant at the moment.
I am unsure of how to query the airtable to retrieve the data.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [September 2, 2020, 7:23am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/2 "2020-09-02T07:23:31Z")
See [https://airtable.com/api](https://airtable.com/api)
---
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 2, 2020, 8:00am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/3 "2020-09-02T08:00:11Z")
I already connected it to my Thunkable app, I just need help in the block coding
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [September 2, 2020, 10:01am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/4 "2020-09-02T10:01:08Z")
@avantika.chopra1989a sounds like a great idea for an app. If you ever need information on one of our components take a look at our docs!
For example, here are the Airtable docs:
[https://docs.thunkable.com/spreadsheet](https://docs.thunkable.com/spreadsheet)
Hope that helps!
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [September 2, 2020, 10:01am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/5 "2020-09-02T10:01:11Z")
See scrAirTableRESTAPI in [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/)
---
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 4, 2020, 5:54am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/6 "2020-09-04T05:54:10Z")
Hey this was really helpful, however I need to run everything in the back end. The UI looks like this;
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [September 4, 2020, 7:19am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/7 "2020-09-04T07:19:40Z")
I’m sorry, but I’m afraid we don’t understand what you need.
You write
> I am unsure of how to query the airtable to retrieve the data.
Didn’t we give you the answer to that question?
---
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 4, 2020, 7:56am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/8 "2020-09-04T07:56:41Z")
Yes could you help come up with specific code for this screen only so I can keep it as a sample for future school projects?
Also I needed code for querying the database so that I could build a log in page. Lastly, I can’t use the regular sign up block as there is a number, not an email address
---
### Author:  [@gobassky](https://community.thunkable.com/u/gobassky)
#### Post date: [September 6, 2020, 10:09am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/10 "2020-09-06T10:09:49Z")
Sign up block is for firebase authentication. You simply just need to take your airtable data and with a few conditional blocks, you can make an effective log-in.
---
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 6, 2020, 12:59pm UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/11 "2020-09-06T12:59:18Z")
I’ve coded till here. However, In order to validate the password, I need the row number of the ‘aadhar card value’ that the user had input. Not sure how to do that.
---
### Author:  [@gobassky](https://community.thunkable.com/u/gobassky)
#### Post date: [September 7, 2020, 12:52am UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/12 "2020-09-07T00:52:47Z")
When you get a match in the get column (card number),store the value of “I”. then use it for the rowNum in the getcell block.
---
### Author:  [@avantika.chopra1989a](https://community.thunkable.com/u/avantika.chopra1989a)
#### Post date: [September 20, 2020, 12:25pm UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/13 "2020-09-20T12:25:18Z")
Ahh thankyou, but I figured it out already!
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 12:23pm UTC](https://community.thunkable.com/t/airtable-query-project-on-e-voting/786148/14 "2024-11-08T12:23:51Z")