Complex form issue

I have a form where when submitted needs to edit two tables and insert into another. I can get it to work, but the problem is that every time the form page is opened it runs the insert.

Is there a way to set two triggers to an insert? Like for example If the button is pushed AND the record doesn't exist?

You cannot set two triggers for the insert through the wizard, you would need to modify the code after it is created to add the second condition to the trigger if statement.

for example the trigger code for any form post would look like this:
if($_SERVER["REQUEST_METHOD"] == "POST"){



to add a condition for the recordset being empty, change that to:

if($_SERVER["REQUEST_METHOD"] == "POST" && ($totalRows_RecordsetName == 0)){

Thanks, I will give that a try.

Perhaps I can add that as a future product feature in an upcoming release to have multiple triggers. That would rock!

That works great but is there a way to add a third trigger that checks if a value is greater than 24? I have:

if ($_SERVER["REQUEST_METHOD"] == "POST" && ($totalRows_rsCreditCheck == 0) && ($_POST['hours'] > 24))

But that doesn't seem to work.

AH! Got it!

if ($_SERVER["REQUEST_METHOD"] == "POST" && ($totalRows_rsCreditCheck == 0) && ((isset($_POST["hours"]))?$_POST["hours"]:"") > 24)

Works great!