Discussions

Expand all | Collapse all

URL Button to "pick-up" a task (change to current user)

  • 1.  URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago

    I saw a similar post for this, but couldn't really find a resolution in there that works for me.  Here's the situation.  In our Project Management app we have tasks that remain unassigned.  I want to create a URL button that when clicked changes the "Assigned to" filed to the current user, and also changes the "status" field to "In-Progress."  The latter part of this works fine, but the former does not.  I cannot seem to get the "Assigned to" field to change, it just remains blank.

    This is the thread to which I was referring.

    This is the current button formula code: (token redacted)

    I have also attempted to use "&_fid_125=URLEncode(User())" &

    //This utilizes the API to edit the [Assigned to] (fid_125) field. It changes the [Status] (fid_12) to "In-Progress".
    URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Task ID] &
    "&apptoken=xxxxxxxxxxxxxxxxxxxxxxx" &
    "&_fid_125=ToText(User())" &
    "&_fid_12=In-Progress" &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
    "?a=dr&rid=" & [Task ID])


    ------------------------------
    Ryan Buschmeyer
    ------------------------------


  • 2.  RE: URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago
    What field type is that user field?  is it just a data entry field or is it being populated off a relationship?

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



  • 3.  RE: URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago
    Its a Data Entry field off of the default user set.

    ------------------------------
    Ryan Buschmeyer
    ------------------------------



  • 4.  RE: URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago


    ------------------------------
    Ryan Buschmeyer
    ------------------------------



  • 5.  RE: URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago
    Ah, syntax error

    "&_fid_125=ToText(User())" &

    should be 
    "&_fid_125=" & ToText(User()) &


     you were trying to stuff the actual words of "ToText(User())" into that field.   :)

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



  • 6.  RE: URL Button to "pick-up" a task (change to current user)

    Posted 21 days ago

    This worked perfectly.  thank you very much!

    (I knew it had to be something simple that I missed)



    ------------------------------
    Ryan Buschmeyer
    ------------------------------