Formula URL that Saves record, then, after saving, edits the record, saves again and refreshes the page
Here's what I have so far. The problem is that when you click this button on the form, any changes you made before clicking this button do not get saved (even though you get the Save pop up). So can I make this button save the record and then, after saving, edit the record, save it again and reload the page?
var text URL= URLRoot() & "db/" & [_DBID_PROJECTS] & "?act=API_EditRecord"
& "&rid=" & URLEncode ([Record ID#])
& "&_fid_44=1"
& "&apptoken=" & "myapptokenishere";
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"