How do I save a form and continue to another form, importing the newly created RECORDID?

Hi all, I've been trying to sort this out for too long. I have a form (Form A) with a URL link to another form (Form B) for the same Table. When you click the link it should save the form, create the RECORD ID and use that RID to go to Form B. For some reason the "%%rid%%" functionality isn't working for this. Here is the formula I am using:

var text recordid = "%%rid%%";
URLRoot() & "db/*********=er&dfid=24&rid=" & $recordid & "&z=" & Rurl() & "&ifv=1"

It says: "DRS Record not found". When I look at the URL that it directed me to it still has "%%rid"" in the actual URL instead of the new Record ID.

I have tested this url by hard coding in the next RECORD ID that will be created and the URL link works. I just need the new RECORD ID to be in the formula - URL and it's all golden.