I have an application that has a parent child table relationship. After the user sets up the Shipment (Parent) they will add Items (Child) to the shipment. The amount of items can be different every time a Shipment is created. When the user is done adding items to the shipment I want to send an email notification. My question is what is the best way to trigger the notification when the user is finished adding items? I do not want to send a notification every time an item is added and sending a notification when the Shipment is set up does not actually mean the shipment is ready for processing as the user needs to still add Items to the shipment. Any suggestions is much appreciated.

I suggest making a formula URL button to populate a field with the current date/time. to trigger the Notification based on that field changing. The button would be on the parent record. I can help you with the formula if you need that help.

Ok, so how would that work? The user clicks a button, the field is updated, and because the field is modified, the notification is sent?

Yes can you send the formula to do that? Thanks

I have a checkbox field named Shipment_Complete. Can that be used as the modified field? If not the current date and time field would be fine. What type of field would that be?

var text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord"& "&apptoken=xxxxxxxxx"& "&_fid_xx=" ToText(now());"javascript:" & "$.get('" & $URL & "',function(){" & "location.reload(true);" & "});" & "void(0);"// note, if you have application tokens enabled in the Advanced Properties setting for the app, you will need to include that apptoken lineReplace xx with the field Id of a date time field that you will use on the form to show the users when the notification has been sent.

Best way to trigger notification email

19 Replies

BrianDunk
Qrew Cadet
7 years ago
Ok here is what I received:

Require Application tokens check box under Security Options is unchecked.
BrianDunk
Qrew Cadet
7 years ago
Yes I ran it without the apptoken line.
QuickBaseCoachD
Qrew Captain
7 years ago
what happened when you ran it without the javascript, like i suggested.
BrianDunk
Qrew Cadet
7 years ago
Same error:
QuickBaseCoachD
Qrew Captain
7 years ago
OK, yes I left out the most important part of the formula, which record to edit!

var text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord"
& "&rid=" & [Record ID#]
& "&_fid_xx=" & ToText(now());

"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
BrianDunk
Qrew Cadet
7 years ago
Still nothing happening. EmailSent date/time field still blank.

Error with no Java:
QuickBaseCoachD
Qrew Captain
7 years ago
That as a success message. The original button will now work if you add in that extra line like I suggested.
BrianDunk
Qrew Cadet
7 years ago
Success!!!!! Thanks so much for the help.

Forum Discussion

Best way to trigger notification email

19 Replies

Related Content

Pipeline Not Triggering

custom email

New Notifications

New email notification beta has arrived

Let's Test the Email Notifications