Skip to main content
Question

Button to save parent record and redirect to a child report

  • October 15, 2019
  • 0 replies
  • 109 views

I tried to use this discussion thread:

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=31362&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmc59408cb-2abc-4bd8-94cf-e4e487fc7e7d

However, its does not answer my specific question.  

In parent table click New Record
in new (unsaved record) type in the Name of the Record
click on Button
Action expecting:
   save parent record
   in another tab open a report in the Child record

I tried:

var text GoToSection = URLRoot() & "db/" & [_DBID_SECTIONS] & "?a=q&qid=424";
var text ADD = URLRoot() & "db/" & [_DBID_FAMILIES] & "?act=API_GenAddRecordForm";
$ADD
& "&rdr=" & URLEncode($GoToSection)

Changing GotToSection to an actual https://quickbase. URL does not work so I can't use the target=_blank
NextURL instead of rdr does not work.  
I tried the "Open in a new window" field property but that cause the record to be sitting waiting to be saved.
I have tried every variation of this basic formula but after 5 hours I think this cannot be done.  However, it seems like a pretty basic thing to do. 

Any help is greatly appreciated.

Thanks

------------------------------
JeffR
------------------------------
This topic has been closed for replies.

EverettPatterso
Forum|alt.badge.img+10
On the Parent table (Settings > Advanced Settings), you should see an option "Save parent record automatically when a child record is created." Is that what you were looking for?

------------------------------
Everett Patterson
------------------------------