Forum Discussion

TamaraBillings's avatar
TamaraBillings
Qrew Cadet
9 years ago

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.

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,


App home pages
NotificationsEmail
reports and charts
  • TamaraBillings's avatar
    TamaraBillings
    Qrew Cadet
    9 years ago
    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!
  • TamaraBillings's avatar
    TamaraBillings
    Qrew Cadet
    9 years ago
    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.
  • RobbiMuniz's avatar
    RobbiMuniz
    Qrew Member
    8 years ago
    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.  
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      8 years ago
      That is really cool- thanks for posting this in here!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.