AppSheet How To Create a Filtered Dashboard Multiple Condition

[@waralingaw]

Thank, this Chanel deserve more subscribers.

[@louaiismaeil6084]

You helped me so much i pray to Allah to send some one to help you in your needs .. tnx man

[@irukano_ecchan]

Excellent! This is the feature I was looking for now!

[@joseavilavega4607]

Thank you very much! I have a question... There is a way to show all in first place and them go filtering by colums... In other words 😂 if i dont select a filter in a column, show me all

[@Deepak-nf1fi]

how you created filter table ?

[@siboyvn]

Hi Joe, how do I add the "useremail" column in the "filters" table to match the "useremail()" value? This way, the filter will not be reselected/reset by other users. Can you make the video, thank for the help

[@JoeTayactac]

Sure

[@dme9874]

finally done... thanks a lot..

[@CESARSANVICENTE-h4f]

how is your Filter table composed?

[@alessandroscimone5463]

Thank you my friend! very helpful, really good

[@BobbyCreech]

Hi, I followed your video and it worked good for me. How can I change it so that if any condition is not blank it will search? i.e. if the only thing I select is Cash it will show all Cash transaction without having to fill in the rest of the fields. I tried adding Or but the app then barfed...I guess I didn't have the syntax correct

[@Robotech-su2oo]

Hi. Great video. One more thing, After I filter the table, is it possible to sum the filtered values? If so, how?

[@albertocarrara9700]

gran vídeo, gracias. Sólo me gustaría hacerte una pregunta: ¿cómo lo exporto a PDF después de hacer el filtro y ver lo que quiero en el vídeo?

[@infoguiahn]

Nice excelent, Question For each table that I want to filter I must create a filter table???

[@aaronriccardo]

Thank you! what if I want the blank "date" box to show all the dates for that cashier?

[@ArkNeuche]

Thanks bro for all your videos. Can you do a video on Result processing App where each instructor can only access the subject and class he teaches. I would appreciate!

[@dme9874]

subscribed you..😎😎

[@จักรวาลหาชานนท์]

Excellent ,Filtered Dashboard Enumlist. What if I want to create a PDF file from this example?

[@acarakito6420]

Thanks fo your Video, i wanna know how to make filter using dependecies

[@thetradingcapsules]

This is wonderful video.. Thank you so much :)

[@iamabhyankar]

Thank you

[@susanta1989]

Very helpful video. Sir how to sum expression enum list wise column

[@zakirkhayali-xm3gr]

Please 🙏🏿🙏🏿🙏🏿🙏🏿 sir it's request to you that make a video on Stationery Shop Inventory Management and Sales Report including Profit and Loss. Automatically Adjust these things Products Purchase Inventory Sales (Daily POS) Profit and Loss These are the main key requirements for me for my Small Shop which I started now means a few days ago.

[@jaichithjeyakumar507]

If there is blank values . How to add it in the enum list (row filter condition expression)? In case if the wants it and specify it manually?

[@JoeTayactac]

Hi, Instead of putting the formula in data validity you can put the formula in suggested value where in you can add

[@allannallano6198]

Hi Sir Joe.. This is a great tutorial! Thanks! Just 1 question, how about I want to apply this in the inventory app by having to search by Inventory ID and it will show all the items with that inventory id input. Thanks again!

[@JoeTayactac]

Hi, Yes you can do that. But I think you can just have a parent and child table relationship. By using ref. Type column. Please see more about this topic (Parent-Child Table)

[@allannallano6198]

@@JoeTayactac Thank You Sir Joe!!

[@Jeyamurugan1974]

After creating Dashboard view displays nothing, says "no items selected"

[@JoeTayactac]

Make sure the filter column there is value and slice row filter condition is correct

[@jeya_murugan1975]

@@JoeTayactac Thanks for the tutorial man I have finished doing it. Thank you

[@gorebantchiu6469]

@@JoeTayactac I also some problem, now it has been resolved, thx

[@doctorj9125]

Me too, but I already fix it by create 1 record in advance. At filter table, i suggest insert only ID column. such as "ID = 1"

[@Balsamappsheet]

I find it strange that whenever any user changes the filter selection, it changes for every other user. Is this the usual behaviour in appsheet or am I doing something wrong?

[@jicbro35]

Hi sir, can you please help me with a solution that, I need to filter my datas which is start with a Text, (eg: E1234, E1235), but i can’t filter by sr number, as the column type is Text, your favorable reply will be highly appreciated.

[@dme9874]

can you share the demo app & i want see the source data... can't filter properly after watching this video 3 times. please help...

[@thomasdemmel6259]

Hi, thanks a lot for that tutorial. Any chance to get this working when multiple users are using the platform? Right now, users are overwriting each other's filters... 😅

[@JoeTayactac]

Hi there is an updated video kzbin.info/www/bejne/a520ZKWlf6xjftk by using UserSettings

[@lorgomez2905]

Thanks! Is there a way to save each search record in the same table but only filter the active row?

[@annualloadbook]

I created a new app to follow the procedure that you are showing. However each time i do it the views in the Dashboard are empty and the columns are not showing for the “Filter Detail” I am not sure what I’m doing wrong.

[@AlberichRheinmann]

Maybe the FILTER Table is empty, you have to add at least 1 row .... in the meanwhile i have tested it, yes ... this is the problem 😊

[@annualloadbook]

@@AlberichRheinmann thank you it works

[@TriKaKiKaa420]

Hello Sir, In your recent tutorial based on the previous one, I noticed a few discrepancies that are causing confusion. In the previous tutorial, the filter table included a virtual column for the banner, but this seems to be missing in the current tutorial. Additionally, there’s some confusion about the "row_id" column. While it appears faded, which makes it unclear, it seems "row_id" serves as the unique identifier here, rather than "id." Could you please clarify whether the "row_id" column is virtual or if it’s actually part of the filter table? I’d really appreciate your help in understanding this more clearly....

[@charlesfernandez816]

Are the datas both on collection and filter table duplicated?

[@JoeTayactac]

Both are different tables. Filter table is for filter interface. And Collection Table is where the data lives

[@charlesfernandez816]

I see, I watched your previous video. With the same concept as this. Making a slice table is the way of filter data to access collection table.

[@davidtee1376]

Hi Joe, I'm followed the same but why it still showed "This Entry is Invalid"?

[@JoeTayactac]

Check data validity

[@jessehanson3828]

Hello I am trying to create an inventory app for our restaurant. I know you have made video about this but they are not the same for what we need. We need to be able to count what we have on hand in store and generate a price. The items would be in different categories food, alcohol, paper, and operations. After the inventory is counted I would like a pdf file to be sent of all items with quantities and prices. Then of each item quantity to be rest to 0. Each item will have two prices case price and unit price. For example Ranch 6 (1gal) case price 60 unit price 10

[@JoeTayactac]

Hi, It can be done by customized expressions and actions.

[@phulong.laptop]

Can export csv.from that filter ? File export always blank 😢

[@JoeTayactac]

Yes you can export. You can check too the csv locale settings

[@suiyasrl6721]

Cant find "Filter Detail"

[@fabiandzulmoo5318]

t show no item selected please help

[@JoeTayactac]

Make sure the formula is correct

[@fabiandzulmoo5318]

@@JoeTayactac Thank you very much, it worked ,

[@Deepak-nf1fi]

it show no item selected

[@JoeTayactac]

Your row filter expression might be wrong

[@Deepak-nf1fi]

@@JoeTayactac Quick edit columns :-showing No column

[@GaynardVelasco-b5m]

Hello Sir! Baka po pwede mo maibigay ang if formula ng total value = percentage.. and papaano po if ang value ng row is 0.. pano gawin 100%? for example Available Stock = 0 then Total Release stock is 1000 so dapat 100% diba sir? pano po kaya and formula? thank you so much..

[@JoeTayactac]

Hi, sir sorry to ko ma gets question mo. If gusto mo makuha ung percentage divide mo lng yung let say target value is 1000 tapos naka 500 plang. [1000]/[500] tapos set mo as percent type yung column

[@GaynardVelasco-b5m]

@@JoeTayactac sorry sir.. Inventory management po kasi yung gawa ko.. bali my Column po kasi ako ng "Available Stocks", "Total Release Stocks" and "Release Percentage" Hindi ko po kasi makuha ang formula sa "Release Percentage" na sana po kung zero na po yung Available Stocks dapat po 100% na po yung Release Percentage. tapos kung may Available Stocks man sya.. Dapat po lalabas po yung percentage nya sa Release Percentage po na Column. for example po 100 Available Stocks, Tapos nag release po ng 80 dapat po 80% po yung nasa Release Percentage.. hehe thank youuuu sir. sana matulungan mo po ako. Yan nalang po kasi ang problema ko. thank you and Godbless