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 pr…

you need to use “if array contains element” column [Screen Shot 2022-10-31 at 11.40.29 PM] you need to create also a USC column to write element to look for

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

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…

oh… i see… multiple relations will not work… try to create a text column from that lookup, by joining that array

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?

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

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?

[image] 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”…

thanks so much Uzo! That worked.

How to filter actions on an inline list based on multiple lookup column

Ask for Help

Uzo November 1, 2022, 3:39am 8

you need to use “if array contains element” column

you need to create also a USC column to write element to look for

Topic		Replies	Views
Stuck - cannot use Lookup columns in Inline list (video to explain) Ask for Help	16	655	January 17, 2024
🆕 Is included in condition General	9	1899	June 27, 2022
Comparing two lookup columns Ask for Help	24	1811	February 3, 2022
How to Filter Multiple Users Separately in Glide Inline List/Table? Ask for Help	3	49	May 2, 2025
Lookup value dynamically passed as a condition for action Ask for Help actions	5	50	August 7, 2024

How to filter actions on an inline list based on multiple lookup column

Related topics