Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
5 years ago

Editing "New Record" Button on Form for Child Table

Hey Quickbase,

I'm trying to make the child object assume the values of the address of the parent Record. I'm using the address field so it's really subfield values

URLRoot()& "db/" & [_DBID_PASSINGS] & "?act=API_GenAddRecordForm"
& "fid_20=" & URLEncode ([Record ID#])
& "&_fid_34=" & URLEncode ([Building Address: Street 1])
& "&_fid_35=" & URLEncode ([Building Address: Street 2])
& "&_fid_36=" & URLEncode ([Building Address: City])
& "&_fid_37=" & URLEncode ([Building Address: State/Region])
& "&_fid_38=" & URLEncode ([Building Address: Postal Code])
& "&_fid_39=" & URLEncode ([Building Address: Country])
& "&_fid_31=" & URLEncode ([Related IDS])
& "&z="& Rurl()

my Field reference are all correct but it takes me back to the home screen when I test it out so something is wrong - the formula doesn't give me any errors.

Thank you!

------------------------------
Jack Woods
------------------------------
APIs and custom code
Buttons
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    If you wish to stay on the newly created Child record, you would just need to omit the last line - & "&z="& Rurl(). This determines if the breadcrumbs are tracked and used to return you to where you started.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      5 years ago
      That didn't work. It's no bringing me to the new record and it's wasn't/isn't making a new record either.

      It's just taking me back to the default home screen for some reason

      ------------------------------
      Jack Woods
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        this line is incorrect

        & "fid_20=" & URLEncode ([Record ID#])

        needs to be

        & "&_fid_20=" & URLEncode ([Record ID#])

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------