creating a email button on the form

I would like to create an email button that send to the customer based on the "Email" field (an arrow below). 


 
On the email, I want to thank the customer for purchasing our product AND ask them to review our product by going to our website. Plus, as you see in the above, screenshot, there is a "survey" tab. I want the customer to fill in all the fields in this tab (I'll customize the fields in this tabs later). They ONLY have the access to fill in this tab.




Also, I want another button email that can be sent to the customer with another purposes. For example, if we need them to send us something like a proof of purchase, i want my customer service team to send the customer an email straight from quickbase without opening up their outlook email. It would be very nice and  convenient for them to use their email directly from the database.

Can you please help and support me with this? Thanks so much!!

Here is one way to use Notification emails.

1. Make a new form, call it the Survey form and customize it with the fields you want.
2. Make a new checkbox field, call it Survey Sent
3. Make a new email Notification, when a ticket is modified and the additional criteria can be when a specific field Survey Sent changes AND Survey Sent is equal to Checked. Choose the Survey form to send with the notification and customize the email.
4. Make a new formula url button, this can be placed on the form which will mark the checkbox and trigger the notification

URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &
    "&rid=" & [Record ID#] &
    "&_fid_305=1" &
    "&rdr=" &
    URLEncode(URLRoot() & "db/" & Dbid() &
        "?a=dr&rid=" & [Record ID#])

*replace fid_305 with your new checkbox fid

Everett Patterson,

I figured out another way to do this but been having some problem. I will try your way if this way does not work. 

I created a formula text below for a button on the form 

"mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&[subject] & [Ticket Number]&""&"&body="&[Email body]&[Ticket number LINK]&""

when I click on it, the email generated based on what I want. 



The customer will receive this email and click on the link to review our product. See below for what I see after they click on the link


As you can see, there are three tables above (Customer registrations, product registrations and tickets). I only want the customer to see the tickets and the only one I can do it is to turn off the below permissions. Otherwise, the customer will be able to access the database of all the customer and product registrations. However, by doing this, the customer information and product information on the ticket will not be shown to the customer since the info got from these tables. 


I want the customer to see their information and what they purchased and do the quick survey. How do I make the customer and product registrations are visible on the ticket form without giving them the access to these tables?

Please help. Thanks so much!

@ sales info,

You will need to open up those tables to be viewed by everyone on the internet.  I suggest reading up on that.  You will need to set up a Role and turn off all the UI settings for as much as you can.

Also note that when you build the URL to  invoke the mail to, it is a URL and that process is very sensitive to special characters in the text.  ie, the email will fail to populate completely.    So you will need to URLEncode  in the formula; such as

"mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&URLEncode([subject]) & [Ticket Number]&""&"&body="&URLEncode([Email body])&[Ticket number LINK]&""

Thanks for the warning about the URLEncode!!!

Everett Patterson,

Can you please help with the problem that I have using another method? 

Also, I tried your method and it worked. However, the email is sent to must be a specific email, or group email which I don't like. I want it to be sent to the customer's email in the ticket. 

Also, I tried your method and it worked. However, the email is sent to must be a specific email, or group email which I don't like. I want it to be sent to the customer's email in the ticket.

Did you use these options? The customer's email in the ticket is an email field, not just a text field?

Permissions - Open: Emails sent openly to anyone
Notify Whom - The email address listed in the field: [Email field name]

Everett Patterson,

I tried your method but it's not working. can you please walk me through this in details? Thanks!!