Forum Discussion
- KevinO_BoyleQrew CadetYou can create a formula - rich text button that references an email icon image. The button can call two nested urls, the first which is an edit record api command that will trigger an email notification of a for
; and the second component is a url redirect - CoreyEllisQrew TraineeHI and thanks for your reply. Would you be able to share the formula to use to trigger email component and then the url redirect?
- GilbertSpigelm2Qrew CadetCorey,
Download the Magic Buttons app and there you'll find a bunch of cool buttons with formula-urls to do what you want.- CoreyEllisQrew TraineeHI Thanks for your reply. I will look at the magic buttons and see if that can help.
- GilbertSpigelm2Qrew CadetUse the button to edit a record, check a box and trigger the email.
- QuickBaseCoachDQrew CaptainCorey
Here is an example of a formula URL button which will change the value of a checkbox and put up a green message for 5 seconds (5000 miliseconds)
var bool NewToggle = not [Toggle field to send email];
var text URL = URLRoot() & "db/" & "?act=API_EditRecord&rid=" & [Record ID#]
& "&_fid_80=" & $NewToggle;
"javascript:" &
"$.get('" &
$url &
"',function(){" &
"$.jGrowl('Email has been sent', {life: 5000, theme: 'jGrowl-green'});" &
"});" &
"void(0);"
Is that what you are trying to do? Just trigger an email Notification?
- CoreyEllisQrew TraineeHi Thanks for your reply - I am trying to generate an email directly to a QB user with all the fields from a form (about 10 fields). I used a URL Formula field and created a button with code: URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID] & "&dfid=29" but then it takes me to page where I have to put in the user I want to send the mail to, then hit a send button. I would like to send a direct email with the form fields to a specific user once the button is hit.
- QuickBaseCoachDQrew CaptainIf the email address is a field on the record, then you can use my post just above this one to "jiggle" a toggle field (ie a checkbox field) on the record and sent an email Notification to the email address.
If the intended recipient is not a Quick Base user then be sure to set the Type of email Notification to "Open". - CoreyEllisQrew TraineeThanks for your help! where do you specify email recipient in the formula so it knows where to send email? It is to an internal QB User.
- QuickBaseCoachDQrew CaptainYou will need to have a field on the record to use on the Notification. If it needs to actually be hard coded to a particular user, then it would be a formula email field type with a formula of
"john.smith@gmail.com - CoreyEllisQrew TraineeThanks. I cannot get this to work. The original formula I had works, I just would like to add addtional code, if possible, to send a direct email to a specific QB user.
Here is the code I used: URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID] & "&dfid=29"
Can I add a mailto code or some other logic to the code I have to email direct to a specific User? The above code adds all the fields and information I need to send via email. I am just trying to eliminate the extra step of having the QB email come up and selecting which user you want to send to and then actually hitting the send button. Thanks for your help. - QuickBaseCoachDQrew CaptainOK, I had thought that you wanted to trigger what is called an Email Notification.
If you want to use your alternative method which allows the user to customize the email, then you can add a line lke this
& "&tolist=" & [my email field]
That will populate the "to box" of that Gen email pop up screen.- CoreyEllisQrew TraineeHi - Is there a way to auto populate a subject line as well? I am using your combined formula:
URLRoot() & "db/" & Dbid() & "?a=GenEmailRecord&rid=" & [Record ID] & "&dfid=32"
& "&tolist=" & [Finance Admin]
Wanted to see if I can add a Default subject line to this formula so the subject line is filled in with a custom subject I choose. - QuickBaseCoachDQrew CaptainNot that I know of, perhaps Dan Diebolt knows