I found an excellent post on this here: https://forum.scriptcase.net/forum/a…ic-form-record
But I have tried that method and it doesn’t seem to work. I just get a spinning graphic. Has the name of the functions changed with newer version of SC? Im on the latest V9.
Thanks for any and all help!
Here was the solution from @jsbinca in 2014, 6 years ago.
On Load Event:
if([e_id] > 0) { go_to(); // create a PHP-method with this name }
PHP-method (go_to):
$page_sql = "SELECT page FROM (SELECT @rownr := @rownr + 1 as page, employee_id FROM employee, (SELECT @rownr := 0) r
Order by employee_id) tab1
WHERE employee_id = [e_id]";
sc_lookup(rs,$page_sql);
if(isset({rs[0][0]}) && {rs[0][0]} > 0) {
[e_id] = 0;
sc_ajax_javascript('nm_navpage',array({rs[0][0]},'P'));
}
Note: the ‘Jump to’ button has to be on the toolbar.