Guidance needed creating multi-criteria search form with subform

[kev1n]

On possibility is to add two more iframes below the existing one and then refresh them when a browse row is clicked.

E,g. refresh the iframe with ids iframe_dwelling_name and iframe_property_history:

Code: Select all

function nuSelectBrowse(e){
    
     const recordId   = $('#' + e.target.id).attr('data-nu-primary-key');
     
    // Refresh the iframe "Dwelling name"
     let f = $("#iframe_dwelling_name")[0].contentWindow; 
     f.nuSetProperty('property_id', recordId); // Set a hashcookie
     f.nuGetBreadcrumb(); // refresh the iframe

    // Refresh the iframe "Property's history"
     f = $("#iframe_property_history")[0].contentWindow;
     f.nuSetProperty('property_id', recordId);
     f.nuGetBreadcrumb();

     return false;

}

Then in the iframe's browse SQL you would have an SQL like

Code: Select all

SELECT * FROM some_table
WHERE 
your_foreign_key = '#property_id#'

[Keith-i]

That looks promising, I'll have a play. Thanks

[Keith-i]

So I now have two extra iframes and their corresponding underlying forms all created. Where does the refresh code go? Presumably somewhere in the top iframe's properties. Is it Custom Code > JS> Browse?

[kev1n]

In the Custom Code -> JS -> Browse of the iframe that shows the search results (iframe_proplist)

[Keith-i]

Thanks for that. All code looks in the right place now but all I am getting is 'no data to display' in the two new iframes. Clicking on a row in the iframe_proplist does not seem to do anything.

Pressing F12 brings up 3 messages:-
ReferenceError road_name is not defined
SyntaxError missing {
RefereneError $ (...)[0] is undefined

I can't see a missing { anywhere in the code and road_name doesn't even feature in the 2 new iframes.

Code in frm_proplist > JS > Browse

Code: Select all

function nuSelectBrowse(e){
    
     const recordId   = $('#' + e.target.id).attr('data-nu-primary-key');
     
    // Refresh the iframe "Instructions List"
     let f = $("#iframe_instructionslist")[0].contentWindow; 
     f.nuSetProperty('Propertyid', recordId); // Set a hashcookie
     f.nuGetBreadcrumb(); // refresh the iframe

    // Refresh the iframe "Enquiries List"
     f = $("#iframe_enquirieslist")[0].contentWindow;
     f.nuSetProperty('Propertyid', recordId);
     f.nuGetBreadcrumb();

     return false;

}

SQL code on first iframe (iframe_instructionslist)

Code: Select all

SELECT
 tblInstructions.*,
    tblClients.*,
    tblApplicants.*

FROM
    tblInstructions
        LEFT JOIN tblApplicants ON tblApplicants.idApplicants = tblInstructions.id_Applicants
        LEFT JOIN tblClients ON tblClients.idClients = tblInstructions.id_Clients

WHERE
    ((tblInstructions.id_Properties = '#Propertyid#'))

[kev1n]

Try prefixing these two lines with parent.

Code: Select all

parent.$("#iframe_instructionslist")[0].contentWindow;

Code: Select all

parent.f = $("#iframe_enquirieslist")[0].contentWindow;

[Keith-i]

No change I'm afraid.

I've checked my SQL in the subsidiary iframes by just putting an actual primary key number (e.g. 1000) in place of the #Propertyid# cookie and I then get the correct record showing up in the form. I've also tried replacing the 'recordID' in the JS > Browse code with the same fixed number but it doesn't seem to pass this onto the subsidiary iframes.

[kev1n]

Please provide a dump again.

[Keith-i]

Hi kev1n

Here's the main launch form dump (frm_propsearch)

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: February 15, 2023 08:21:20 AM

-- Form Description: Property Search
-- Form Code: frm_propsearch
-- Form Table:
-- Form Type: launch


--
-- zzzzsys_form: frm_propsearch_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 

VALUES ( '63eca410d38f69e', 'launch', 'frm_propsearch_clone_1', 'Property Search', NULL, '', '', '', '0', '0', '0', NULL, '', '// Add an event listener for all filter fields and if the user pressed the \"Search\" key, apply the search\n$(\"[search-field]\").each(function() {\n\n    $(this).enterKey(function(e) {\n        applySearch();\n    });\n\n});\n\nfunction applySearch() {\n\n    var frame = $(\"#iframe_proplist\")[0].contentWindow; // <--- Replace your_iframe_object_id with your iframe object id\n\n    // Set Hash Cookies (HK) for all filter fields:\n\n    // Example: Set HKs for Text fields\n    frame.nuSetProperty(\'prop_name_fltr\', prop_name_srch.value);\n    frame.nuSetProperty(\'unit_no_fltr\', unit_no_srch.value);\n    frame.nuSetProperty(\'unit_name_fltr\', unit_name_srch.value);\n    frame.nuSetProperty(\'house_no_fltr\', house_no_srch.value);\n    frame.nuSetProperty(\'road_name_fltr\', road_name_srch.value);\n    frame.nuSetProperty(\'postcode_fltr\', postcode_srch.value);\n\n    // Set HKs for Boolean fields\n    //frame.nuSetProperty(\'filter_adr_active\', nuGetValue(\'adr_active\') ? \'1\' : \'\');\n\n    frame.nuGetBreadcrumb();\n\n}', NULL, NULL, NULL, NULL, NULL ); 


--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 

VALUES ( '63eca410d3deae0', '63eca410d38f69e', 'Main', '10', NULL, NULL, NULL ); 


--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d480d5a', '63eca410d38f69e', 'Launch Form 1', 'input', 'prop_name_srch', 'Property Name', '63eca410d3deae0', '10', '12', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d48554a', '63eca410d38f69e', 'Launch Form 1', 'input', 'unit_no_srch', 'Unit No', '63eca410d3deae0', '20', '44', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d488d6f', '63eca410d38f69e', 'Launch Form 1', 'input', 'unit_name_srch', 'Unit Name', '63eca410d3deae0', '30', '76', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d48bbb6', '63eca410d38f69e', 'Launch Form 1', 'input', 'house_no_srch', 'House No', '63eca410d3deae0', '40', '108', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d48e81b', '63eca410d38f69e', 'Launch Form 1', 'input', 'road_name_srch', 'Road Name', '63eca410d3deae0', '50', '140', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d49c6ed', '63eca410d38f69e', 'Launch Form 1', 'input', 'postcode_srch', 'Postcode', '63eca410d3deae0', '60', '172', '127', '200', '22', '1', 'left', '0', '0', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, 'search-field', '0', '', '', '', '', '', '', '', NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d49f76b', '63eca410d38f69e', '', 'run', 'iframe_proplist', ' ', '63eca410d3deae0', '90', '10', '340', '1000', '300', '1', 'left', '0', '0', '0', NULL, NULL, NULL, NULL, '63e6143c4903290', NULL, 'i', '', 'F', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d4a2050', '63eca410d38f69e', '', 'input', 'btn_searchprops', 'Search', '63eca410d3deae0', '70', '211', '128', '80', '22', '1', 'left', '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 'button', NULL, NULL, NULL, '', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d4a49fb', '63eca410d38f69e', '', 'input', 'btn_resetsearch', 'Reset', '63eca410d3deae0', '80', '211', '224', '100', '22', '1', 'left', '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, 'button', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d4a7106', '63eca410d38f69e', '', 'run', 'iframe_instructionslist', ' ', '63eca410d3deae0', '100', '320', '340', '1000', '150', '1', 'left', '0', '0', '0', NULL, NULL, NULL, NULL, '63eb81b121ee54d', NULL, 'i', '', 'F', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 

VALUES ( '63eca410d4a9a9e', '63eca410d38f69e', '', 'run', 'iframe_enquirieslist', ' ', '63eca410d3deae0', '110', '480', '340', '1000', '150', '1', 'left', '0', '0', '0', NULL, NULL, NULL, NULL, '63eb901f7f6074a', NULL, 'i', '', 'F', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 


--
-- zzzzsys_event
--

INSERT INTO zzzzsys_event (zzzzsys_event_id, sev_zzzzsys_object_id, sev_event, sev_javascript, sev_json) 

VALUES ( '63eca410d567f73', '63eca410d4a2050', 'onclick', 'applySearch();', NULL ); 

INSERT INTO zzzzsys_event (zzzzsys_event_id, sev_zzzzsys_object_id, sev_event, sev_javascript, sev_json) 

VALUES ( '63eca410d569e3e', '63eca410d4a49fb', 'onclick', '$(\"[search-field]\").val(\'\'); // empty all search fields\napplySearch();\n', NULL ); 

Here's the top iframe (frm_propertylist)

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: February 15, 2023 08:23:16 AM

-- Form Description: Property List
-- Form Code: frm_propertylist
-- Form Table: tblProperties
-- Form Type: browse


--
-- zzzzsys_form: frm_propertylist_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 

VALUES ( '63eca48416ffee3', 'browse', 'frm_propertylist_clone_1', 'Property List', NULL, 'tblProperties', 'idProperties', '', '0', '0', '1', NULL, 'SELECT * FROM #TABLE_ID#\n', NULL, 'function nuSelectBrowse(e){\n    \n     const recordId   = $(\'#\' + e.target.id).attr(\'data-nu-primary-key\');\n     \n    // Refresh the iframe \"Instructions List\"\n     parent.$(\"#iframe_instructionslist\")[0].contentWindow; \n     f.nuSetProperty(\'Propertyid\', \'recordId\'); // Set a hashcookie\n     f.nuGetBreadcrumb(); // refresh the iframe\n\n    // Refresh the iframe \"Enquiries List\"\n     let f = $(\"#iframe_enquirieslist\")[0].contentWindow;\n     f.nuSetProperty(\'Propertyid\', \'recordId\');\n     f.nuGetBreadcrumb();\n\n     return false;\n\n}\n\n', NULL, NULL, NULL, NULL ); 


--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 

VALUES ( '63eca48417527cd', '63eca48416ffee3', 'Main', '10', NULL, NULL, NULL ); 


--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 

VALUES ( '63eca48416ffee3_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc16760237861661001\",\"position\":{\"top\":25,\"left\":22},\"tablename\":\"tblProperties\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false]},{\"id\":\"boxc16760237893181002\",\"position\":{\"top\":24,\"left\":247},\"tablename\":\"tblRoads\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false]}],\"joins\":{\"field_0_boxc16760237893181002--field_5_boxc16760237861661001\":\"LEFT\"}}', 'SELECT\n tblProperties.*,\n    tblRoads.*\n\nFROM\n    tblProperties\n        LEFT JOIN tblRoads ON tblRoads.idRoads = tblProperties.id_Roads\n', NULL, '1' ); 


--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417a652c', '63eca48416ffee3', 'Building Name', 'BuildingName', 'l', '', '10', '200', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417a83cb', '63eca48416ffee3', 'House No', 'HouseNo', 'l', '', '40', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417a9b30', '63eca48416ffee3', 'Unit Name', 'UnitName', 'l', '', '30', '150', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417aafca', '63eca48416ffee3', 'Unit No', 'UnitNo', 'l', '', '20', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417ac04d', '63eca48416ffee3', 'Road', 'RoadName', 'l', NULL, '50', '200', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417adc38', '63eca48416ffee3', 'Parish', 'Parish', 'l', NULL, '60', '70', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca48417ae9d2', '63eca48416ffee3', 'Postcode', 'Postcode', 'l', NULL, '70', '50', NULL ); 


--
-- zzzzsys_php
--

INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 

VALUES ( '63eca48416ffee3_BB', '63eca48416ffee3_BB', 'System PHP', 'nubuilder', '$filter = \' AND (1 = 1) \';\n\nsetFilter($filter, \'prop_name_fltr\', \'BuildingName\');\nsetFilter($filter, \'unit_no_fltr\', \'UnitNo\');\nsetFilter($filter, \'unit_name_fltr\', \'UnitName\');\nsetFilter($filter, \'house_no_fltr\', \'HouseNo\');\nsetFilter($filter, \'road_name_fltr\', \'RoadName\');\nsetFilter($filter, \'postcode_fltr\', \'Postcode\');\n\nfunction setFilter(&$filter, $filterName, $columnName) {\n    $value = nuGetProperty($filterName);\n    if ($value != \'\') $filter .= \" AND $columnName LIKE \'%$value%\' \";\n}\n$create = \"CREATE TABLE #TABLE_ID# \";\n\n$select = \"\n\nSELECT \n\n    idProperties,\n    BuildingName,\n    UnitNo,\n    UnitName,\n    HouseNo,\n    RoadName,\n    Parish,\n    Postcode\n\nFROM tblProperties LEFT JOIN tblRoads ON tblRoads.idRoads = tblProperties.id_Roads\n\nWHERE (1 = 1)\n\n\" . $filter;\n\n// To output the SQL to nuDebug Results:\nnuDebug($select);\nnuRunQuery($create . $select);\n ', NULL, NULL, '1', '0', NULL, NULL ); 

Here's the next iframe (frm_instructions)

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: February 15, 2023 08:25:20 AM

-- Form Description: Instructions List
-- Form Code: frm_instructions
-- Form Table: tblInstructions
-- Form Type: browse


--
-- zzzzsys_form: frm_instructions_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 

VALUES ( '63eca500873e58d', 'browse', 'frm_instructions_clone_1', 'Instructions List', NULL, 'tblInstructions', 'idInstructions', '', '0', '0', '0', NULL, 'SELECT\n tblInstructions.*,\n    tblClients.*,\n    tblApplicants.*\n\nFROM\n    tblInstructions\n        LEFT JOIN tblApplicants ON tblApplicants.idApplicants = tblInstructions.id_Applicants\n        LEFT JOIN tblClients ON tblClients.idClients = tblInstructions.id_Clients\n\nWHERE\n    ((tblInstructions.id_Properties = \'#Propertyid#\'))\n\n', NULL, NULL, NULL, NULL, NULL, NULL ); 


--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 

VALUES ( '63eca500878e2e6', '63eca500873e58d', 'Main', '10', NULL, NULL, NULL ); 


--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 

VALUES ( '63eca500873e58d_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc16763786651071001\",\"position\":{\"top\":25,\"left\":22},\"tablename\":\"tblInstructions\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]},{\"id\":\"boxc16763786691881002\",\"position\":{\"top\":115,\"left\":243},\"tablename\":\"tblClients\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false]},{\"id\":\"boxc16763786732271003\",\"position\":{\"top\":190,\"left\":244},\"tablename\":\"tblApplicants\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false]}],\"joins\":{\"field_0_boxc16763786732271003--field_5_boxc16763786651071001\":\"LEFT\",\"field_0_boxc16763786691881002--field_4_boxc16763786651071001\":\"LEFT\"}}', 'SELECT\n tblInstructions.*,\n    tblClients.*,\n    tblApplicants.*\n\nFROM\n    tblInstructions\n        LEFT JOIN tblApplicants ON tblApplicants.idApplicants = tblInstructions.id_Applicants\n        LEFT JOIN tblClients ON tblClients.idClients = tblInstructions.id_Clients\n\nWHERE\n    ((tblInstructions.id_Properties = \'#Propertyid#\'))\n\n', NULL, '1' ); 


--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 

VALUES ( '63eca50087c2a46', '63eca500873e58d_BR', '1', 'tblInstructions.id_Properties', '= \'#Propertyid#\'', NULL, NULL, NULL ); 


--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087de80b', '63eca500873e58d', ' Job No', 'JobNo', 'l', '', '10', '40', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e06f1', '63eca500873e58d', 'Date', 'Date', 'l', '', '20', '40', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e2a14', '63eca500873e58d', 'Flat No', 'FlatNo', 'l', '', '30', '50', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e3f3b', '63eca500873e58d', 'Valuation', 'Valuation', 'l', '', '60', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e505a', '63eca500873e58d', 'Schedule', 'Schedule', 'l', '', '70', '50', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e6214', '63eca500873e58d', 'Size', 'Size', 'l', '', '80', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e6e88', '63eca500873e58d', 'Client', 'ClientName', 'l', NULL, '40', '150', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca50087e7a9d', '63eca500873e58d', 'Applicant', 'ApplicantName', 'l', NULL, '50', '150', NULL ); 

and finally the bottom iframe (frm_enquiries)

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: February 15, 2023 08:26:12 AM

-- Form Description: Enquiries List
-- Form Code: frm_enquiries
-- Form Table: tblEnquiries
-- Form Type: browse


--
-- zzzzsys_form: frm_enquiries_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 

VALUES ( '63eca5340e83a3c', 'browse', 'frm_enquiries_clone_1', 'Enquiries List', NULL, 'tblEnquiries', 'idEnquiries', '', '0', '0', '0', NULL, 'SELECT\n tblEnquiries.*,\n    tblLender.*,\n    tblAgents.*\n\nFROM\n    tblEnquiries\n        LEFT JOIN tblLender ON tblLender.idLender = tblEnquiries.id_Lender\n        LEFT JOIN tblAgents ON tblAgents.idAgents = tblEnquiries.id_Agents\n\nWHERE\n    ((tblEnquiries.id_Properties = \'#Propertyid#\'))\n\n', NULL, NULL, NULL, NULL, NULL, NULL ); 


--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 

VALUES ( '63eca5340ed6d4c', '63eca5340e83a3c', 'Main', '10', NULL, NULL, NULL ); 


--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 

VALUES ( '63eca5340e83a3c_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc16763823154101001\",\"position\":{\"top\":25,\"left\":22},\"tablename\":\"tblEnquiries\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false,false]},{\"id\":\"boxc16763823202281002\",\"position\":{\"top\":45,\"left\":230},\"tablename\":\"tblLender\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false]},{\"id\":\"boxc16763823229091003\",\"position\":{\"top\":144,\"left\":236},\"tablename\":\"tblAgents\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false]}],\"joins\":{\"field_0_boxc16763823202281002--field_2_boxc16763823154101001\":\"LEFT\",\"field_0_boxc16763823229091003--field_5_boxc16763823154101001\":\"LEFT\"}}', 'SELECT\n tblEnquiries.*,\n    tblLender.*,\n    tblAgents.*\n\nFROM\n    tblEnquiries\n        LEFT JOIN tblLender ON tblLender.idLender = tblEnquiries.id_Lender\n        LEFT JOIN tblAgents ON tblAgents.idAgents = tblEnquiries.id_Agents\n\nWHERE\n    ((tblEnquiries.id_Properties = \'#Propertyid#\'))\n\n', NULL, '1' ); 


--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 

VALUES ( '63eca5340f1436d', '63eca5340e83a3c_BR', '1', 'tblEnquiries.id_Properties', '= \'#Propertyid#\'', NULL, NULL, NULL ); 


--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f32185', '63eca5340e83a3c', 'Date', 'Date', 'l', '', '10', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f34213', '63eca5340e83a3c', 'Flat No', 'FlatNo', 'l', '', '20', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f35966', '63eca5340e83a3c', 'Applicant', 'ApplicantName', 'l', '', '40', '200', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f3767c', '63eca5340e83a3c', 'Est Value', 'EstValue', 'l', '', '50', '60', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f38846', '63eca5340e83a3c', 'Lender', 'Lender', 'l', NULL, '30', '150', NULL ); 

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 

VALUES ( '63eca5340f394ee', '63eca5340e83a3c', 'Agent', 'Agent', 'l', NULL, '60', '100', NULL ); 

Thanks again for you help

[Keith-i]

And for reference here's a screen shot