Skip to main content
Question

Application variables

  • March 20, 2017
  • 0 replies
  • 142 views
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
      This topic has been closed for replies.

      Not natively. But you can create a table called Settings with 1 record in it. It will be Record ID number 1.

      Then in any tables where you need values from that single record., you can create a formula numeric field with a formula of 1 and relate that table to the the Settings table and look up values

      Set access permissions for the Settings table to the appropriate Roles.
      Actually there is an API for that. So it does mean you could enter a value on a record and push a button to call an API to update the Application Variable.

      https://help.quickbase.com/api-guide/...
      • DavidLichty
      • Registered
      • July 10, 2019
      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.

      • 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.
      It looks like this:

      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

       

      Terms & ConditionsAccessibility statement