capture current date and current user when formula url button is clicked

  • 1
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Trying to create a formula url button that when clicked will do the following:

1)  Change the status field (fid=12) to O-Assigned,

2)  Set the Authorized By field (fid=92) to the current user, and 

3)  Set the Date Authorized field (fid=93) to the current date


Here is what I have so far, but not sure how to add the current user and current date:

URLRoot() & "db/" & [_DBID_TICKETS] 

& "?act=API_EditRecord&rid=" & [Ticket ID#]

& "&_fid_12 =O-Assigned"

& "&_fid_92 =" <This field should be set to the current user>

& "&_fid_93 =" <This field should be set to the current date>

& "&apptoken=xxxxxxxxxxxxxxxxxxxxxx";

& "&z=" & Rurl()

Photo of Jennifer

Jennifer

  • 10 Points

Posted 4 years ago

  • 1
  • 1
Try this

& "&_fid_12=O-Assigned"

& "&_fid_92=" & TotextUser())

& "&_fid_93=" & totext(Today())

Be sure to close up those spaces after the =
Photo of Jennifer

Jennifer

  • 10 Points
Thank you Mark!  Worked great!
Good explanation. :)
Photo of Erica

Erica

  • 0 Points
Where do I put this? When I button is checked I want to capture the user and datetime it was checked.
Erica,
I think that it would be best to post a new Question.