How to create an Email Hyperlink on .html page (to be used on the homepage) that refers to a field to get the email address.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered

I'm trying to create a hyperlink on the homepage that opens up outlook and prepopulates email addresses from one of the fields in one of my tables.  I've been able to do this when listing out the email addresses individually, but there are about 50 email addresses at issue and they change often, so I want to refer to the field instead of listing each out.  I created two different text versions of the email field, one that ends in a semi colon and one that ends in a double backslash.  A couple versions of my html for the hyperlink is below.  Something appears to be missing.  Outlook opens, but the email addresses do not populate. 

<a href="MailTo:" & URLRoot() & "db/bi999999 "&ToText([Emailbackslash_ProjLead]) ?subject= Message"><span style="color: #008000;">Project Leads</span></a>

Or, I also tried it with the semi colon.

<a href="MailTo:" & URLRoot() & "db/bi999999"&ToText([EmailSemiColon_ProjLead]) ?subject=Message"><span style="color: #008000;">Project Leads</span></a>

I also tried incorporating a qid to a text report, but that also did not populate the email addresses.

Can you tell me what is missing?  Any suggestions would be greatly appreciated.

Thank you,


Photo of Tamara

Tamara

  • 366 Points 250 badge 2x thumb

Posted 2 years ago

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

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,004 Points 20k badge 2x thumb
You can use script and the method QBI_ValidateEmailView to send plain text email through QuickBase's server. See:

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=429

Support for mailto is patchy at best. See: 

http://stackoverflow.com/questions/9278363/emailing-to-multiple-recipients-with-html-mailto-not-work...
Photo of Tamara

Tamara

  • 366 Points 250 badge 2x thumb
Thank you.  I'll take a look at the link and see if that will work, but my goal is to let the users work within their Outlook so that they can customize their message after the email addresses have filled into the To: field.  It is not a huge number of email addresses and they are used to mailto:.  I really like to stay with what they are familiar with whenever possible.  I already have several small mailto buttons on their forms and they have the blue envelope mailto at the bottom of their reports.  All I'm looking to do is to create a similar and consistent looking button/hyperlink on the dashboard/homepage.   So if there is a way to make that work with mailto, I'm still very interested in that type of a solution.   Thanks!
Photo of Tamara

Tamara

  • 366 Points 250 badge 2x thumb
Just a bit more background.... another benefit of the mailto option for us is that the user can adhoc remove email(s) addresses if he/she needs.  Normally they would use the blue envelope at the bottom of the report.  My goal is to give him/her a shortcut button on the homepage so that they don't have to go find the report, scroll down and then click the blue envelope to populate their outlook email.  I'm just trying to make it easier for them to get to that that blue envelope step from the home page.
Photo of Robbi Lynn Muniz

Robbi Lynn Muniz

  • 60 Points
It's not a link on the dashboard but I understand that if you have an email field and that you selected "Display an icon in the totals row to email everyone in reports" in the email field settings, then pull up a report based on your table, you can just click on that icon in the last row of the report in the email column, and that would open Outlook and add the email addresses.  

However, my question is will this work with any other email programs, such as Google email and if so, how do I change the default to open a Google email instead of Outlook?  

Thank you.  
Photo of Jeanne

Jeanne

  • 30 Points
That is really cool- thanks for posting this in here!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,096 Points 50k badge 2x thumb
Your browser will have settings as to which is the default mail program to use when clicking on emails link on the internet.  So the setting is not just for QuickBase, it is for whenever you click an email link.