How to Add an Email/Save Button To a Form
I'm having a few issues that I'm trying to solve for a few different apps both around email buttons and sending form information. First, I have a Job Site Inspection Form that I wanted to create a ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendAre you trying to trigger an Email Notification or are you trying give the user a short cut to using the email button which is on a record and just trying to help them by populating the To Field.
If the latter, then the formula would be
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & UserToEmail[Send quote to:])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If the latter, then the formula would be
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & UserToEmail[Send quote to:])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I'm trying to give the user a short cut to using the email button on a form and want it to populate the To Field AND have the "Last Modified by", on copy for the email if it's possible.
I tried your formula and it gives the error "The field [Send quote to:] is not compatible with the parameter field type" and won't let me save due to a missing parenthesis. I put one in after the UserToEmail so the formula reads:
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & UserToEmail([Send quote to:])
which allows me to save the Field's properties but it's showing up as a hyperlink on my form when I save and load it.
------------------------------
Peter Gacek
------------------------------
I tried your formula and it gives the error "The field [Send quote to:] is not compatible with the parameter field type" and won't let me save due to a missing parenthesis. I put one in after the UserToEmail so the formula reads:
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & UserToEmail([Send quote to:])
which allows me to save the Field's properties but it's showing up as a hyperlink on my form when I save and load it.
------------------------------
Peter Gacek
------------------------------
- MarkShnier__Younp,
If you are now saying that it works then and your only problem is that you want it to appear as a button as opposed to a link then you can edit the field properties for that URL formula field and use the checkbox to display as a button and choose a colour for the button.
There is not a way to configure the "cc". but to can include the [Last Modified by] as a TO: recipient.
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & List (",", UserToEmail([Send quote to:]), UserToEmail([Last Modified by]))
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Mark,
Thanks again! I think that did it, although I did get a QB error after saying:
Cannot email an invalid quote! You cannot email this quote. Please select a valid quote and try again.
But it did send the quote, and that might be because the quote wasn't attached to any opportunity in our system.
I'll keep playing/testing and see if anything changes but thank you again!
------------------------------
Peter Gacek
------------------------------- MarkShnier__Youcan I see your formula?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------