Discussions

Expand all | Collapse all

Opening Master Detail Records in New Window

  • 1.  Opening Master Detail Records in New Window

    Posted 03-27-2017 23:34
    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'))"
     


  • 2.  RE: Opening Master Detail Records in New Window

    Posted 03-28-2017 03:45
    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.


  • 3.  RE: Opening Master Detail Records in New Window

    Posted 03-28-2017 04:51
    Thanks Matt. Are you missing a parentheses somewhere?


  • 4.  RE: Opening Master Detail Records in New Window

    Posted 03-28-2017 06:41
    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)


  • 5.  RE: Opening Master Detail Records in New Window

    Posted 03-28-2017 09:05
    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


  • 6.  RE: Opening Master Detail Records in New Window

    Posted 03-30-2017 05:52
    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?


  • 7.  RE: Opening Master Detail Records in New Window

    Posted 03-30-2017 10:20
    Thanks. I had URL field. When I changed this to text, it worked. Appreciate.