AppSheet How To Create a Filtered Dashboard Multiple Condition

Поділитися
Вставка
  • Опубліковано 29 жов 2024

КОМЕНТАРІ • 58

  • @louaiismaeil6084
    @louaiismaeil6084 Рік тому +2

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

  • @irukano_ecchan
    @irukano_ecchan Рік тому +1

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

  • @joseavilavega4607
    @joseavilavega4607 Рік тому +2

    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

  • @BobbyCreech
    @BobbyCreech 7 місяців тому

    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

  • @ArkNeuche
    @ArkNeuche 4 місяці тому

    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!

  • @siboyvn
    @siboyvn Рік тому +2

    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

  • @Robotech-su2oo
    @Robotech-su2oo 9 місяців тому

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

  • @albertocarrara9700
    @albertocarrara9700 6 місяців тому

    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?

  • @CESARSANVICENTE-h4f
    @CESARSANVICENTE-h4f Рік тому +1

    how is your Filter table composed?

  • @alessandroscimone5463
    @alessandroscimone5463 Рік тому

    Thank you my friend! very helpful, really good

  • @dme9874
    @dme9874 Рік тому +1

    finally done... thanks a lot..

  • @infoguiahn
    @infoguiahn 4 місяці тому

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

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

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

  • @thetradingcapsules
    @thetradingcapsules Рік тому

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

  • @aaronriccardo
    @aaronriccardo Рік тому

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

  • @jicbro35
    @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.

  • @acarakito6420
    @acarakito6420 Рік тому

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

  • @iamabhyankar
    @iamabhyankar 3 місяці тому

    Thank you

  • @susanta1989
    @susanta1989 6 місяців тому

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

  • @Deepak-nf1fi
    @Deepak-nf1fi Рік тому +3

    how you created filter table ?

  • @allannallano6198
    @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
      @JoeTayactac  Рік тому +1

      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
      @allannallano6198 Рік тому

      @@JoeTayactac Thank You Sir Joe!!

  • @thomasdemmel6259
    @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
      @JoeTayactac  Рік тому

      Hi there is an updated video ua-cam.com/video/5lQ3roJG0Hw/v-deo.html by using UserSettings

    • @lorgomez2905
      @lorgomez2905 8 місяців тому

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

  • @annualloadbook
    @annualloadbook 8 місяців тому

    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
      @AlberichRheinmann 7 місяців тому +1

      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
      @annualloadbook 7 місяців тому

      @@AlberichRheinmann thank you it works

  • @jaichithjeyakumar507
    @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
      @JoeTayactac  Рік тому

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

  • @dme9874
    @dme9874 Рік тому +1

    subscribed you..😎😎

  • @dme9874
    @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...

  • @Jeyamurugan1974
    @Jeyamurugan1974 Рік тому +2

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

    • @JoeTayactac
      @JoeTayactac  Рік тому +1

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

    • @jeya_murugan1975
      @jeya_murugan1975 Рік тому

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

    • @gorebantchiu6469
      @gorebantchiu6469 Рік тому

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

    • @doctorj9125
      @doctorj9125 Рік тому +2

      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"

  • @davidtee1376
    @davidtee1376 Рік тому

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

  • @jessehanson3828
    @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
      @JoeTayactac  Рік тому

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

  • @charlesfernandez816
    @charlesfernandez816 Рік тому

    Are the datas both on collection and filter table duplicated?

    • @JoeTayactac
      @JoeTayactac  Рік тому

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

    • @charlesfernandez816
      @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.

  • @GaynardVelasco-b5m
    @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
      @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
      @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

  • @phulong.laptop
    @phulong.laptop Рік тому

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

    • @JoeTayactac
      @JoeTayactac  Рік тому

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

  • @suiyasrl6721
    @suiyasrl6721 Рік тому

    Cant find "Filter Detail"

  • @fabiandzulmoo5318
    @fabiandzulmoo5318 Рік тому

    t show no item selected
    please help

  • @Deepak-nf1fi
    @Deepak-nf1fi Рік тому

    it show no item selected

    • @JoeTayactac
      @JoeTayactac  Рік тому +1

      Your row filter expression might be wrong

    • @Deepak-nf1fi
      @Deepak-nf1fi Рік тому

      @@JoeTayactac Quick edit columns :-showing No column