Forum Discussion

JulioGomez's avatar
JulioGomez
Qrew Member
5 years ago

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

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
------------------------------
Button
Formulas and functions
Quickbase Sync
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago

    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
    ------------------------------