Add second condition to Insert Record Behaviour

I have an ‘Insert record behaviour’ that is triggered by a ‘form submit’. I would like to add a second condition so it only triggers if both conditions are met. I have constructed an ‘Access Rule’ that I would like to use as the second condition.

The ‘Access Rule’ uses a ‘Record Set’ on the page which basically constructs the following:

Allow If <?php echo($rsConsLeaseholders->getColumnVal("total_flats")); ?> <= 10
( see attached screen shot for settings )

So I want the insert to fail if ’total_flats’ is 10 or less.

I have tried to adjust the insert behaviour ‘if statement’ as follows:

From this - if (isset($_POST["submit-consent-sb"]) || isset($_POST["submit-consent-sb_x"])) {

To this - if (isset($_POST["submit-consent-sb"]) || isset($_POST["submit-consent-sb_x"]) && (WA_Auth_RulePasses("10orLess"))) {

But with the adjustment the ‘Insert Behaviour’ is still being triggered when the ’total_flats’ value is more than 10.

Where am I going wrong here?
Page attached..

Thanks in advance!

Access rules can't reference recordsets. I think you would be better off just updating the trigger itself instead of using an access rule in this case. If you attach the php file then I can show you the line to update and suggest code to use.

What php file do you mean Ray?

The page with the insert record server behavior that you want to add the second trigger to.

I attached it on my first post..consent-form-c.php. I'm wanting this on numerous triggers on this page. you can show code suggestion on the insert starting on line 130. for the reg_owners_security table insert triggerd by - isset($_POST["submit-consent-s"]

Change your trigger on line 71 from:

if (isset($_POST["submit-consent-s"]) || isset($_POST["submit-consent-s_x"])) {

to:

if (isset($_POST["submit-consent-s"]) && $rsConsLeaseholders->getColumnVal("total_flats")) <= 10) {

That should do what you want... Let me know if you need any more assistance.

Thanks ray.. I had to make a slight adjustment to your code. there was one to may parentheses being used. so I tried the following:

if (isset($_POST["submit-consent-s"]) && $rsConsLeaseholders->getColumnVal("total_flats") <= 10) {

This now works fine.

Many thanks: