# Need help with Airtable

**URL:** https://community.thunkable.com/t/need-help-with-airtable/486432
**Category:** Questions about Thunkable X
**Created:** [February 26, 2020, 10:27pm UTC](https://community.thunkable.com/t/need-help-with-airtable/486432 "2020-02-26T22:27:13Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)
#### Post date: [February 26, 2020, 10:27pm UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/1 "2020-02-26T22:27:13Z")

</div>

I have an app where people can ask and answer questions. What is the best way of creating three separate lists of questions asked by the user, questions answered by the user, and questions answered by other users?

---

<div class="post-metadata">

### Author: ![eoinparkinson](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/eoinparkinson/32/143769_2.png) [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)
#### Post date: [February 26, 2020, 10:57pm UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/2 "2020-02-26T22:57:21Z")

</div>

I understand what you mean and this is “possible” in Airtable but I don’t know if it’s such a good idea.

The fact that you have many users replying to one question for organisation sake you’d need infinite columns. Your only option in this case is have a column which in each row of that column, you have the answered questions. So you’d have to do some sort of list from csv to get all answers.

Your best to have each user in firebase real-time dB and have a unique code for each question, then list all users who have this code as a child property of the users parent in database.

Also if you can be more detailed that’d be great because I may have picked u up wrong. 🙂

---

<div class="post-metadata">

### Author: ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)
#### Post date: [February 27, 2020, 1:06am UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/3 "2020-02-27T01:06:20Z")

</div>

You picked up right, except I’m making it so that the first answer is the only answer. Right after its answered, its moved to a new table with the question, email of person who answered it, and the answer. Can you explain what you mean I’m not good with firebase? Thank you

---

<div class="post-metadata">

### Author: ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)
#### Post date: [February 27, 2020, 1:13am UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/4 "2020-02-27T01:13:28Z")

</div>

I have three tables:  
One with a question and the users details  
The second with the question, the answer and the person who answered it details  
and the third the email and balance whenever someone requests a withdrawal

Could I somehow integrate the firebase and the airtable together for the profile part?

---

<div class="post-metadata">

### Author: ![eoinparkinson](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/eoinparkinson/32/143769_2.png) [@eoinparkinson](https://community.thunkable.com/u/eoinparkinson)
#### Post date: [February 27, 2020, 11:33pm UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/5 "2020-02-27T23:33:19Z")

</div>

When you say balance and withdrawal, what kind of app are you making? If I can better understand your app I can help you better.

If you are having questions and only 1 answer, then have the following collumns:

**Column 1** : Person asking the question  
**Column 2** : The question.  
**Column 3** : The person who answered it.  
**Column 4** : Their answer.  
**Column 5** : Balance.  
**Column 6** : Withdrawal.

Again I am unsure what _Balance_ and _Withdrawal_ have to do with it.

---

<div class="post-metadata">

### Author: ![jakepalanca](https://avatars.discourse-cdn.com/v4/letter/j/7cd45c/32.png) [@jakepalanca](https://community.thunkable.com/u/jakepalanca)
#### Post date: [February 28, 2020, 4:27am UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/6 "2020-02-28T04:27:46Z")

</div>

The app I’m making is paying people who answer well-thought out questions. The problem I’m running into is how to get the the row number of each person to add to their profile (so they can view what they asked, who responded, and the users answers)

---

<div class="post-metadata">

### 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: [February 28, 2020, 4:44am UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/7 "2020-02-28T04:44:05Z")

</div>

this sounds like a VLOOKUP. here is an example of what i think you are getting at. You need to learn how to work with the airable data through filtering. Here is one example.

 ![Screen Shot 2020-02-27 at 11.20.37 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/0/303da2b3c1457603028035a5878239d09a0a58d4.png)  
So, hereI first filter out any rows based on not being current user.  
then i filter all data that arent from the current quiz set.  
and [here](https://x.thunkable.com/copy/7fd0bdb47847dfcae7fe7de524b54211) on the screen titled ‘filtering data’ [mind you this screen doesnt work, i just coppied it over from another project. look at the blocks.

---

<div class="post-metadata">

### Author: ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:40am UTC](https://community.thunkable.com/t/need-help-with-airtable/486432/8 "2024-11-08T11:40:44Z")

</div>


