Discussions

Expand all | Collapse all

Application variables

  • 1.  Application variables

    Posted 03-19-2017 20:54
    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


  • 2.  RE: Application variables

    Posted 03-19-2017 21:05
    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.


  • 3.  RE: Application variables

    Posted 03-21-2017 00:18
    Thank you for your response. You mean doing it with or without creating parent-child relation. I would like to do it avoiding this relation if possible. How do I create  a formula numeric that refers to a field value of another table? and automatically get that value?


  • 4.  RE: Application variables

    Posted 03-21-2017 03:13
    If you make a formula numeric field with a formula of 1 it will calculate to a 1


  • 5.  RE: Application variables

    Posted 03-21-2017 09:39
    I do not understant what you mean saying a formula of 1 �?


  • 6.  RE: Application variables

    Posted 03-21-2017 12:11
    Make field of type formula numeric.
    put a 1 in the formula box as a formula.

    Not surprisingly, it will always calculate the result to be 1.

    The point is that the settings table has a record ID# of 1 in its one and only record.so to match up with that your child table, the child table also needs to have a 1 in it to make the relationship lookup the correct record from the settings table.


  • 7.  RE: Application variables

    Posted 03-21-2017 13:02
    I see, clever idea, so that way you do not need select in table 2 anything and it all will be automatic. I understand. I will try later today. Thanks very much for your support. 


  • 8.  RE: Application variables

    Posted 03-21-2017 13:06
    Yes!  you get it!  Great.


  • 9.  RE: Application variables

    Posted 03-19-2017 21:11
    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/...


  • 10.  RE: Application variables

    Posted 03-21-2017 00:24
    My question is related to the first one. I manage to make a formula in table 2 that is able to include the same value in all records in an specific fielt refering to a variable. ToNumber([var1]). This was ok. But to change the value is not very practical to go to the application variable menu to change the varialble value. This is the reason why I wanted to create a table to access to edit these variable values. I am new with quicked and I have not idea what an API is and where I have to put it or write it. I assume is not easy but could you give me a clue or a document where it is explaned. I ckeck the user guide, but where API functions are defined, but this does not help me. I have not a clue how it works 


  • 11.  RE: Application variables

    Posted 03-21-2017 03:12
    If you are not comfortable with llearning APIs then a solution without APIs was posted as my first suggestion.

    If you want to learn about APIs I put an app in the Exchange called APIs for Dummies. It's a good starting point on the basics for making a URL formula button to do something. I have never done an API myself to update an Application variable and I'm not sure when I will have time to test that.


  • 12.  RE: Application variables

    Posted 07-10-2019 16:59
    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