Automate sending emails with tasks
My Project Management processes (App containing a Customer table, with related Projects with multiple tasks) require that I send my customers regular emails based on "tasks / mileposts" completed. E...
Forum Discussion
The mailto command is really nothing specifically to do with QuickBase. It's a generic URL which all browsers recognize.
It will be a URL formula field type. Since you are building a URL, you may not include any spaces or special characters, so all text in the subject and the body needs to be URLEcoded. To get a paragraph break you use "%0A%0A"
I suggest that you start with a small formula and build it up step by step
You can use a URL Formula to pre-populate many fields in your email message in addition to the recipient, such as the CC, BCC, Subject, and message body, like this:
"mailto:" & [To:] & "?cc=" & [CC] & "&bcc=" & [BCC] & "&subject=" & [Subject] & "&body=" & [Body]
&"%0A%0A"
&"more body goes here"
// the above text does the subject line, below that is the body
// the %0A is a line feed type indicator.
&"&body=URLEncode("The following Go Truck had a Quality Problem:")
&"%0A%0A"
& URLEncode("Stat " &[Go Truck Status Code] & ", Shipped " & [Ship date])
&"%0A" & "Thx " & "%0A" & URLEncode(UserToName([Last Modified By]))
It will be a URL formula field type. Since you are building a URL, you may not include any spaces or special characters, so all text in the subject and the body needs to be URLEcoded. To get a paragraph break you use "%0A%0A"
I suggest that you start with a small formula and build it up step by step
You can use a URL Formula to pre-populate many fields in your email message in addition to the recipient, such as the CC, BCC, Subject, and message body, like this:
"mailto:" & [To:] & "?cc=" & [CC] & "&bcc=" & [BCC] & "&subject=" & [Subject] & "&body=" & [Body]
&"%0A%0A"
&"more body goes here"
// the above text does the subject line, below that is the body
// the %0A is a line feed type indicator.
&"&body=URLEncode("The following Go Truck had a Quality Problem:")
&"%0A%0A"
& URLEncode("Stat " &[Go Truck Status Code] & ", Shipped " & [Ship date])
&"%0A" & "Thx " & "%0A" & URLEncode(UserToName([Last Modified By]))