Discussions

Expand all | Collapse all

Display URL link to a record

  • 1.  Display URL link to a record

    Posted 01-31-2016 15:40

    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?



  • 2.  RE: Display URL link to a record

    Top
    Contributor
    Posted 01-31-2016 15:47
    I think you are asking for this formula:

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


  • 3.  RE: Display URL link to a record

    Posted 07-19-2019 16:54
    i had to change mine a bit for it to work

    URLRoot() &"db/" &Dbid() & "?a=dr&rid=" & [Record ID#]