URL button to send email and change date field to current date.

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

I've written the formula below and the email side of things seems to be working but the time stamp isn't. Could you please help. THANKS!

"mailto:"&""&[Email]&"\n"&"?subject=Youthforce Recruitment Day"&"&body=Dear "&URLEncode([First Name])&","//

//urlroot() & "db/" & dbid() 

& "&_fid_89=" & ToTimestamp(Today())

& "&disprec=1"

Photo of Jean-Christer

Jean-Christer

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Try this

var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & ToText([Record ID#])

 & "&_fid_89=" & ToText(Today());



var text URLTWO= 

"mailto:" & urlencode([Email]) 

& "?subject=URLEncode("Youthforce Recruitment Day")

& "&body=Dear " & URLEncode([First Name]);



$URLONE 

& "&rdr=" & URLEncode($URLTWO)



Be sure to set the box to "Open in New Window".  It should set the date, but you will need to manually refresh the record to see that the date did get set.
Photo of Jean-Christer

Jean-Christer

  • 0 Points
Working perfectly now, thank you!
Great, thx for letting me know.