Anyway, what I want is to be able to filter the elements by ID as you did in the demo but make it faster, because it takes a long time to filter the elements by id when there are many products
The demo you had put together I understood perfectly, only it was very slow to filter the data.
if you have to modify any data in airtable, do it freely
Hi Munner, how are you?
I have tried to make it faster to create the list of products according to their id but I have not succeeded.
Have you been able to do any tests to speed up the process, to create a list with their identification?.
Look here I leave you a video where you can see how it takes to generate the list according to its id
I’m testing a different way that would not need a local table to delete and write into and should make things much faster. Will update you with my tests.
It asks to specify a category then a subcategory (it is not clear to me how to select a subcategory from a category) then you have two buttons Show selected and Show all.
check both buttons and let me know the speed of the filtering process. This process does not use local tables.
Thank you very much munner, I just tried and it’s very fast this is extraordinary.
As for the subcategory, don’t worry, I’m going to skip that function, I just need to do the same as you.
I have to do the same but with the data viewer.
Hello Munner, now I tried the demonstration you gave me, it is fast when accessing the categories, only when I click on the button to see the filtered products, nothing happens
In the data viewer look at the ID field and see that it all has the same ID.
The only problem in the code is that it assumes the ID is text and compares it as text. If the column ID is number in your table then you need to change the consition.