I only know enough script to be dangerous to myself. I got this from Keira Bromberg who is also a QuickBase Solution Provider.
First make a dashboard button or a URL Formula text field with html enabled.
Then you make a code page called UpdateLinks (well it can be any name with no spaces ending in .html)
In my experience once you get it working it will update records one by one, thus triggering emails, at a rate of about 3 per second. So if there were 100 records to update that would take 33 seconds before the "Done" pop up comes up.
You could set the Notifications to trigger based on a date/time field being updated to whatever is in the formula date time field of now(). ie copy that now() field into a field via the script and trigger the emails off that target date/time field being changed.
Triple check the field ID's being updated and the qid of of the report that has the records to be updated so your script does not run amok!
Dashboard Button<p>
<a href="javascript:void(window.open('bd5p83fpk?a=dbpage&pagename=UpdateLinks.html&qid=189','qdbScript','top=240,left=320,width=400,height=150,location=no,menubar=no,toolbar=no'))">Update Freight Audit Links to Freight Lanes</a>
</p>
page name should have no spaces
bd5p83fpk is the table with the report
qid 189 is the report with the records to be updated
The Code page is here called UpdateLinks.html<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><HTML>
<HEAD>
<link rel="stylesheet" type="text/css" href="https://community.quickbase.com/css/style.css"/><TITLE>QuickBase Script Engine</TITLE>
// There references call in the script engine, ie 9kaw8phg
<script type="text/javascript" src="/db/9kaw8phg?a=dbpage&pagename=QuickBaseClient.js"></script>
<script type="text/javascript" src="/db/9kaw8phg?a=dbpage&pagename=qdbScript.js"></script>
<script lang="javascript">function perPage(){
//QDB Script Wizard inserts JavaScript below here!
// This is the guts of the script. Here we are identifying the record ID field as being fid 3 (its always fid 3)
// and then copying the value of fid 748 into fid 742 and then the fid 310 into fid 749
// The table being updated is bd5p83fpk
qdb.GetURL("bd5p83fpk","API_EditRecord^rid="+fid["3"]+"^_fid_742="+fid["748"]+"^_fid_749="+fid["310"]);
//QDB Script Wizard inserts JavaScript above here!
}
</script></HEAD>
<BODY style=margin:25 onload="qdbScript();" class=stdBody>
<!--QDB Script Wizard inserts HTML below here!-->
<!�Insert the message to the user below here!-->
<b>Updating xxxxxx records </b>
<!--QDB Script Wizard inserts HTML above here!-->
<DIV id=beforeScript>
<!--QDB Script Wizard inserts before script HTML below here!-->
<!--QDB Script Wizard inserts before script HTML above here!-->
</DIV>
<DIV id=duringScript style=display:none>
<!--QDB Script Wizard inserts during script HTML below here!-->
<!�Another message to the user goes here-->
<b>Now updating xxxxxxxx records ...</b>
<!--QDB Script Wizard inserts during script HTML above here!-->
</DIV>
<DIV id=afterScript style=display:none>
<!--QDB Script Wizard inserts after script HTML below here!-->
<input type=button value="Done! � All Notifications have been sent. You may now close this box" onclick=window.close()>
<!--QDB Script Wizard inserts after script HTML above here!-->
</DIV>
<DIV id="errorDiv" style=display:none></DIV>
</BODY>
</HTML>
