Skip to main content
Question

Editing "New Record" Button on Form for Child Table

  • October 27, 2020
  • 0 replies
  • 26 views

Forum|alt.badge.img+8
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
------------------------------
This topic has been closed for replies.

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/
------------------------------