Application variables
Is it possible to create a table where defined application variables could be updated? How fields of this table could be defined to call the application variable
Forum Discussion
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
