Form Input Validation?

[peters]

Good day,
Maybe someone can point me in the right direction.
I have several cases where I want to check in an existing table for the occurrence of a field value and I do not want to have that item value duplicated in the table field.
A good example of this could be an email address and I do not want a duplicate email addresses entered and possibly I want the email address value to be unique in an EmalAddress field.
is there any way in WWB to add in a select statement that would check for the existence of a value and then return a Boolean, true or false if the value already existed at the textbox entry level?
I know I can check for this in the submit process, but what I am after is a validation that happens when the user enters the email address, and it is validated prior to continuing the data entries or raises an alert message when exiting the email address input textbox.
I looked at the options in the Form.TextBox Validate tab in WWB, but did not see anything that would do this.
I also looked at the Form.TextBox Events tab and can add an event onfocusout and they I selected under Action: javascript, but this allows for is seems only for an alert message. I was hoping it would open up a code block where I could add in a java snippet to perform the select statement and return true if the value exists or false if the email value does not exist.
Maybe there is some other place or way to do this in WWB?
My goal is to perform the check at the textbox level and not allow the user to continue inputting.
If I am using C# I can add code at Control.Leave event with code triggered on that event to stop the user and not allow them to continue without changing the email address value. if I want the user to continue with data entry but raise an alert message, I can use the Control.Lostfocus event and add my snippet triggered by the Lostfocus event.
Hope this explains what I am looking for in WWB?
I checked out the infobubble setting, but that allows for color setting changes, etc.; but no place I could see to enter in a code block.
Maybe these features do not exist in WWB and if not can someone advise this cannot be done, then I'll look for other options.
Maybe this can be done and I just don't know where to find where to add in the code snippet within the WWB interface!

Custom code allowed in the Form.EntryObject validate level would be great and maybe I'll add this feature into enhancements for WWB?
In the Form.TextBox Validate tab, under the Input Mask-Mask: option there is an open blank area where an EditBox entry could be added allowing the entry of a code snippet at the validate level.
Just a thought?

Pete,

[Pablo]

There is no standard solution for this, because this is not directly related to 'web design' but more programming related.
So, this will require custom code.

[peters]

Thanks so much for your quick reply Pablo.
I can move on now to looking at adding in some custom code to achieve my goal. I just wanted to make sure that WWB did not have this capability hidden away in some spot. Like I did not know about the custom field collection you could add into the Logon Tools "Signup" form that you pointed to me over a week ago -lol

However, Pablo to be able to hook in custom snippets at the input object validation level would really be a great feature. You already have the code logic in WWB to hook into here. One can already add in conditions specifying max and min string lengths and as well checking to match other entries in the form so in WWB the validate hook already exists, just no way to add in a snippet code block.

WWB is a great tool and saving me mega time on the apps front end UI.
I'm still learning what options are available in WWB and learning more every day.

Pete,

[BaconFries]

just no way to add in a snippet code block.

Of course there is you can use the HTML Object for inserting external code. But to do so as previously mentioned a understanding of how to use is needed. It could be done in javascript inserted in tags <script>! custom code here!</script> placed between the <head></head> tags in the html
You can also add scripts in the Page HTML as previous such as <script>!custom code!</script> between
<head><script>!custom code!</script></head> then you would need to tie this up with the required input field but as mentioned it needs your understanding how to use which I believe you have...Google is a great help and you will find examples on stackoverflow.com on this
From Google
https://www.google.com/amp/s/www.geeksf ... ields/amp/

[peters]

Yep,
I have no problems adding in the custom code to do basically what I want.
I just needed to double check to make 100% suse I was not duplication a capability that already exists in WWB.
Project I'm on is a massive web-based application that is to be shared across Windows PC's and mobile phone devices. Boy the flexcontainer and flexgrid is making my work easier.
Got hired on as a Project Manager for a company and they had already decided to go web-based to side-step the costs associated with a native mobile app and get the product to market faster.
They already have servers in place running mySQL and PHPmyAdmin. So, WWB was a perfect fit for this project.
Over and out!
Pete,