[Screen Shot 2020-07-11 at 5.58 1] Conditions now have a new ‘screen’ context which lets you choose values from the current screen. This allows you to do things like: Show items where Category is the same as Category (to show a list of items that relate to this one) Show items where Price is equ…

@Mark The filter comparing the value to a list of values or relation field. I’m referring to my case earlier in this thread. [image] new New containing screen context for conditions Announcements This is great @JackVaughan ! Will we be able to compare a value to a list o…

Ah, sorry. That’s not particular to forms, though, right? That kind of condition could be used anywhere.

It would be great if it could! From the thread, it seemed like others tried this in other areas but particularly, it did not work with forms.

[image] Mark: You want to check whether the value is/is not one of the values in the list? Can’t wait for that to be available! :exploding_head:

@Mark do you have any forecast for that to be implemented? I have an app on Pro ready to go but I can’t release it without that feature. If I could explain you my use case, perhaps you could recommend me an workaround: I have an appointments sheet that registers appointments for many stores, howev…

Here’s what I think should work: Use Joined List to combine all the hours that you want to check against in a single string. Use “contains” to check whether a particular appointment hour is part of that string.

[image] Mark: Use Joined List to combine all the hours that you want to check against in a single string. Use “contains” to check whether a particular appointment hour is part of that string. Unfortunately, this didn’t work. It doesn’t check if the hour is part of the string (“in” operator),…

Why doesn’t All Hours contains This Hour work?

[image] Mark: All Hours contains This Hour The problem is that the “chosen hours” list is not on the same sheet as the choice options and I have different lists of “chosen hours” based on stores. A store can have multiple appointments, and I’m making an appointment on a store. I have to filt…

Ah, got it! I’ll see what I can do.

🆕 New containing screen context for conditions

General

kyleheney August 16, 2020, 11:54am 49

Correct! I’ve tried using the new method but it doesn’t work in forms.

Filter by Screen doesn't work AND breaks existing filter if using an AND operator

Topic		Replies	Views
🌪 Use Multiple Choice Components to Filter an Inline List Community Resources tutorial	201	13304	October 18, 2024
Filtering – seperate screen Ask for Help	18	2195	December 16, 2021
🆕 Screen Visibility and Filtering Conditions! Community Resources	11	1937	August 16, 2020
Filtering inline list in a form Ask for Help	37	1376	February 22, 2022
Component Visibilty with Screen conditions? Feature Requests	7	721	November 18, 2020

🆕 New containing screen context for conditions

Related topics