Forum Discussion

MadushankaWeeri's avatar
MadushankaWeeri
Qrew Member
4 years ago

Getting Last Updated Date to the Home Page

Dear Team, 
Good day!
I'm trying to get the Last Updated Date to the Home Page automatically based on a CSV file upload.
I have tried multiple options but nothing has worked for me so far. I could come at least somewhat closer to my expectation using a code page and get it embedded on to the home page using a web page widget. But honestly, I have no idea how I could access and call my table data to the code page.
For better understanding of my expectation please jump into the link. :) 
https://drive.google.com/file/d/1aMrPXfDiHiBpbqGf8n5_jjBcRLKzZ-_a/view

------------------------------
Madushanka Weeriyasinghe
Application Developer
Healthrecon Connect
------------------------------

3 Replies

  • There is code that can do this, but I can't help you with that.  The low tech solution is to create a helper table with one record in it.  It will be record ID# =1.
    Make a relationship you our details table and make a summary of the max date updated.  Then show that as a one record report on the dashboard as a report a web page widget with he URL of the report suffixed with &ifv=1.

    https://mycompany.quickbase.com/db/xxxxxxx?a=q&qid=1&ifv=1

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MadushankaWeeri's avatar
      MadushankaWeeri
      Qrew Member
      Thanks for the quick response Mark, I appreciate it. 
      I tried your trick but it says "refused to connect"


      ------------------------------
      Madushanka Weeriyasinghe
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I would need to see your code to be able to correct it.  You can disguise the company realm and table dbid if you like

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------