Opening Master Detail Records in New Window

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • Answered
  • (Edited)
I have established a master to detail routine where I am using a template to add records to a child table en masse.  It works well.  But is there a possibility that I could open the newly created records in a new window? And once these are saved,  I could see these records by pushing a button on the parent record? I understand I will use two buttons and hide these as appropriate.  I am using following statement to import records.

"javascript:void(copyMasterDetailButtonHandler('&relfids=133&sourceRID=4068&destrid=" & [Record ID#] & "', 'bksybcgkb'))"
 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
To answer part of your question (I could see these records by pushing a button on the parent record):

You can create either a formula-url or formula text field.  And structure a query to search for the records associated with that parent.

Formula-Text example:


href=' "&URLRoot() & "db/" & [_DBID_MyChildTable] & "?a=q&query={33.EX."&[Record ID#]&"}' target='_blank'

Where field id "33" is your [Related Parent] field.
Using target='_blank' will open the search in a new window/tab.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks Matt. Are you missing a parentheses somewhere?
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Yes, Sorry,  I only put part of the equation to show you the idea.

Here is a more complete option.


"<a class='Vibrant Success' href=' "&URLRoot() & "db/" & [_DBID_MyChildTable] & "?a=q&query={33.EX."&[Record ID#]&"}' target='_blank'>Search Records</a>"

(Formula Text Field with HTML enabled)
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. Tried it but there is an error.

This site can’t be reached

%3Ca%20class%3D%27vibrant%20success%27%20href%3D%27%20https’s server DNS address could not be found.
Search Google for class 'vibrant success' href https ww quickbase bmni94hr5
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
Did you change out all the appropriate variables?
the DBID, the 33 for your field doing the search, and the query item (record ID#)?

Formula text field correct?
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. I had URL field. When I changed this to text, it worked. Appreciate.