Discussions

Expand all | Collapse all

Button that looks for the current user in a table and displays the record

  • 1.  Button that looks for the current user in a table and displays the record

    Posted 04-19-2020 12:17
    Hey Folks, 

    I am looking to set up a delegation feature in Quick Base. 

    What I want is a button on the dashboard that when clicked, looks for the current user in a user table and displays their record. The thing is the the table is a Sync table and the rid is not the same as User(). 

    Currently when the button is clicked its just a link to a report where User = current user. This still requires them to select their record from the report and I'm trying to eliminate that step. 

    Thanks for any help you can provide!

    ------------------------------
    Anthony Gomez
    ------------------------------


  • 2.  RE: Button that looks for the current user in a table and displays the record

    Posted 04-19-2020 12:33

    I suggest that you set the Key field of the Sync table  yo be the Synched Userid  it will in fact be a text field  type, but that is OK  


    Then make a helper table with one Record in it. On that table make a formula URL button

    URLRoot() & "db/" & [_DBID_my sync table] & "?a=dr&key=" ToText(User())


    Then put that one record report with that one button on it on the Dashboard, but squish it as skinny as possible by having it take only 1/3 of the width and perhaps make the button label wordy si that it just looks like a big button to click on the Dashboard, which was your question. 



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