We have another example that adds 3 to the field value, will that help?
Seriously though, what is the actual problem here? You need to retrieve data from another table? Use
Database API in Server event. Field events are similar to buttons and similar to all other events. You can use any Javascript code in ClientBefore, ClientAfter events and any PHP code in Server event.
I am not looking for basic operators / numeric values in before client on how to add 2 to a value nor 3 . , I am looking to take whatever is typed in the field to check against my server event and I happen to already know the query for the Database API that's the easy part . I need to pass the value typed in by the user to before client first then server event to , Check value , then if the query value is invalid I need to after client event echo a message next to field with an error messageI guess it would be with a div statement next to field . Have searched doc's and took a look at blog with the subcategories example but not what I am looking for . I am looking for an example of client before value on entry, to pass values , to server ( check value ) and use Javascript method blur() after client or focus() with the correct value, with an echo statement.
For Example :
Field 1 : users types in a company ,
Field 2 : user types in customer id ( there could be identical customer id's )
Field 3 : user type in product code
if user types in field 1 and field 2 but field 3 does not belong for his choice ( which is determined from another table "ON SERVER" ) then I need to
loose focus or blur() field 2 and field 3 .
I am aware that the dropdown wizard can do most of this but there is a multiple outer join statement which complicates the picking up of field values for dependant dropdowns ( Red Box Does not cut it ) need error message. I have already looked at Tips and Tricks issue is it does not help me with error messages and blur() .
Or do I have to custom code this in html/javascript with custom function and AJax and POST or Jquery to use this in PHPrunner instead of custom solution . If so where would I put the code in PHPrunner 10.2 build 33375 .I thought this was all deprecated in 9.8. as far as using the editor as opposed to designer in html to accomplish something like this.
Thanks in advance of your response.