AppSheet How To Create a Filtered Dashboard Multiple Condition

Filtered Dashboard Multiple Filter Introduction
Join this channel to get access to perks:
/ @joetayactac
More Tutorials Below
Scan to View Restaurant Menu
• How To Create a Scan Q...
Any Business Inventory Point of Sale Management
• AppSheet Inventory Poi...
Restaurant POS Sytem Multiple Item
• AppSheet Restaurant Mu...
Generate PDF Using Google Form in Appsheet and Send Email
• Google Forms To PDF Ap...
Generate Qr Code
• How To Generate QR Cod...
Calculate Age based on Date of Birth
• How To Calculate Age U...
Delete Rows of Another AppSheet App
• How To Delete a Row Da...
Add and Update Another AppSheet App
• Add and Update Data in...
Multiple Items POS System with Inventory Management
• How To Create Your Own...
Recover Deleted Row Data
• AppSheet Copy Data Fro...
Link PDF File to AppSheet
• How To Link PDF File ...
How to Send Whatsapp Messages
• How To Send Whatsapp M...
Generate Customize Report and Download in PDF
• How To Generate a Cust...
Create Your Own Inventory Management from Scratch using AppSheet
• How To Make an Invento...
Appsheet Edit a Table Using Another Table
• How To Modify a Data T...
Create your own payroll payslip in Appsheet
• How To Create a Payrol...
Create your own TAX Invoice App Printable Using Appsheet and Google sheet
• How To Create a TAX In...
Create Your Own POS Restaurant System
• How to make your own P...
How to Autofill Columns in AppSheet
• How To Auto Fill Data ...
Create a Dynamic Dashboard
• Appsheet Dashboard View
Generate Barcode and Random Numbers
• How to Generate Barcod...
#appsheet

[@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!

[@alessandroscimone5463]

Thank you my friend! very helpful, really good

[@dme9874]

finally done... thanks a lot..

[@thetradingcapsules]

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

[@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!

[@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

[@iamabhyankar]

Thank you

[@acarakito6420]

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

[@Robotech-su2oo]

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

[@dme9874]

subscribed you..😎😎

[@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

[@aaronriccardo]

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

[@infoguiahn]

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

[@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?

[@user-nd4vm6te4c]

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

[@Deepak-nf1fi]

how you created filter table ?

[@susanta1989]

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

[@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!!

[@user-vl9if5qw7h]

how is your Filter table composed?

[@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]

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

[@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.

[@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?

[@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

[@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.

[@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

[@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

[@suiyasrl6721]

Cant find "Filter Detail"

[@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"

[@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

[@user-bo1eh6cg6n]

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

[@user-bo1eh6cg6n]

@@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

[@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