Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Display a Field on Home Page

I have a counter of sorts in one of my tables. Is there a clean way to just display that number on the home page, with a title? If I had a field in a table counting days until christmas, on the home page can i put, "Days Until Christmas" and display the field?

------------------------------
Mike Tamoush
------------------------------
App home pages
Tables and fields
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Mike,

    A common problem I have had.   

    I solved it by making a custom table report where I specify the Record ID#.  This way you have a single field in the report. 

    Then put that report on the dashboard.   It is not as clean a UI experience as I would like but at least it is one piece of data.

    Also make sure you clear the check boxes for Edit and View on the report.  Don't let people drill into it.


    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 years ago
      you can also take that number and convert it to  Rich Text field so it will stand out.

      var text DaysToClose = ToText(Round ([MTD Average Business Days to Process Claim (using Dashboard Filters)]));

      "<font size = +3><font color = blue>" & $DaysToClose

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • DonLarson's avatar
        DonLarson
        Qrew Elite
        6 years ago
        Mike,

        Do what Mark said.  Your Users will like that MUCH better.

        ------------------------------
        Don Larson
        Paasporter
        Westlake OH
        ------------------------------