# Not able to check if a number is included in a joined list **URL:** \ **Category:** Ask for Help\ **Created:** [May 12, 2021, 3:51pm UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705 "2021-05-12T15:51:29Z")\ **Posts on this page:** 19\ **Page:** 2
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 3:42am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/21 "2021-05-14T03:42:18Z")
Seems to work fine. I can enter any value in the text input, and use that to add a new row. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 3:46am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/22 "2021-05-14T03:46:46Z")
what is the problem in this test app? ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 14, 2021, 3:48am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/23 "2021-05-14T03:48:14Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce4490cc492bb95f617e9f240e9c80a074db8ef9.png) The user specific column “usc test column” doesn’t appear as a field in the Add Row action. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 3:52am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/24 "2021-05-14T03:52:30Z")
you can’t write to user specific column by action, it have to be by user personally ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 3:52am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/25 "2021-05-14T03:52:52Z")
yes, it does. ![Screen Shot 2021-05-14 at 11.52.19 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/6/e621788261219614ae855709d577ca6d9811ff94.png) ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 14, 2021, 3:53am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/26 "2021-05-14T03:53:04Z")
But it appears for a Glide table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb2ae59faf026955604db5277a7fb88adb4a889a.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 3:54am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/27 "2021-05-14T03:54:36Z")
> [@vijay](#): > > The user specific column “usc test column” doesn’t appear as a field in the Add Row action. oh! Now I see where you are confused. When adding a new row, the USC is used as the _source_, not the target. The reason you see it as a target in a Glide table is because User Specific Columns only exist in Glide tables. But that’s really irrelevant for your use case here, because you don’t need to write anything to that column when you add a new row. ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 14, 2021, 4:01am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/28 "2021-05-14T04:01:26Z")
Yes, because in your app, you have this as well in the Add Rows action. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/2921dbe79fceae6de358572854f44d208118d21e.png) Maybe, it is not important, except for clearing purpose, which can be done by using Set columns. So, even if I don’t have those in Add Row, I can do the action I need. But, there seems to be a bug in that, it appears for Glide tables but not for Glide sheets. ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 14, 2021, 4:02am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/29 "2021-05-14T04:02:27Z")
Yes, you’re right. For my use case, it is not relevant. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 4:03am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/30 "2021-05-14T04:03:28Z")
you can’t write to user specific column by action, it have to be by user personally, thats why you dont see US columns in add row ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 4:06am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/31 "2021-05-14T04:06:07Z")
> [@vijay](#): > > Yes, because in your app, you have this as well in the Add Rows action. oops, that’s actually a bug in my app. It should look like this: ![Screen Shot 2021-05-14 at 12.05.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/2/b2f9514281877ec0aad3a38ad91f1810b1698848.png) Anyway, problem resolved now yes? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 4:07am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/32 "2021-05-14T04:07:21Z")
> [@Uzo](#): > > you can’t write to user specific column by action, um, yes, you can. And there are situations where it makes sense to do that (but not in this case). ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 4:08am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/33 "2021-05-14T04:08:00Z")
so why is not showing usc in add row? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 4:11am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/34 "2021-05-14T04:11:54Z")
Because the base sheet is a GSheet, and User Specific Columns don’t exist in GSheets. Try it yourself - add a row to a Glide table that has User Specific Columns, and you’ll find that you can add values to those columns. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 4:11am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/35 "2021-05-14T04:11:56Z")
in this case, he is adding row to the same sheet as source, so usc is beaing creating not copying, thats why you cant ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [May 14, 2021, 4:14am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/36 "2021-05-14T04:14:03Z")
oh, i see that make half sense, it should be same rules for all tables ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [May 14, 2021, 4:21am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/37 "2021-05-14T04:21:52Z")
Yes, I think it is something for Glide team to look into. Because, there will be some use cases, where you need to replace the value of a user specific column in a GSheet with another value while doing Add Row. And, it will be confusing for that column to not appear while doing Add Row. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 4:44am UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/38 "2021-05-14T04:44:41Z")
> [@vijay](#): > > Because, there will be some use cases, where you need to replace the value of a user specific column in a GSheet with another value while doing Add Row. That doesn’t really make sense. When you are adding a new row, it’s a completely new row, so all values are empty. ie. there is nothing to replace. (Also, as I mentioned - User Specific Columns do not exist in GSheets). ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705/39 "2024-01-17T16:52:18Z")
[Previous page](https://community.glideapps.com/t/not-able-to-check-if-a-number-is-included-in-a-joined-list/26705.md?page=1)