Exceeding formula-URL URL character length

So a combined solution of a formula-URL field and automations worked. I only have one issue left, and that's with the formula-URL field.

The formula-URL field is configured as a button on a Proposals table record. It clears a separate, unrelated Scratchpad table, then updates a trigger date/time field, which in turn causes automations to fire that add populated records to the scratchpad table. The last command re-displays the Proposals table home screen the user started from. This works well.

But I'd like to go one step further and open a chart report on the scratchpad table in a separate window. I added the URL code for the report, and while the report opened, the scratchpad table wasn't populated. It looks like the Scratchpad table was cleared and the trigger field was updated, but the automations didn't have a chance to run before the report opened, so the report displayed no data. With the original code (see below), I'm guessing the automations finish in the background while the display redisplays the Proposals table home screen.

How can I ensure that the report won't open until the automations have run? 

Thank you, Paul

-------------------------------------------------------------------------------
//Clear ScratchPad table.
var text URLClearScratchPadTable =
URLRoot() & "db/" & [_DBID_SCRATCHPAD] & "?a=API_PurgeRecords" & "&usertoken=bx56p9_nrbi_zmsnzbbk84nvhccur72awv88tf";

//Edit the proposal record to set the Cash Flow Automation Trigger text field (field ID: 2412) to the current millisecond time integer (up to 1,000). When this field is modified, automations are triggered to populate the scratchpad table.
var text URLSetTriggerField = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_2412=" & ToText(MSecond(ToTimeOfDay(Now())));

//Return to the proposal table home screen.
var text URLDisplayProposalTable = URLRoot() & "db/" & Dbid() & "?a=td";

//Execute the code.
$URLClearScratchPadTable
& "&rdr=" & URLEncode($URLSetTriggerField)
& URLEncode("&rdr=" & URLEncode($URLDisplayProposalTable))