Forums

I have a form where I take inputs from users users and validate the inputs with a custom server side PHP script when user submits the form. Within customer server side action, onSuccess, I am using db multi record loader where I have pagination enabled. Everything works fine but when I change the display num value e.g. 10 records to 20 records per page or click on Next on the pagination options, it reinvokes the custom server side validation action and shows me error messages instead of show me the next set of records. How can avoid invoking the customer server side validation after it had be performed before running the db query and have the pagination work as it should. Thanks for your help.

Hello zaheer,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I use Custom Serverside validation?
How can I run Auto and Custom Serverside Validation together?
Handling serverside validation errors . . .
How can I add Auto Serverside Validation?
How can I add a Custom Client side validation?
P.S: I'm just an automated service😉

Hi Zaheer,

I would add an value to the the form data or the User session when you first run the validation. Then on later validations check to see if the value is set; if it is then skip the validation.

Bob

PS I recommend that you don't put actions in the On Success events unless strictly necessary. You can get the same results and have a tidier form by putting them after the Custom Serverside Validation action.

Thanks Bob for the suggestion. I used session variables and was able to skip server side validation. I also removed db multi recorder loader from the On Success event and moved it below the server side validation event. I don't have the validation issue now but a new one surfaced. When the query results are first displayed and then I change the display num value e.g. 10 to 20, it runs the query again and bring more records from the db. Meaning it removes all filters (populated dynamically based on the form input fields) specified in the where clause within db multi record loader. It seems all the form field values come as NULL and the query does a select * from the table. I tried to set session variables for the form field values and call them within the WHERE clause thru a PHP script but it is not working. Does the re-submit action that get triggered after changing the display num value create a new session? Any better way to save and call the form input values that I can continue to use in the WHERE clause? Thanks.

Hi,

Please try to add to the top of the "on submit" event 2 actions:
#1- data to session, and set the config to "merge"
#2- session to data

Check if this may solve your problem!

Also please note that ChronoConnectivity is better suited for this stuff, you can install v5 and check the tutorials on the FAQs section!

Regards,
Max

Thanks Max. It worked. I will take a look at ChronoConnectivity as you suggested.