Dynamic Confirm

Code Examples Form
#1

I need to display a ‘confirm’ message before insert that is different depending on the information entered into the Form. The Confirm Message box does not seem to take a variable. Any help or ideas?

#2

PS: I tried the onBeforeINsert, but couldn’t get anything to work there.

#3

Hi Mickyates,
Here is an alternative using SC:

1- Hide the default insert button of your form
2- Create a new button type PHP
3- On the atrribute “Confirmation Message” type your message
4. On the PHP code to execute RUN your update/insert SQL sentence

#4

Thanks hirambq;
I also figured out a tricky way to do it. The message that you put in the “Confirm Before Insert” message box is put into a javascript confirm with the content between quotes:

if (confirm (“message”)){…}

If what you put in the box is “+variable+” the resulting code is:

if (confirm(""+variable+"")){…}.

I can then change ‘variable’ and get the confirm message changed on the fly.

I will also try your suggestion. Thanks.

[QUOTE=hirambq;16518]Hi Mickyates,
Here is an alternative using SC:

1- Hide the default insert button of your form
2- Create a new button type PHP
3- On the atrribute “Confirmation Message” type your message
4. On the PHP code to execute RUN your update/insert SQL sentence[/QUOTE]