Create email button on the form that contains long body text

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
I want to create a email button on the form to open outloook and send directly to the customer. I use formula URL below

"mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&URLEncode([subject1_Warranty Determination]) &""&"&body="&""&([Email body])&"&"


The field [Email body] is a formula text. It works fine if the email body [Email body] is short, which means that I click a button, an outlook window opens up. However, I add a long body text, nothing has came up. Can anyone please advice on how to create a button email that can have a long body formatted text?

Thank you!
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
You are creating a URL and URL may not have spaces or special charaters in them, so you need to URLEncode the body too

"mailto:" & [PR - CR - Email]
& "?subject=" & URLEncode([subject1_Warranty Determination])
& "&body="    & URLEncode([Email body])



Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training,

1. I changed the subject line to Formula Text but it still did not work

2. I've been using Chrome for web browser, so IE cannot be a problem.
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training,

No. There is no attachment in the body. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Would you then consider changing this to an email notification fired from Quick Base?

You can make up a pretty form including a company logo and use that form to email your externall client. Your inside staff can fill out the form with any special wording they want and then push a button to trigger the email notification.
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training,

By doing a notification, the email is sent from a default email [notify@quickbase] or an app owner's email, which I dont want to do that because I have each employee to login under their own email so I want the email to be sent from their email. 

Also, This is a template email for my employee to send to the customer so I want them to send what is exactly in there and do not want them to change it. 
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training,

Another wyay that I also consider is that I am gonna put the body text into a HTML page. Do you know how I can get a HTML page into an email? In other words, what is the formula to get a HTML page as a body?

Can you please assist if you know this?

Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
For a single email notification type the from email address can be from the person who last modified the record. The person who last modified the record will be the person in your company who push the button to trigger the email getting sent. The advantage of that of course is that your client can respond to the email in a normal fashion and your employee will get the email.

As for not wanting the employee to modify the template, well if you give them a form to send the customer and you don’t give your inside Staff and fields to fill out then it will be a standard template

As for getting HTML text into an email notification, you can configure the standard email notification to send an HTML page. There are many free websites available where you can type in Rich a text and it will convert that Rich text into HTML. Then you simply copy and paste that HTML into your email notification.
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training

I am considering the notification option now. Can you please guide me on how to set it up and create an email button?

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Here is some help text on how to set up an email notification

https://help.quickbase.com/user-assis...

You can also set up a date time field called date email sent

You can then trigger of the email notification to Fire when the checkbook’s field is checked and you can also set up a form rule that when the record is saved and the checkbox field has changed to change the date email sent Peel to the current date and time.

When I get a chance I will post back with the formula to create a button that will check that check box and also set the email sent daytime field to the current date and time. Meanwhile you could get the email notification built.

Post back when you get that working and that will be a reminder for me to post the formula.
Photo of Sales Info

Sales Info

  • 798 Points 500 badge 2x thumb
QuickBaseCoach App Dev./Training,

I still would not know why the email button is not working. Can you please dig into this method and help me figure out why this is not working for the long text body?

Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
If you would like one-on-one assistance you would need to contact me directly at QuickBaseCoach.com

I'm not a Quick Base employee :)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,278 Points 50k badge 2x thumb
Here is an example of code to toggle a checkbox and set a date /time field to the current date time

var bool NewToggle = not [my checkbox field top trigger an email Notification];

var text URL =
URLRoot() & "db/" & Dbid () & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxx" // or omit this line if you have disabled the need for application tokens.

 & "&_fid_12=" & $NewToggle;
& "&_fid_13=" & urlencode(Now());

"javascript:" &
"$.get('" & 
$URL & 
"',function(){" &
"location.reload(true);" &
"});" 
& "void(0);"


You will need to change the 12 and 13 to your own field IDs.
Photo of Everett Patterson

Everett Patterson

  • 996 Points 500 badge 2x thumb
To answer your original question, I believe you are reaching the maximum character limit for the mailto: command via Outlook.

Try using the email notifications as Mark suggested, copy the Send test email URL path and put that into a formula URL for your users to use as a button