# How to filter actions on an inline list based on multiple lookup column **URL:** \ **Category:** Ask for Help\ **Created:** [November 1, 2022, 2:53am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016 "2022-11-01T02:53:54Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![paullintilhac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paullintilhac/32/36278_2.png) [@paullintilhac](https://community.glideapps.com/u/paullintilhac)\ **Post date:** [November 1, 2022, 2:53am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/1 "2022-11-01T02:53:54Z")
Hello, I have an inline list, and I want to be able to filter the action that is available on clicking that column based on whether a certain column value from the user’s profile is or is not in a multuple lookup column for the table behind the inline list. let’s call the user profile column the product\_id, the table behind the inline list the campaigns table, and the multiple lookup in the campaigns table is called my\_campaign\_products. Now, I want to be able to add a row to a table when one of these items in the inline list is clicked, but only if the product\_id is not included in my\_product\_campaigns. but there does not appear to be any condition available for the action. If I try to create a custom action, I can set a condition that says “if user\>product\_id is not included in campaign\>…”, but my multiple lookup column doesn’t appear here for some reason. Why can’t I condition my action based on includion in the multiple lookup column? This seems like a pretty basic functinality, and I don’t see why this column isn’t available. In fact, when the user adds the row to the table upon clicking, it will include the current product\_id in the my\_campaign\_products column, and if all of the above is working, the action should therefore become inactive upon clicking the row. Ideally, rather than simply deactivating, it would switch to a “remove row” action after it has been clicked once. Does anyone know how to help me solve this? ---
**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:** [November 1, 2022, 3:01am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/2 "2022-11-01T03:01:12Z")
your description is quite chaotic… but let me try… you can condition action using if logic in the action table… if you don’t see your column there… that means is not in the sheet that you currently are. copy values to that sheet/table or into User profile table ---
**Author:** ![paullintilhac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paullintilhac/32/36278_2.png) [@paullintilhac](https://community.glideapps.com/u/paullintilhac)\ **Post date:** [November 1, 2022, 3:21am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/3 "2022-11-01T03:21:36Z")
Hi Uzo, Sorry if the explanation was chaotic – I tried to be as clear as possible. I double checked in both my Glide Apps and Glide Pages version of my application, and in neither case am I allowed to use the multiple relation/lookup column as part of the condition for an action. I can see all the other fields in the campaigns table that I can use for the condition, and I have confirmed that this column exists in my campaigns table and is populated with data. Is there something I’m missing? Please let me know if I can provide any further documentation/evidence for my issue. Paul ---
**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:** [November 1, 2022, 3:24am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/4 "2022-11-01T03:24:19Z")
oh… i see… multiple relations will not work… try to create a text column from that lookup, by joining that array ---
**Author:** ![paullintilhac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paullintilhac/32/36278_2.png) [@paullintilhac](https://community.glideapps.com/u/paullintilhac)\ **Post date:** [November 1, 2022, 3:26am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/5 "2022-11-01T03:26:21Z")
ok, but then how would I test for inclusion in that list? Also, just curious, is there any reason a lookup column can’t be used in this condition? ---
**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:** [November 1, 2022, 3:27am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/6 "2022-11-01T03:27:49Z")
I believe anything coming from multiple relations is not allowed… it must be a single match… let me test it… give me a few min ---
**Author:** ![paullintilhac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paullintilhac/32/36278_2.png) [@paullintilhac](https://community.glideapps.com/u/paullintilhac)\ **Post date:** [November 1, 2022, 3:37am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/7 "2022-11-01T03:37:26Z")
ok, so it sounds like there is no way to filter an inline list on a multiple lookup column. Is there any kind of workaround maybe? ---
**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:** [November 1, 2022, 3:39am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/8 "2022-11-01T03:39:42Z")
you need to use “if array contains element” column ![Screen Shot 2022-10-31 at 11.40.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/5/e55a64ff65c97f85246300d2a18d437c94ae735e.png) you need to create also a USC column to write element to look for ---
**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:** [November 1, 2022, 3:44am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/9 "2022-11-01T03:44:55Z")
> [@paullintilhac](#): > > If I try to create a custom action, I can set a condition that says “if user\>product\_id is not included in campaign\>…”, but my multiple lookup column doesn’t appear here for some reason. A lookup based on a multiple relation returns an array, and “is/is not included in” and its variants don’t work with arrays. Instead of a lookup, try creating a joined list through your multiple relation. You should be able to use that with “is included in”. ---
**Author:** ![paullintilhac](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paullintilhac/32/36278_2.png) [@paullintilhac](https://community.glideapps.com/u/paullintilhac)\ **Post date:** [November 1, 2022, 4:14am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/10 "2022-11-01T04:14:14Z")
thanks so much Uzo! That worked. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 2, 2022, 4:14am UTC](https://community.glideapps.com/t/how-to-filter-actions-on-an-inline-list-based-on-multiple-lookup-column/53016/11 "2022-11-02T04:14:49Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.