If I understood the scenario correctly, the series of records that need to be edited are all on different tables, and are all children of one master table? Or is the series of records all on the same table?
I have done something similar to this in order to open a record and have it redirect to another specified record after saving.
I'm not sure it will work for multiple URLs, but it's worth a shot.
The button would first redirect to the first record you want to edit.
var text URLONE = URLRoot() & "db/" & tableid & "?a=er&rid=" & recordid;
I don't know how you plan to retrieve the record id. Is it the maximum record of child records related to a parent table,
or is it the first record ever created on the table?
If that's the case, you might be able to use a formula query to retrieve all record ids of a table and capture the 1st, 2nd, 3rd, etc. on the list and use them in your URLs.
I did something similar to retrieve the maximum record id of a table.
Then you can write a second variable for the record to redirect to after saving the first one:
var text URLTWO = URLRoot() & "db/" & tableid2 & "?a=er&rid=" & recordid2;
The final product in a formula-url field: $URLONE & "&NextURL=" & URLEncode($URLTWO)
For multiple URLs it would look something like this:
$URLONE & "&NextURL=" & URLEncode($URLTWO) & URLEncode("&NextURL=" & URLEncode($URLTHREE)) & URLEncode(URLEncode("&NextURL=" & URLEncode($URLFOUR)))...
------------------------------
Ahuva Brown
------------------------------
