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 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!
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
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
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 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)
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... 😅
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
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.
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
You helped me so much i pray to Allah to send some one to help you in your needs .. tnx man
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 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!
finally done... thanks a lot..
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
Nice excelent, Question For each table that I want to filter I must create a filter table???
Thank you my friend! very helpful, really good
how you created filter table ?
Hi. Great video.
One more thing, After I filter the table, is it possible to sum the filtered values? If so, how?
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?
Thanks fo your Video, i wanna know how to make filter using dependecies
This is wonderful video.. Thank you so much
:)
Very helpful video. Sir how to sum expression enum list wise column
how is your Filter table composed?
Thank you! what if I want the blank "date" box to show all the dates for that cashier?
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
Thank you
subscribed you..😎😎
Excellent ,Filtered Dashboard Enumlist. What if I want to create a PDF file from this example?
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.
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
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, 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?
Excellent!
This is the feature I was looking for now!
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.
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"
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
Hi Joe, I'm followed the same but why it still showed "This Entry is Invalid"?
Check data validity
Cant find "Filter Detail"
Can export csv.from that filter ? File export always blank 😢
Yes you can export. You can check too the csv locale settings
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.
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
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