How do I pick what form I'd like to go to once a record is saved?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a parent form that I create entries from (through an embedded report). Once I save that child form, it goes back to the parent form. I'd like it to stay on the child form once saved.

Photo of Robert

Robert

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Yes it can be done. Follow these steps to test the demo:

(1) Navigate to Table 1 and edit an existing record.

(2) Click the Add Record button to create a new child record in Table 2.

(3) Enter a [Child Name] value

(4) Save the record, A dialog will appear reporting the [Record ID#] of the newly created record and you will be redirect to the edit page for the newly created record in Table2. so you can continue editing (except there are no additional fields to edit in Table 2 - but your probably have thousands of field in your table).

Custom Child Redirection
https://haversineconsulting.quickbase.com/db/bkkg6s3wk


Passtie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=479
This can be done natively

Your ADD child button looks like this

URLRoot() & "db/" & [_DBID_TIME_RECORDS] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])
& "&_fid_21_=" & [Related Client]
& "&z=" & Rurl()

That last line causes QuickBase to return from where it came upon saving the child

Just comment it out (by the use of // )or delete that part and it will "Stick" when saved.


URLRoot() & "db/" & [_DBID_TIME_RECORDS] & "?a=API_GenAddRecordForm&_fid_11=" & URLEncode ([Record ID#])
& "&_fid_21_=" & [Related Client]
//& "&z=" & Rurl()
Photo of Robert

Robert

  • 0 Points
Appreciate it, but that's probably a little beyond my level of expertise.
Photo of Robert

Robert

  • 0 Points
Fantastic, thank you.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Nonsense - the vast majority of that code is boilerplate and you only have to specify a few parameters to make it work.