How propose a new value for some fields every new entry

Applications Forms
#1

Hi,
I developed a form in which some values are proposed by default based on last value inserted + 1 . For istance last value inserted 10/2019 , new proposed value 11/2019
It seems easy … and I did some code that works in onApplicationInit :

sc_apl_conf(“form_ticket”, “start”, “new”);
$sql_next_rec="SELECT CONCAT(IFNULL(MAX(SUBSTRING_INDEX(id_ticket, ‘/’, 1)), 0) + 1 ,’/’, YEAR(CURDATE())) FROM ticket ";
sc_lookup(rs, $sql_next_rec);
if (isset({rs[0][0]})) // Row found
{
[glo_next_id] = ({rs[0][0]}) ;
{id_ticket}= [glo_next_id];
$num_prog = explode(’/’,{id_ticket});
[glo_index_ticket] = $num_prog[0];
{ticketid} = [glo_index_ticket];

}

When I run the application the first time everything works as expected . Es 10/2019
The issue is when I click on Insert button and SC save the record. Then using sc_apl_conf(“form_ticket”, “start”, “new”); I was expecting that new record proposed has had the right value
but it don’t work . It has still the previous value Es 10/2019 instead of 11/2019.

I did try also to copy the same code above into onScriptInit but nothing change. I also tryed to insert a sc_redir (sameform) in onAfterInsert but no way again…
I’m here stucked…
Can someone help me ?
Thanks

#2

Hi,
maybe I do not completely understand your request, but:

If I want to set a value in a field for a new record, I usually set it within the onBeforeInsert event.

This is independent from the status of the form and will be executed for inserts only.

Hope this can help you!

Sincerely

Gunter Eibl

#3

Hi Giovanni

You must insert this in OnLoad

if ( sc_btn_new ) {

your settings…

}

#4

WOWWWWWWWWWWWWWWWWWW Giorgio !!! Number 0ne !!! It works like a charm … Thanks so much Giovanni