Discussions

Expand all | Collapse all

Getting Last Updated Date to the Home Page

  • 1.  Getting Last Updated Date to the Home Page

    Posted 06-01-2020 16:07
    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
    ------------------------------


  • 2.  RE: Getting Last Updated Date to the Home Page

    Posted 06-01-2020 17:13
    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
    ------------------------------



  • 3.  RE: Getting Last Updated Date to the Home Page

    Posted 06-01-2020 17:40
    Thanks for the quick response Mark, I appreciate it. 
    I tried your trick but it says "refused to connect"


    ------------------------------
    Madushanka Weeriyasinghe
    ------------------------------



  • 4.  RE: Getting Last Updated Date to the Home Page

    Posted 06-01-2020 18:36
    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
    ------------------------------