I've been trying for a long time to create a dash without having to use Ref Rows and Interactive option. This nailed it and I have my dashboard using this filter option instead. Many thanks 👍👍
Also, since the filter is associated per user, you could save a filter combo per user and have a dropdown of pre made filters per user to be used in the future.
This is a great idea, especially if you've got a really complex system where these sort of filters can get involved. - You could add in the ability to share these setups too, so people could get on the same page quicker-easier.
A cool thing would be to use the "filter" side to combine tables like in a sql query. Basicly generating a combined table of related feilds perhaps with dynamic virtual columns
Just in time as I’m building a bunch of dashboard within an app. Maybe you can expand on this like actions to download views as CSV within the dashboards and including enumlist columns for multiple selections. Thanks for this though, much appreciated!
today following this example I integrated it with my app and Data. I got everything working with my data with two quirks. (I deleted the Donut chart view) In my Control Box Only one criteria (out of 4) initially shows up, If I select something, the next criteria box shows up, when I select something, it will then pop up the next box, finally the last criteria box will pop up. I can't figure out what I did wrong that they won't all show up at the same time allowing me to search by any one or combination of criteria. If I go to Control Box/Quick edit columns and remove the Data Validation the box shows up, but the dropdown no longer populates. My last control box gives me a dropdown list of names ( I added it to the expression), when I pick one it goes into the criteria box, but doesn't actually filter anything. Suggestions?
In italiano: Se nella control box , in filtrer costruction_type con menu dropdown, scendessero i nomi di più tabelle, come faccio a far filtrare per data in base alla tabella scelta su “filtrer costruction_type”? in English If in the control box, in filter construction_type with dropdown menu, the names of multiple tables were listed, how can I filter by date based on the table chosen on "filtrer construction_type"? A thousand thanks
Yes it will. It's just a matter of creating a variable to hold "which view" or "view type" the person wants to see - then putting a Show If formula for each conditional view that looks at that variable.
How would we change the slice filter to use on an enumlist instead of and enum? for example, if we want to search for tassk assigned to someone in an enumlist column..
ALSO, how would we change the filter so that if we select multiple users a task is assigned to ( from an enumlist ref column referencing the users table via a valid_if) to show records of any of the selected people if multiple users are selected in the filter...? love your work! thank you!
@@MultitechVisions thank you! I got it to work by using the IN, SPLIT, AND CONCATENATE.. but it only works if i select all 3 items in the list for that record.. For example, if a task is assigned to 3 people, i want it to show if i filter by selecting any of those 3 people, but it doesn't. So i have to select all 3 specific people in the filter enum list related to that record..
Hi Matt very Good staff you have and your comments and videos are very encouraging to continue exploring Appsheet. Regarding Enhance dashboard, I have copied your app I have "translated” it to my app, and when everything is apparently fine after 50 roundabouts…, I try to delete filter with bottom and it says "Action Failed Filter Shipping Line is invalid", which is my first filter, also the bottom does not com red at all :(, any idea about what I made wrong? Many thanks !!!
Hello Matt. what does this expression mean when creating the User slice? what is its logic? if("Testing" = "false", [User_Email] = USEREMAIL(), [User_ID] = "SampleUser" ) in particular "Testing" = "false",
Great video. Have seen it like 40 times already. One thing why it is not working for me. What expressions are in the FILTER columns in the Users table? You do not show that. It is something like "IN(INDEX(CURR..." and then it stops. Want to share it? Thanks. Gr. Mike
In the description of the video have the link to the application that is being reviewed in this video, you can follow it and copy it to your account, or just look under the hood there you will see all the formulas in full
Depends on where you're talking about in the column settings; you can always check out the sample app. I try and provide links to everything in the description, that way when you need to find more (or if you want to copy one of the formulas) they're there for you when you need them. (^_^) - www.appsheet.com/Template/AppDef?appName=EnhancedDashboard-96620&appId=EnhancedDashboard-96620#Data.Columns.Users_Schema
Yes. Thanks. I found the sample, made a copy, and in the meantime am quite far with my new Employment Agency App. Within this you can filter the level, branche and education of a candidate...really nice. Now I also want to put the job opportunities in there and eventhough not in the same table candidates and vacancies need to be filtered in one go...hope I find out how ...thanks again from the Netherlands !
@@walkerabenelux7803 Essentially re-create the same functionality you did for the first table, only for your second one. - But you don't need to create a whole separate control box; just include new columns in the filter section of your user table, giving your users the fields they need to filter the secondary table. - I'll sometimes add a graphic divider bar image, to help separate the two sections out; maybe even add in a header to note what each section is.
@@MultitechVisions Allright. I'll give it a go. So that will be a new table and slicer added to the same toolbox? (In the future I definetely book a 1 on 1 with you,...lot's of questions)
ua-cam.com/video/mRbIrznurIE/v-deo.html That's the AppSheet Toolbox from AppSheetTraining.com - ua-cam.com/users/redirect?event=video_description&redir_token=QUFFLUhqbldXQV93WW8ySzNzNk5Zb29XRHZoWFhvYjZfUXxBQ3Jtc0tubFI2NXNibUQ1WnROcEVVNHBkYTBvdXNjX0tqUkRXNjBYYmZRZUtRNlBaOXVXTE5fYUtDRkVGdHZXZkoxc0NnQXBDWjdfZEJDRW51NE14M2JuSXktZHFUdDZ4V2VoQk1mWGF4WXlnaTRqUEdpV2FUOA&q=https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Fappsheet-toolbox%2Fhklmffdokpefcfabkmkpjnkoakehigjg%3Fhl%3Den%26authuser%3D0&v=mRbIrznurIE
I have a problem. In my "Dash" table let say i have column "Worker" that hold 2 (Two) names (e.g. John,Smith) in one row. The problem is the control box only pick value that only hold one name. If the row hold two names (e.g. John,Smith) then the particular task not showing. Is there any work around?
The biggest problem with trying to set things up like this, is that there's a "time lag" between when you make your selections and when the total is displayed. - There's some workarounds you can do to help, but everything is really kinda "heavy" and messy I usually try and see if there's a way to create a chart or graph somehow that can display what you're looking for.
I've been trying for a long time to create a dash without having to use Ref Rows and Interactive option. This nailed it and I have my dashboard using this filter option instead. Many thanks 👍👍
Also, since the filter is associated per user, you could save a filter combo per user and have a dropdown of pre made filters per user to be used in the future.
This is a great idea, especially if you've got a really complex system where these sort of filters can get involved.
- You could add in the ability to share these setups too, so people could get on the same page quicker-easier.
A cool thing would be to use the "filter" side to combine tables like in a sql query. Basicly generating a combined table of related feilds perhaps with dynamic virtual columns
One of the things that's really nice about creating your own dashboard control system, is you can configure it to do ANYTHING you want. (^_^)
Thx Matt, more helpful guides. Cheers
Nice job, thank you
Infinitas gracias.❤
Just what i need 👍
Thanks
Great stuff! Thanks :)
Just in time as I’m building a bunch of dashboard within an app. Maybe you can expand on this like actions to download views as CSV within the dashboards and including enumlist columns for multiple selections. Thanks for this though, much appreciated!
On the list!
today following this example I integrated it with my app and Data. I got everything working with my data with two quirks. (I deleted the Donut chart view)
In my Control Box Only one criteria (out of 4) initially shows up, If I select something, the next criteria box shows up, when I select something, it will then pop up the next box, finally the last criteria box will pop up. I can't figure out what I did wrong that they won't all show up at the same time allowing me to search by any one or combination of criteria. If I go to Control Box/Quick edit columns and remove the Data Validation the box shows up, but the dropdown no longer populates.
My last control box gives me a dropdown list of names ( I added it to the expression), when I pick one it goes into the criteria box, but doesn't actually filter anything. Suggestions?
this looks handy. can we do it without a Users table?
In italiano:
Se nella control box , in filtrer costruction_type con menu dropdown, scendessero i nomi di più tabelle, come faccio a far filtrare per data in base alla tabella scelta su “filtrer costruction_type”?
in English
If in the control box, in filter construction_type with dropdown menu, the names of multiple tables were listed, how can I filter by date based on the table chosen on "filtrer construction_type"?
A thousand thanks
I saw your subscribers were 999, so I subscribe. LOL.
WOOOHOOOOOOOO!!!!!! Thanks mate!
How to create pagination for the table?
Thanks for sharing ! will this work in case you want to showif certain views depending on teh filters ? just got the t-shirt
Yes it will. It's just a matter of creating a variable to hold "which view" or "view type" the person wants to see - then putting a Show If formula for each conditional view that looks at that variable.
How would we change the slice filter to use on an enumlist instead of and enum? for example, if we want to search for tassk assigned to someone in an enumlist column..
Can you share the virtual columns formula used in users table
ALSO, how would we change the filter so that if we select multiple users a task is assigned to ( from an enumlist ref column referencing the users table via a valid_if) to show records of any of the selected people if multiple users are selected in the filter...?
love your work! thank you!
ua-cam.com/video/mRbIrznurIE/v-deo.html
@@MultitechVisions thank you!
I got it to work by using the IN, SPLIT, AND CONCATENATE.. but it only works if i select all 3 items in the list for that record.. For example, if a task is assigned to 3 people, i want it to show if i filter by selecting any of those 3 people, but it doesn't. So i have to select all 3 specific people in the filter enum list related to that record..
Hi Matt very Good staff you have and your comments and videos are very encouraging to continue exploring Appsheet.
Regarding Enhance dashboard, I have copied your app I have "translated” it to my app, and when everything is apparently fine after 50 roundabouts…, I try to delete filter with bottom and it says "Action Failed Filter Shipping Line is invalid", which is my first filter, also the bottom does not com red at all :(, any idea about what I made wrong?
Many thanks !!!
Did you get this sorted?
Hello Matt. what does this expression mean when creating the User slice? what is its logic?
if("Testing" = "false",
[User_Email] = USEREMAIL(),
[User_ID] = "SampleUser"
)
in particular "Testing" = "false",
For anyone wondering what it's all about, I addressed it in the following live stream: ua-cam.com/video/q6ssmjfikGY/v-deo.html
Amazing! How do you turn black your text editor background?
That's the AppSheet Toolbox from appsheettraining.com/article/appsheet-toolbox-chrome-extension
@@MultitechVisions Thanks!!
Great video. Have seen it like 40 times already. One thing why it is not working for me. What expressions are in the FILTER columns in the Users table? You do not show that. It is something like "IN(INDEX(CURR..." and then it stops. Want to share it? Thanks. Gr. Mike
In the description of the video have the link to the application that is being reviewed in this video, you can follow it and copy it to your account, or just look under the hood there you will see all the formulas in full
Depends on where you're talking about in the column settings; you can always check out the sample app. I try and provide links to everything in the description, that way when you need to find more (or if you want to copy one of the formulas) they're there for you when you need them. (^_^)
- www.appsheet.com/Template/AppDef?appName=EnhancedDashboard-96620&appId=EnhancedDashboard-96620#Data.Columns.Users_Schema
Yes. Thanks. I found the sample, made a copy, and in the meantime am quite far with my new Employment Agency App. Within this you can filter the level, branche and education of a candidate...really nice. Now I also want to put the job opportunities in there and eventhough not in the same table candidates and vacancies need to be filtered in one go...hope I find out how ...thanks again from the Netherlands !
@@walkerabenelux7803 Essentially re-create the same functionality you did for the first table, only for your second one.
- But you don't need to create a whole separate control box; just include new columns in the filter section of your user table, giving your users the fields they need to filter the secondary table.
- I'll sometimes add a graphic divider bar image, to help separate the two sections out; maybe even add in a header to note what each section is.
@@MultitechVisions Allright. I'll give it a go. So that will be a new table and slicer added to the same toolbox? (In the future I definetely book a 1 on 1 with you,...lot's of questions)
how to change the background color of the formula to black?
ua-cam.com/video/mRbIrznurIE/v-deo.html
That's the AppSheet Toolbox from AppSheetTraining.com
- ua-cam.com/users/redirect?event=video_description&redir_token=QUFFLUhqbldXQV93WW8ySzNzNk5Zb29XRHZoWFhvYjZfUXxBQ3Jtc0tubFI2NXNibUQ1WnROcEVVNHBkYTBvdXNjX0tqUkRXNjBYYmZRZUtRNlBaOXVXTE5fYUtDRkVGdHZXZkoxc0NnQXBDWjdfZEJDRW51NE14M2JuSXktZHFUdDZ4V2VoQk1mWGF4WXlnaTRqUEdpV2FUOA&q=https%3A%2F%2Fchrome.google.com%2Fwebstore%2Fdetail%2Fappsheet-toolbox%2Fhklmffdokpefcfabkmkpjnkoakehigjg%3Fhl%3Den%26authuser%3D0&v=mRbIrznurIE
I have a problem. In my "Dash" table let say i have column "Worker" that hold 2 (Two) names (e.g. John,Smith) in one row. The problem is the control box only pick value that only hold one name. If the row hold two names (e.g. John,Smith) then the particular task not showing. Is there any work around?
Hello Matt, How To Set the value of Dashboard Hour SUM based on selected filter
The biggest problem with trying to set things up like this, is that there's a "time lag" between when you make your selections and when the total is displayed.
- There's some workarounds you can do to help, but everything is really kinda "heavy" and messy
I usually try and see if there's a way to create a chart or graph somehow that can display what you're looking for.
@@MultitechVisions Thanks a lot, Matt!
ƤＲＯ𝓂Ｏ𝕤ᗰ 🌟