Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Opening Master Detail Records in New Window

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'))"
 
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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.
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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)
  • 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
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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?
  • Thanks. I had URL field. When I changed this to text, it worked. Appreciate.