Formula - Assign to me

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Hello,

I have created a Formula field which when the users select from a report, it automatically changes the status of the record, it captures a date and also assigns the record to themselves (new field called "Assignee") and is saved as well.

The detailed formula can be found here (App Token has been removed): 

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord"&

"&AppToken=XXX"&

"&rid="& [Record ID#]&

"&_fid_265=" & URLEncode(User()) &

"&_fid_6=In Progress" &

"&_fid_266=" & URLEncode(Now()) &

"&rdr=" & 

URLEncode(URLRoot() & "db/" & Dbid() & 

"?a=dr&rid=" & [Record ID#])



I have also added this Formula in a notification mail which is sent to a shared mailbox (which is also registered in Quick Base as a user)

When my users select the link from the Notification e-mail, the Assignee is then the mailbox, and not the current user, even though the Last Modified By is correctly updated with the current user. Please note that the user log in to Quick Base with their personal accounts, not the common one.

I de-registered this mailbox but then the Assignee was the Owner of the record. 

Any ideas on how to make it work from the notification?

Thanks.

Photo of Spyros

Spyros

  • 32 Points

Posted 4 years ago

  • 0
  • 1
Photo of Sybil

Sybil

  • 0 Points
Depending on when the value of Last Modified By changes, you may be able to change this line 

"&_fid_265=" & URLEncode(User()) &


to 

"&_fid_265=" & URLEncode([Last Modified By]) &


since Last Modified By is a User field. 
Photo of Spyros

Spyros

  • 32 Points
Hello,
thank you for your help!
I have tried this but in that case the "Last Modified by" is also the "Creator" of the request (same behavior as if the mail address were not registered).
(Maybe in that case the "Last Modified By" gets updated after the record is saved - that's why)
Any other suggestions?
Spyros