Copy search field value to input field

[Philippe]

Hi there,

On a report how I can copy the field value of my search once I click on Search  into a data entry field. In the attach screenshot when I search my EventID I would like this value to be automatically copied the EventID input field below. Also when I click on Add to create a record based on my selection how can I keep the same EventID until I search for an another event?

Thanks,

[MayMusic]

On your search page for Event ID under the advanced tab, you can check to pass the value to next page. Then on " Search and Report Wizard - Configure Results Page Fields "  screen, change the form element of this field to hidden so you can check to receive this value from the search page.  If itis not hidden you will not have receive/pass parameter options

[Philippe]

18 minutes ago, MayMusic said:

On your search page for Event ID under the advanced tab, you can check to pass the value to next page. Then on " Search and Report Wizard - Configure Results Page Fields "  screen, change the form element of this field to hidden so you can check to receive this value from the search page.  If itis not hidden you will not have receive/pass parameter options

Thanks for your quick response, tbis is  not a 2 page report - I use the one Display search form above the result,  and don't have pass value to next page!

[Glitch]

Hi @philippe,

You can use Javascript for this. 

First, you need to pass the parameter from the search form. 

Then inside your Results Page, add a Header and Footer.

Put this code inside your footer (make sure to disable HTML Editor)

<script>

// Replace Value to Parameter name
var passID = '[@Name]';
// Replace Value to the Field Name of Event ID inside table
var this_field= 'Name';

var insert_field = document.querySelector('form[action*="[@cbAppKey]"] #InlineAdd' + this_field);
insert_field.value = passID;

</script>

 

Just a little something I learned from this post: 

Thanks Mahfriend 

Sample Page: https://c0acd927.caspio.com/dp/e6cb6000e2c14d25606f4cd1ae1b

I hope this helps.

Glitch.

 

[MayMusic]

Even if you have the page on top I believe it should work please give it a try

[Philippe]

Thanks @Glitch that worked perfectly. Also used the readOnly from the post you mentioned.

Sorry @MayMusic I couldn't make your solution to work!