Forum Discussion

JacobJacob's avatar
JacobJacob
Qrew Cadet
8 years ago

Add Child Record from Gen Add Record Form and View Child Record

Hello,

I have a process where users will add a new record and then from that add record form they need to be able to add a child record and have that parent record ID be related to that child record.  Once they save the child record it should show the child record in view mode.  As of right now it returns to the parent record in edit mode.

My questions are:
1.  How do I pass the related parent record id to the child record from an add record screen?
2. How do I view the child record after saving the child record?

Thanks all!
APIs and custom code
Formulas and functions
Relationships

5 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    I think that this is low tech.

    Go to the settings for the Parent table, Advanced Settings and check the box for

    "Save Parent record automatically when a child record is added."

    Then the default behaviour will be to return to the Parent record after saving the Child.

    If you want to stick on view mode on the child after saving, then edit the Add Child code to comment out or remove that last part which says 

    & "&z=" & Rurl()
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      8 years ago
      ie you can be in Add mode and Add Child and the Parent record will save automatically and the child will automatically connect to the Parent.
    • KellyBianchi's avatar
      KellyBianchi
      Qrew Assistant Captain
      7 years ago
      Mark, my child record saves and returns back to the parent, but in edit mode. I can't seem to make it go back in display mode. Here is my code:

      URLRoot() & "db/" & [_DBID_RUN__REQUESTS] & "?a=API_GenAddRecordForm&dfid=11&_fid_12=" & () & "&rdr="& "&z=" & Rurl()
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      I don't know of a way to return the user to the parent record in View mode.  It return you to the Parent record in the state it was in when you left it, which was edit mode (well, actually add mode), but in a typical situation the User is working their way  down a long form and filling in fields and adding children record as they go.  ie there could be multiple child tales they are completing as they work their way though the parent form.

      If you want to ensure that the user is returned the the Parent record in View mode, then the add child button would need to be clicked in view mode, so you would need to suppress the Add Child button from appearing in edit or add modes on the form.