# I want to search in DataSources and get the column ID
**URL:** https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [March 4, 2022, 1:12am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281 "2022-03-04T01:12:42Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@itsquo.infoqzjaw](https://community.thunkable.com/u/itsquo.infoqzjaw)
#### Post date: [March 4, 2022, 1:12am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/1 "2022-03-04T01:12:43Z")
Hello
Please tell me about Create your own table of DataSource.
Add appointments to LocalDB’s DataSources with create,
If you click the value of List\_Viewer, the data corresponding to the date + click value will be displayed.
Search in DataSources and get column ID
I want the Label to display the value of Column 3 in the same column.
I made Blocks, but the result is null because I couldn’t get the column ID.
Please help me because I don’t know how to get the column ID.
Thank you.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [March 4, 2022, 1:33am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/2 "2022-03-04T01:33:38Z")
You can use an integer for the row id, corresponding to the row number (2 for the second row, 5 for the 5th row, etc.). Or if you really need the row ID, you can get it from the list of values block. See this post:
> [@List Data Viewer List Row ID for Airtable](https://community.thunkable.com/t/list-data-viewer-list-row-id-for-airtable/1040776/9):
>
> I didn’t quite understand the problem about the background but to get all the rowID of your Airtable table you need to use the following block in the screen start or open event. Creat a variable and assign it first as empty list then in the open or start event of your screen assign the block [List of Values] to the variable. Remember to change [column 1] in the image to “ID”. This will give you a list of rowIDs of the table you want.
---
### Author:  [@itsquo.infoqzjaw](https://community.thunkable.com/u/itsquo.infoqzjaw)
#### Post date: [March 4, 2022, 4:46am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/3 "2022-03-04T04:46:37Z")
tatiang
Thank you for your reply.
I have confirmed the link destination, but I hope that the application I am working on this time can be used by a large number of people, not for personal use.
Therefore, I would like to use LocalDB instead of Airtable.
For details of in-app operation
① Enter Schedule and register it in DataSources1 (yyyy-mm-dd, Schedule, yyyy-mm-dd + Schedule)
(2) Display DataSources1 in Data\_Viewer\_List, and click Item to display in data Viewer Select Label.
③ With the data Viewer Select Label displayed, enter the item (time + Store name + Score) and register it in DataSources2 (yyyy-mm-dd, Schedule, yyyy-mm-dd + Schedule, time, yyyy-mm-dd + Schedule + time, Store name, Score)
④ When you click Item of time\_List\_Viewer, Store name and Score corresponding to yyyy-mm-dd + Schedule + time are displayed in Lable respectively.
① ～ ③ have been completed, but the row pick up part of ④ has not been done well and I would like to receive your wisdom.
I’m sorry that it may not be well communicated and there may be some differences from the posted content.
Thank you.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [March 4, 2022, 4:54am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/4 "2022-03-04T04:54:16Z")
In the “for row id” section of the “get value from” block, place the green index block there. Only that green block, no join block, nothing else.
That way, when you click on a List Viewer item – let’s say item #4 – it will get the value from row #4 (because index=4) and column 3 and assign it to the Label.
But seeing your screenshots makes me understand that you have two data sources. So you’re trying to lookup a value from one List Viewer in another Data Source, correct? If so, you need to use the green item block and then find that using “first occurrence of” and “list of values” for the data source.
---
### Author:  [@itsquo.infoqzjaw](https://community.thunkable.com/u/itsquo.infoqzjaw)
#### Post date: [March 4, 2022, 8:23am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/5 "2022-03-04T08:23:09Z")
tatiang
Thank you for your reply.
As you said, what you want to do is definitely “trying to find the value of another data source from the list viewer”.
However, I didn’t know what I was doing and added the “list of values” part inside the block, but I couldn’t find the “first occurrence of”.
When I executed it with the “list of values” part added in the block, null was displayed on the Label and pick up could not be done correctly.
I’m sorry many times, but how do I make changes to pick up correctly?
Thank you.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [March 4, 2022, 3:44pm UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/6 "2022-03-04T15:44:07Z")
Here’s a demo of how to do this:
[https://x.thunkable.com/copy/c05336660d538ffec6e818808a64ed92](https://x.thunkable.com/copy/c05336660d538ffec6e818808a64ed92)
(See the screen with your username.)
You should never have a join block connected as a row id. Row IDs are either integers or they are long text strings like “H@#7d9E0&n3kL2!m”. You either use a whole number or you look up the ID itself using the list of values block:
---
### Author:  [@itsquo.infoqzjaw](https://community.thunkable.com/u/itsquo.infoqzjaw)
#### Post date: [March 6, 2022, 2:03am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/7 "2022-03-06T02:03:50Z")
> [@itsquo.infoqzjaw](#):
>
> tatiang
tatiang
Thank you for your reply.
What you taught me When I actually incorporated it, it worked fine.
Thank you very much for your help.
---
### Author:  [@system](https://community.thunkable.com/u/system)
#### Post date: [June 4, 2022, 2:04am UTC](https://community.thunkable.com/t/i-want-to-search-in-datasources-and-get-the-column-id/1766281/8 "2022-06-04T02:04:05Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.