Display URL link to a record

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

I am sending a survey to a group of employees. Each employee is to complete their own specific survey. I'd like to be able to send them the link to their survey using Word Mail Merge to Outlook.

Once I create a record, I need to be able to store the URL link to the survey record in a table. I'll grab the link data through an export and manipulate through mail merge. 

Is there a way I can get this programmatically vs. copying and pasting the link into my field each time. I realize I can't get a link until the record is saved. 

I am thinking that I could create a field that concatenates the record ID into the URL as the only thing that changes is the record ID from record to record - correct? And if this is the case, is there a way to have this created through a formula that populates when the record is saved?

Photo of Andrew

Andrew

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,024 Points 20k badge 2x thumb
I think you are asking for this formula:

URLRoot() & Dbid() & "?a=er&rid=" & [Record ID#]