How to Add Download Link to Email

I got this to work (thanks to an old Mark Shnier post).  Even though you are using a custom key field; because the RID is still unique; you still use it in this formula-format.  I changed my test-table key field to a text field; and the link still worked.  You can probably play around with it to hide the URL with a cover text.  Also, your [Record ID#] might have been renamed; but it is a built-in field and cannot be deleted.  Sort your Field List by field ID# and look for the field numbered 3 to find out what it has been renamed.



"<a href=\"MailTo:lhquickbase@gmail.com"
&"?subject=Quick Specials Order"
&"&body=Attention SHNIER Customer Service, please order the following for me "

&"%0A%0A" & "My name is :______________________"
&"%0A%0A" & "My Purchase Order is:______________________"
&"%0A%0A" & "Special Instructions:______________________"
&"%0A%0A" & "My Store name is :______________________"
&"%0A%0A" & "My Tel number is :______________________"

&"%0A%0A" & "here is a link to the inventory record in Quick Specials"

&"%0A" &"https://laurahillier.quickbase.com/up/" & Dbid() & "/a/r" & [Record ID#] & "/e9/v0"

&"\">"&"Order by Email"&"</a>"

Additional Notes:
** field type = formula rich text **
** e9 ** - where 9 is the Field ID# of the file attachment field.

You can probably play some more with the encoded URL to cover the URL with a link text.