Collection with custom filters + item selection by users

[CarlosR]

Hi everyone,

I have been using glide for two months and I am quite happy with what I got vs. time consumed. Thanks for all the efforts and the community.

I would like users to use some custom filters to filter items out from a collection (step 1), and from the resulting list, let users manually remove items with a checklist from the previous list. E.g. Imaging a form to create your own football team: From all users available in Glide, some customers select some filters such as availability, position, etc. (step 1), and then, remove some of them with a checklist, and set the name of the team (e.g. Lineup Team A Match 23 vs Team B) and other fields (e.g. Date of the match).

So far:

• For Step1: I have created a form, it works fine following the ideas of this tutorial. Thanks @Robert_Petitto
  Glide: Filter an Inline List with Choice Components and the sample multi-step form. The collection is filtered using an if-then-else column in the user table.

This is where I am stuck:

• For Step 2: I can’t use the if-then-else column since it is a computed field from other calculations. I am able to make it work with a different column as a source. However. I need to initialize this column with the if-then-else column. I have tried “set column values” but I couldn’t make it work. Any idea?

Any other workaround? I have not seen any related in the forum.

Thanks!

[Darren_Murphy]

@CarlosR

For Step 2: I can’t use the if-then-else column since it is a computed field from other calculations. I am able to make it work with a different column as a source. However. I need to initialize this column with the if-then-else column. I have tried “set column values” but I couldn’t make it work. Any idea?

I’m not fully visualising what you are wanting to do (a screen shot would be useful), but what you would normally do in this situation is set a value in a user specific column, and then have your if-then-else column refer to that.

[CarlosR]

Hi Darren,

Thanks for the prompt answer.

Sure, I’ll try to clarify the situation more with some mockups (I can’t share the screenshots):

1. Users can apply some custom filters over a collection. For this step I have already set a value in a user specific column with the filters selected by the user and then have an if-then-else column refer to that and used to filter the card collection. It works fine, I have some filters as the following, and the user can visualize the filtered items

2. Once users visualize those items in a card collection, users can click a button, and the app shows a different checklist collection in which they can refine the list by clicking on the items (selecting / unselecting). The mockup is not totally accurate because I had to use a checklist collection but it is the same interaction.

The problem comes with the connection between the first and second steps and collections. The card collection is managed by the if-then-else column but when I set the if-then-else column as the “checked value” in the checklist collection, it doesn’t work and no values are reflected (it makes sense since it is precalculated if-then-else column so the changes are not applied). Just for a test, I have copied and pasted the if-then-else column in a new boolean column and use it as source for the checklist collection and complete the selecting / unselecting behaviour. So, next, I tried to populated that new boolean column from the if-then-else but I couldn´t find a way

I have no idea if someone has tried something similar (not found in the forum), if this is feasible or there is any other best practices I am missing.

Carlos

[Darren_Murphy]

Okay, I kind of get it. And yes it’s definitely doable.
But it’s difficult to give you any step by step instructions, as I still can’t really visualise your data.
However, I think you might find the answer you are looking for in the below thread:

Reset Multiple Rows At Once

There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

[CarlosR]

Hello,

I have already read that thread several times but it is a different problem or couldn’t find the inspiration! Let me go through it again and go back to you.

Thank you @Darren_Murphy

[Darren_Murphy]

Okay, so I’ll tell you what I had in mind. I may be off base, because as I said I still don’t feel as though I’m fully understanding… but anyway…

When you move to the second list, you set a Unique Value in a column somewhere. You then use a Single Value column to apply that Unique Value to all rows in your table.

Initially, all rows in your second checklist will be selected by virtue of your existing if-then-else column.
To deselect them, you would use a Set Column values action that takes the unique value from the single value column, and writes that into a user specific column. You then use this column in a second if-then-else column to determine the final status. The logic might be something like:
– If user specific column is not single value column, then original if-then-else column
– Else false

Again, I probably haven’t got that exactly right, but it might be enough to get you headed in the right direction.