An email Notification can be triggered by a change to any field that you specify, so if you like you can just make a checkbox field and trigger off that.
But if you want a button which would work in View mode, then you can create a Date / Time field and gthern create a formula URL field with the following syntax
var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();
var text TriggerEmail = URLRoot() & "db/" & dbid() & "?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxxx" //paste you app token here
& "&_fid_99=now"; // this assumes that your date / time field used to trigger the email if field ID 99, so edit the 99
$TriggerEmail
& "&rdr=" & URLEncode($RefreshPage)
Applications Tokens are set in the Advanced Properties of the app. You may just want to turn them off and skip that line of code.
Formula above does not work then please post your formula and the error message back to the forum.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 06-02-2021 14:39
From: Peter Gacek
Subject: How to Add an Email/Save Button To a Form
You and I are in agreement, I actually prefer the Email Notification and it's what I originally had based off of the Save and Continue button but my co-worker I'm working with was hopeful that I could create a button that automatically sent an email with the form and the user who created it on copy.
So your suggestion I'm assuming is to create create a button on the page that triggers the custom email notification? I've created a new notification, what would I need to do on the button side?
------------------------------
Peter Gacek
Original Message:
Sent: 06-02-2021 14:05
From: Mark Shnier (YQC)
Subject: How to Add an Email/Save Button To a Form
re:Are 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.
I suggest that you read up on Email Notifications. https://help.quickbase.com/user-assistance/creating_custom_email_tips.html
Maybe that is what you really wanted all along.
Then we can make a button to create a change in the record which would trigger the email notification.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 06-02-2021 14:02
From: Peter Gacek
Subject: How to Add an Email/Save Button To a Form
I think it's verbatim what you suggested:
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#]
& "&tolist=" & List (",", UserToEmail([Send quote to:]), UserToEmail([Last Modified By]))
Although, now it seems to be working when I created a quote off of an opportunity, if the quote isn't attached it gives me that error but still sends the email.
Although it now brings up a new dialogue that allows me to edit the subject and body, is there a way to bypass that so it automatically sends it without checking?
------------------------------
Peter Gacek
Original Message:
Sent: 06-02-2021 13:35
From: Mark Shnier (YQC)
Subject: How to Add an Email/Save Button To a Form
can I see your formula?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 06-02-2021 12:56
From: Peter Gacek
Subject: How to Add an Email/Save Button To a Form
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
Original Message:
Sent: 06-02-2021 12:36
From: Mark Shnier (YQC)
Subject: How to Add an Email/Save Button To a Form
np,
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
Original Message:
Sent: 06-02-2021 12:32
From: Peter Gacek
Subject: How to Add an Email/Save Button To a Form
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
Original Message:
Sent: 06-02-2021 11:34
From: Mark Shnier (YQC)
Subject: How to Add an Email/Save Button To a Form
Are 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
Original Message:
Sent: 06-02-2021 10:28
From: Peter Gacek
Subject: How to Add an Email/Save Button To a Form
Hey @Mark Shnier (YQC),
You had helped me with my issue last week getting tables to connect and said if I had some specific questions about making a particular URL formula then I could post back here. I didn't want to clog the other thread but I'm still struggling with creating a formula that emails the inspection form.
I've looked through magic buttons and a few other discussions here and found this was the closest to my issue: "https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=dfc64d97-84cf-41a4-bdcf-92cb43487a33&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer"
I downloaded Magic Buttons but don't see much specific to emailing a from but I could be misunderstanding. What I'm trying to achieve is a button on the same quote request form that will send the form to a specified user from a dropdown with the last modified on copy of the email. I'd like to do the same for a Job Site Inspection form app I created but I need to rebuild that app in the CRM as it currently doesn't have Record ID# to call from.
I'm trying to understand and figure out the formulas but so far what I've come up with based on the previous discussions I read:
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID#] & "&dfid=32"
& "&tolist=" & [Send quote to:]
But it's showing up as a link and not a button and it doesn't like that my [Send quote to:] is a user field. I know I'm a bit far off here but any direction you could point me in would be greatly appreciated.
------------------------------
Peter Gacek
Original Message:
Sent: 05-26-2021 14:23
From: Peter Gacek
Subject: 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 button for that would allow the form to be emailed to a user from a drop down. I know how to configure the email drop down, but wasn't sure how to create a button based off that drop down and not just create a notification off of the "Save & Close" button.
The second is for a CRM I'm working on and a quote request form within it.
I was wondering if there was a way to replace the Save & Close button on a form or if I can change it to "Save & Send". Basically I need a way for the user to save the form and also a way for the user to send the form to multiple users including themselves on CC when a checkbox is selected.
I've figured out the notification to send a copy of the form upon clicking the "Save & Close" button and know I can add additional stipulations like if a checkbox is selected but I'm having a hard time stringing it all together.
------------------------------
Peter Gacek
------------------------------