I want to allow users to input a text field with items separated by commas (e.g.,
X1,X2,X3,X4,X5
) and, after clicking a boolean (e.g., "Select"), have the page filtered to show data only for the specified items. How can I set up this filter?
Hi, I think we need a bit more information of what X1, X2 is representing. If those are list members then I would sugest this solution instead. 1) Have a Boolean added to an ADMIN module (no dim). ("confirm choice/select") 2) Have a module (FIL01) dimensioned by your list 1 "Filter Line item" (formatted as a boolean) = should have no formula 2 "Filter Confirmed Picks" = If not "ADM01.select" then true/false (depending on how you want it to operate) else "Filter Line Item" Here they can select the items manually (instead of typing). Still want to add typing? Add SYS Lookup: "Item to find" (formatting text) Then you can add another filter to FIL01 "Find Item" = Name(item(L1)) = sys lookup.'item to find' Then add this as a filter to the UX-card. This would allow users to search for an item, then check the boolean and search for another item. You could add a lot more logic to have a dynamic search function, but this is probably the most you need. Does this work for you? Best, Rickard
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?