Search Field on form Topic is solved

[tpolimeni28]

Is there a way in the search box to run a custom search such as say I want to search row 0 for a particular work, followed by match on particular word/number in row 10?

[kev1n]

By "row", do you mean "column"?

[kev1n]

The easiest way to do this is to use a Run iFrame form and place additional search fields on the main form. You'll find an example at https://demo.nubuilder.cloud/

[tpolimeni28]

Yes, say “column 0” and column 10, for the example we will say column 0 is region, column 10 is month, column 11 idea quarter, column 12 is year. However on this search I don’t want to loose an data within said row. These columns could have different years or quarters. I still want to hold all data but just match a search “string” on those fields yet display the full data…. I guess this is where I get confused on the iframe will that report still show all data or just the data I search the match on?

I hope this make better sense of what I am trying to accomplish

[kev1n]

Did you check out the example at https://demo.nubuilder.cloud/ ? You can inspect the SQL, JS etc

filter_run.png

[tpolimeni28]

Thanks is this a fast form, can you guide me where I would create the iform from? I tried to look around which I was able to see where its created from.

[kev1n]

Add a run Object. See the video https://youtu.be/Inr_HQyfE_Q

[tpolimeni28]

In this example, is this built within the main FF, or under sub form? From the inspect source, I guess I would make the input text filters noted from this but alter to match my table data... Or am I way off this one?

<input id="Edit37_iFrame_Filter" type="text" class="input_text" data-nu-tab="16" data-nu-form="" onchange="nuChange(event)" data-nu-field="Edit37_iFrame_Filter" data-nu-object-id="60618ab98a46998" data-nu-format="" data-nu-prefix="" data-nu-type="input" data-nu-subform-sort="1" data-nu-label="First name" onfocus="nuLookupFocus(event)" data-nu-data="" data-nu-access="0" style="top: 215px; left: 706px; width: 114px; height: 31px; text-align: left; position: absolute;">

<input id="Edit37_iFrame_Filter" type="text" class="input_text" data-nu-tab="16" data-nu-form="" onchange="nuChange(event)" data-nu-field="Edit37_iFrame_Filter" data-nu-object-id="60618ab98a46998" data-nu-format="" data-nu-prefix="" data-nu-type="input" data-nu-subform-sort="1" data-nu-label="First name" onfocus="nuLookupFocus(event)" data-nu-data="" data-nu-access="0" style="top: 215px; left: 706px; width: 114px; height: 31px; text-align: left; position: absolute;">

<input id="Edit37_iFrame_Filter" type="text" class="input_text" data-nu-tab="16" data-nu-form="" onchange="nuChange(event)" data-nu-field="Edit37_iFrame_Filter" data-nu-object-id="60618ab98a46998" data-nu-format="" data-nu-prefix="" data-nu-type="input" data-nu-subform-sort="1" data-nu-label="First name" onfocus="nuLookupFocus(event)" data-nu-data="" data-nu-access="0" style="top: 215px; left: 706px; width: 114px; height: 31px; text-align: left; position: absolute;">

<input id="Edit37_iFrame_Filter" type="text" class="input_text" data-nu-tab="16" data-nu-form="" onchange="nuChange(event)" data-nu-field="Edit37_iFrame_Filter" data-nu-object-id="60618ab98a46998" data-nu-format="" data-nu-prefix="" data-nu-type="input" data-nu-subform-sort="1" data-nu-label="First name" onfocus="nuLookupFocus(event)" data-nu-data="" data-nu-access="0" style="top: 215px; left: 706px; width: 114px; height: 31px; text-align: left; position: absolute;">

<input id="Edit37_iFrame_Filter" type="text" class="input_text" data-nu-tab="16" data-nu-form="" onchange="nuChange(event)" data-nu-field="Edit37_iFrame_Filter" data-nu-object-id="60618ab98a46998" data-nu-format="" data-nu-prefix="" data-nu-type="input" data-nu-subform-sort="1" data-nu-label="First name" onfocus="nuLookupFocus(event)" data-nu-data="" data-nu-access="0" style="top: 215px; left: 706px; width: 114px; height: 31px; text-align: left; position: absolute;">

[tpolimeni28]

Add a run Object. See the video https://youtu.be/Inr_HQyfE_Q

Sorry I keep watching the video but seems to be a bit older maybe with the creation of a sub form it looks? I'm assuming this are the same in the current? Id like too just have the filter objects like the example in the existing fast form not create a new form or sub form. Simple input text, filter funnel and call it a wrap like and "advance search"

[kev1n]

Basically, all you need to create is a new launch form with the Form Builder that contains your search fields, a button (to perform the search) and
another button the is going to be used as embedded iframe.

ff.png

In the (run_iframe) button's settings, set the Type to "run", a width e.g. 600, height, 500 and in the run tab, pick the form that should be embedded.
and select the method "IFrame".

run.png