AppSheet How To Create a Filtered Dashboard Multiple Condition
ฝัง
- เผยแพร่เมื่อ 18 มิ.ย. 2024
- 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 - วิทยาศาสตร์และเทคโนโลยี
Excellent!
This is the feature I was looking for now!
Thank you my friend! very helpful, really good
You helped me so much i pray to Allah to send some one to help you in your needs .. tnx man
finally done... thanks a lot..
This is wonderful video.. Thank you so much
:)
Hi. Great video.
One more thing, After I filter the table, is it possible to sum the filtered values? If so, how?
subscribed you..😎😎
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
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
Thanks fo your Video, i wanna know how to make filter using dependecies
Nice excelent, Question For each table that I want to filter I must create a filter table???
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?
Thank you! what if I want the blank "date" box to show all the dates for that cashier?
Excellent ,Filtered Dashboard Enumlist. What if I want to create a PDF file from this example?
Very helpful video. Sir how to sum expression enum list wise column
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!
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)
@@JoeTayactac Thank You Sir Joe!!
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
Sure
how is your Filter table composed?
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.
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... 😅
Hi there is an updated video th-cam.com/video/5lQ3roJG0Hw/w-d-xo.html by using UserSettings
Thanks! Is there a way to save each search record in the same table but only filter the active row?
can you share the demo app & i want see the source data... can't filter properly after watching this video 3 times. please help...
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?
Hi,
Instead of putting the formula in data validity you can put the formula in suggested value where in you can add
how you created filter table ?
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
Hi, It can be done by customized expressions and actions.
Are the datas both on collection and filter table duplicated?
Both are different tables. Filter table is for filter interface. And Collection Table is where the data lives
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.
Hi Joe, I'm followed the same but why it still showed "This Entry is Invalid"?
Check data validity
Can export csv.from that filter ? File export always blank 😢
Yes you can export. You can check too the csv locale settings
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.
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 😊
@@AlberichRheinmann thank you it works
Cant find "Filter Detail"
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..
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
@@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
After creating Dashboard view displays nothing, says "no items selected"
Make sure the filter column there is value and slice row filter condition is correct
@@JoeTayactac Thanks for the tutorial man I have finished doing it. Thank you
@@JoeTayactac I also some problem, now it has been resolved, thx
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"
t show no item selected
please help
Make sure the formula is correct
@@JoeTayactac Thank you very much, it worked ,
it show no item selected
Your row filter expression might be wrong
@@JoeTayactac Quick edit columns :-showing No column