While filtering Collection in Pages, it gives us an option to select either OR conditions or AND conditions. I have a requirement wherein, only those records are to be shown on screen when two conditions shall be mandatory fulfilled and any one of four conditions is fulfilled. How do I set up this…

Create an if-then-else column to use as a filter. Construct it as follows: if mandatory condition 1 is not true, then null if mandatory condition 2 is not true, then null if optional condition 1 is true, then true if optional condition 2 is true, then true if optional condition 3 is true, then tru…

Ya…you need to build the condition in the editor as @Darren_Murphy stated above. Wish Glide would give us more robust if conditions as proposed here: [image] Better and more consistent IF THEN logic Feature Requests Thanks @Jeff_Hager . Yes, it’s for an IF computed column …

Thank you for quick response @Darren_Murphy @Robert_Petitto . Actually, I am comparing this value based on value shown on screen and these comes from form submission. So, e.x. for one Company, one is mandatory and for another, it may not be mandatory. Let me show you the structure of database. I …

One thing is not clear to me. Are you trying to apply this filtering within the form prior to submission, or after the form has been submitted? If you’re trying to do it inside a form, then the method I outlined won’t work as you won’t have access to the form values. The only way to apply my metho…

No, I am not filtering in form. I have custom form which is writing to another table but without user specific values. But still I am not able to understand how will it work because values are in a screen from different table. Can you please guide? Thanks

[image] Pratik_Shah: I have custom form which is writing to another table but without user specific values. Will you ever have more than one user in that form at the same time? If yes, then you will have problems. [image] Pratik_Shah: But still I am not able to understand how will it wor…

Thank you for response. [image] Darren_Murphy: you need to find a way to get those values into the table that needs to be filtered I will work on it.

Filtering Collection in Pages

Ask for Help

Robert_Petitto January 5, 2023, 1:10pm 3

Ya…you need to build the condition in the editor as @Darren_Murphy stated above. Wish Glide would give us more robust if conditions as proposed here:

Topic		Replies	Views
Multi conditions on filtering tables Feature Requests	3	50	January 20, 2025
Multiple (IF AND), and multiple (IF OR), How to do that? Ask for Help	6	2643	May 5, 2022
Filtering data with AND and OR Ask for Help	14	235	December 20, 2024
AND / OR for each condition when filtering data Feature Requests	2	166	June 22, 2023
Filter data with 2 "and" connectors and multiple "or" connectors Ask for Help	6	126	May 26, 2024

Filtering Collection in Pages

Related topics