Forum Discussion
DavidLichty
6 years agoQrew Trainee
Thank you Mark!
We use Application Variables in an app for running & tracking special projects. There are three sub-dashboards with dedicated reports to track a project, and the project name is in a field within the records for a project.
That project name field is also set to an Application Variable, when they match a project's records will show on its dedicated project dashboard (1, 2 or 3)
For example:
Application Variable | Data Field for a project
[SpecialProjectFlex1]=[Project]
I used a report level Logical / Checkbox formula field to make this test. When this is true, the records will display.
With your suggestion above I was able to make a simple report on the main dashboard to show what the active projects are and which dashboard they use.
Now anyone can tell at a glance which dedicated dashboard they need for the project they are assigned to.
Thanks for the idea!
- David in Tucson
We use Application Variables in an app for running & tracking special projects. There are three sub-dashboards with dedicated reports to track a project, and the project name is in a field within the records for a project.
That project name field is also set to an Application Variable, when they match a project's records will show on its dedicated project dashboard (1, 2 or 3)
For example:
Application Variable | Data Field for a project
[SpecialProjectFlex1]=[Project]
I used a report level Logical / Checkbox formula field to make this test. When this is true, the records will display.
With your suggestion above I was able to make a simple report on the main dashboard to show what the active projects are and which dashboard they use.
- I made a report in the main table to show only record #1. (I had to show at least one record for the report to work. There is nothing within record #1 that was needed.)
- I made a report formula Text field to show the contents of the three Application Variables with plain text to say which dashboard each is associated with:
- In the report I only show that formula field. (Again, nothing from record #1 matters for this to work.)
- I added that report on the top of the main dashboard next to the buttons for the three project specific dashboards.
Now anyone can tell at a glance which dedicated dashboard they need for the project they are assigned to.
Thanks for the idea!
- David in Tucson