How to make a child form return to a specific step in the parent form

Question

I have an application that the user creates child records in step 3 of the parent form.  After the child records are created and saved it returns the user back to the parent form at step 1.  Is it possible to change this so that when the child record is saved it returns the user back to step 3 of the parent form?

Top Step · Answer

On new forms you can send people straight back to step 3 by putting page=3 on the parent URL in the return link.

The native Add child button usually returns with Rurl(), and that often forgets which step you were on, so you land on step 1.

Replace it with a Formula - URL button on the parent (with Auto save when redirected away from the page turned on for that table) that opens the child add form and sets the return URL yourself:

URLRoot() & "db/" & [_DBID_CHILD_TABLE]
& "?a=API_GenAddRecordForm"
& "&_fid_XX=" & [Record ID#]
& "&z=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] & "&page=3")

Swap [_DBID_CHILD_TABLE] for the child table alias, and _fid_XX for the reference field on the child that points at the parent. Use your real step number instead of 3.

After the child saves, Quickbase follows z= and opens the parent in edit mode on that step.

If the parent form is a specific non-default form, add &dfid=FORMID next to a=er as well.

Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/blog/quickbase-child-form-return-to-parent-step

Sign up

Login to the community