I’m having trouble making a dynamic filter on On-device storage.
I have a dropdown with 39 items, each item has 4 filter inputs, so it’s 39x4 totaling 156 filters. I made a formula with all the filters, it had 664 lines and it took almost 50 minutes to paste the formula in appgyver (an error message appeared but in the end I managed to paste the formula) but then it was very slow to use the app.
Because of these problems, I’m trying to create a dynamic filter that, when the inputs are filled, I build the formula
I created a text variable to store the formula, but it is incompatible with Filter condition.
Which variable is supported?
On the Filter condition screen it says that it is an object with 2 properties, I made a test object with 2 properties but it is incompatible.
Can someone help me?
Hi, anyone from support to help?
I need to know how to create a variable to use in the On-Device Storage Filter Condition.
It is possible?
What is the structure of the variable?
Try clicking on the “object with properties” option in the formula binding screen. There you will see what kind of object is the filter object. It is easier to set the filtering from that screen than trying to figure out what is the exact schema of the object with two properties.
If these filters don’t fit your needs then we could and should be figuring that out as well.
Thanks for the reply, but I already did that.
I need the filter to be dynamic, because I have 154 filters (see the explanation at the beginning) and when I loaded all of them the app was very slow and crashed, it took 50 minutes just to paste the formula in the filter condition.
So I need to know how is the variable to mount.
Then do it with one object save, and close the modal. Then click on the same filter and set the type of it to the formula, it will reveal the structure of a filter query. Something like this:
{type: "and", conditions: [{type: "equal", property: ["client_id"], value: "hello"}]}
In this you’ll have to change your “client_id” to any property that you have and the value to the appropriate value.
Also, some other things to note here.
The conditions property is an array, so you might want to use a MAP() formula to go through your list of filters.
Hope this helps more.
Or to even take it further:
{type: "or", conditions: [{type: "equal", property: ["client_id"], value: "hello"}, {type: "equal", property: ["uuid"], value: "fadhsjkfhasl"}]}
This is how you have multiple filters. If you need to match all conditions, you’d need to set the “type” to “and”.
Sorry, I don’t think I could explain it well, I’m using the translator to explain in English.
I made the formula, but it is too big, see the file below
Formula Filter Condition
In the video below, I show that I’m setting up the dynamic formula according to the chosen inputs. That’s why I need to use the variable in the filter condition.
Oh-oh… I feel like there is something really off here. You basically hard-defined all the conditions that are not even finding the right properties in the local data resource…
What is the end goal here? What are you trying to achieve with all these filters?
Maybe I can suggest a different approach because this is no doubt will cause a lot of trouble for you very soon.
From the video I feel like you’d need something like:
WITH_ITEM() formula which would add each new condition based on the dropdown value.
What language do you speak? If Spanish, then maybe @Diagonal_Movil can help here.
Thank you for the tip.
I will try WITH_ITEM()
I speak brazilian portuguese
Solved
I found out how the structure of the filter variable is.
I used the WITH_ITEM function along with it
Below is the structure of the variable for those who want to try it
