# I need help with the database list **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [March 6, 2022, 12:39pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646 "2022-03-06T12:39:02Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 6, 2022, 12:39pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/1 "2022-03-06T12:39:02Z")
Let me introduce the app I envisioned. I am creating an app that shows news to users. I entered a list of news through the database viewer. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/a/9a85f35f7a987a89a12e1124cf6215b5c28fa07d.png) However, a problem has occurred. Let’s say there are users a, b, and c. If user a clicked on fruit news, I would like to make sure that only user a cannot see fruit news. I made a database list on Airtable and Google Sheets. Users who have clicked on the news want to make the news that they have already seen no longer appear, but when they use this code, the news is deleted so that everyone can’t be seen by all users. How can I prevent the news from appearing only to users who have seen it? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/3/e32af5c0f9715d67c91340000a52bb602b5a62f3.png) ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 6, 2022, 1:16pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/2 "2022-03-06T13:16:25Z")
I did it like this. However, if you turn off and off the app, the value will be shown again. How shall I do it? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/6/76d22098f536941fba7b66c2bbf20a7490ed811d.png) ---
**Author:** ![Dean\_Artis](https://avatars.discourse-cdn.com/v4/letter/d/a8b319/32.png) [@Dean\_Artis](https://community.thunkable.com/u/Dean_Artis)\ **Post date:** [March 6, 2022, 2:25pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/3 "2022-03-06T14:25:34Z")
You’ve been told to stop spamming the forum and already had a topic closed because you keep creating near duplicate topics. Please stop disrespecting the forum’s rules and the users in this way and stick to your original topic. ---
**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:** [March 6, 2022, 5:14pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/4 "2022-03-06T17:14:15Z")
There is not enough information to provide an answer and you are explaining the issue as if we all know the details of your blocks and your Google sheet. However, let me guess situation with you. You have your list of news in a Google sheet and displaying this list using DVL (Data Viewer List) and you want the app to show only news that has not been read/displayed for that specific user. If this is correct then you need a minimum of **TWO** sheets - Sheet1 (News Sheet) This sheet should contain a column to identify the news. It should be unique. I will call it **News ID**. The sheet can have news title, news source, news URL and so on. - Sheet2 (Users sheet) Again there should be a unique **User ID** and other columns like user name and other profile info. This sheet contains a column that has a list of **News ID** entries. I’ll call it **Watched List**. In your app, whenever the user clicks on a news link, the app should search for the user in the User Sheet and add the **News ID** to the list of **watched list** column. Your app will display only the news that the **News ID** is not available in the **Watched List** for that specific user. This way you will design a semi-multi-user app. Hope that is clear. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 11:19am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/5 "2022-03-07T11:19:44Z")
Your advice has been helpful. But it hasn’t been resolved yet. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/f/9f4f6d01c8a148491973b32f64fcb493bfc6b0d4.png) I entered the code to filter the news when the user sees the news like this and it works successfully. But when I click the news on the fake sheet, I want to add the user ID to the row ID value of the real sheet, but I am confused. Can you help? ![d](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/5/1557e4fdc5f5099fe349b09447591502c30c0b05.gif) ---
**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:** [March 7, 2022, 11:51am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/6 "2022-03-07T11:51:28Z")
I’m not sure I understand your situation specially all your table names and column names are non-English. However, if you followed my suggestion then every news has a unique **News ID**. You need to update the row with this **News ID** so next time you will see that this news is already seen by this user. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 11:56am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/7 "2022-03-07T11:56:57Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/3/d3c2cdb7a25ca05842f029ff9ff8116b6acba8ce.png) I don’t know how to set this up. User sheet when user clicks on news? Did you see the row you clicked on the 2nd sheet? I want to put the value as the user ID. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 12:11pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/8 "2022-03-07T12:11:44Z")
![1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/6/866f8c3f90120be04f267f7eeb90728d600930cd.gif) This is the DVL program you posted in another post. This code takes the word sheet on screen 2 and creates a temporary text sheet on screen 1. Right? I want a remake similar to this one. There is screen 1 and screen 2. Screen 1 shows the temporary newssheet shown to the user. Screen 2 is the original news information sheet. The user sees screen 1. User can click news on screen 1 viewed. If you click on temporary news on screen 1, you want to add user ID to the original newssheet with the same information. How can I do this? Please let me know if there’s anything you don’t understand ---
**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:** [March 7, 2022, 12:12pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/9 "2022-03-07T12:12:22Z")
> [@qortmd3592st](#): > > I want to put the value as the user ID. You want to add the `User ID` to the news row. This is the right thing. But first you need to tell the app which row is this? For example, if you use the URL column as the unique then you will need to go back to the main news file and search the URL to update the correct row. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/5/9558609c00c4a4170b15304dc7d5d9caf9eacaaf.png) In this example, I am updating sheet1 using the `row id` of the search result of the matching number with my selected number. You will have to do the same but you need to search for matching news with your selected news. If you use the URL then you need to find the URL in the main news table and get the row number which you will use to update the correct row. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 1:36pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/10 "2022-03-07T13:36:55Z")
ok! As you said, the user ID is entered fine. But there is a problem. I put the filter function exactly as you did, but the filter works only when the app is turned off and on again. What should I do? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/1/b1409cc204a56798a2eac2649560cacfcf592dfe.png) ---
**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:** [March 7, 2022, 1:47pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/11 "2022-03-07T13:47:52Z")
I did not understand. Can you explain in a clear way or give walk through example? ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 1:49pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/12 "2022-03-07T13:49:36Z")
When the user ID is not entered, the filter code to show or hide news works normally, and now the user ID is entered in the news line well, but the filter does not work. ---
**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:** [March 7, 2022, 1:52pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/13 "2022-03-07T13:52:07Z")
Are all your rows have `User ID`? If yes, then you will have empty DVL. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 1:53pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/14 "2022-03-07T13:53:01Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/5/d55bedccacfe768445ca695fe0804725cabbab71.png) And I think I misunderstood this article. What do you mean by making two sheets? One to make a news sheet and the other to make a user’s information sheet? I’m confused as to whether there was an error when I made the sheet. ---
**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:** [March 7, 2022, 1:54pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/15 "2022-03-07T13:54:23Z")
I will make a quick demo later and share it here. I have to leave for a meeting in 5 minutes. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 7, 2022, 1:55pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/16 "2022-03-07T13:55:26Z")
ok. Come and see the urgent business. I hope my question is not buried. I want to fix this problem ---
**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:** [March 7, 2022, 5:50pm UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/17 "2022-03-07T17:50:14Z")
Hello, I made a quick demo which should show how to deal with the situation you are facing. Because it is a demo I did not make a login screen but instead I use a variable `UserNo` which you can use to run the project with different user name. My table has 3 users so you can set the variable to 1, 2, or 3. Th screen has two different DVL the upper one is the solution and you will see that when you click in a news row it will disappear from the list. If you then stop the project and change the `UserNo` you will see the news for that user and not for the other user. The DVL in the lower part of the screen is for you to see how the information is changing once you click in a news row. The DVL will also reset the user to the start to see all news again. I hope this will help you complete your app. [https://x.thunkable.com/projectPage/62260ee51aadef0012504cdb](https://x.thunkable.com/projectPage/62260ee51aadef0012504cdb) ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 8, 2022, 9:44am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/18 "2022-03-08T09:44:00Z")
![노이](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/1/51515e044b337fceaa8d33e65c019a6497f86a2b.png) What kind of variable is this? I’m confused. Do you mean the three users you created? Why did you set userno to 1? ---
**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:** [March 8, 2022, 9:49am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/19 "2022-03-08T09:49:59Z")
> [@muneer](#): > > Because it is a demo I did not make a login screen but instead I use a variable `UserNo` which you can use to run the project with different user name. My table has 3 users so you can set the variable to 1, 2, or 3. This is the answer to your question. ---
**Author:** ![qortmd3592st](https://avatars.discourse-cdn.com/v4/letter/q/d07c76/32.png) [@qortmd3592st](https://community.thunkable.com/u/qortmd3592st)\ **Post date:** [March 8, 2022, 9:53am UTC](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646/20 "2022-03-08T09:53:53Z")
Userno means user 1, right? [Next page](https://community.thunkable.com/t/i-need-help-with-the-database-list/1769646.md?page=2)