Forum Discussion

AndreonnaGarret's avatar
AndreonnaGarret
Qrew Assistant Captain
9 years ago

Only allow a specified user to click URL Button

I have a URL button for approval on a form. Above this I have a field where the user is picked. Is there a way to restrict access so that only the user specified can press this button? I have achieved...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
If your [Employee Name] field is a User field, then you can do it by making the formula cantain an if that evaluates the current user:

If([Employee Name]=User(), "My button formula for employee agrees goes here", "")

That will show the button for only the user in the employee agrees section, otherwise it will be blank.
  • AndreonnaGarret's avatar
    AndreonnaGarret
    Qrew Assistant Captain
    9 years ago
    Sorry, I am really quite new at formulas in QuickBase. How would I add this additional IF function to my current formula? The formula currently in the button is:

    var text url =
    If([Employee Agrees Check]=false,
      URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
        "&rid=" & [Record ID#] &
        "&apptoken=cp2kg3vbugcf22bd656gmp4udhs" &
        "&_fid_9=true");

    If([Employee Agrees Check]=false,
    "<a class=\"Vibrant Primary\" href=\"javascript:" & "$.get('" & $url &
        "', function(){" & "location.reload();" & "});" &
        "void(0);\">Employee Agrees</a>"
    )
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    9 years ago
    Put it before your second section.... with a slight change

    If([Employee Name]=User() AND [Employee Agrees Check]=false,
    "<a class=\"Vibrant Primary\" href=\"javascript:" & "$.get('" & $url &
        "', function(){" & "location.reload();" & "});" &
        "void(0);\">Employee Agrees</a>",
    ""
    )
  • AndreonnaGarret's avatar
    AndreonnaGarret
    Qrew Assistant Captain
    9 years ago
    Thank you! This appears to have worked perfectly!