Custom Validation on TextInput in Lightbox

Ask the community
,
1

Hey there,
I’m trying to create a TextInput custom validation to check if the inserted string is found in a database. Here’s my current code:

import wixData from ‘wix-data’;
import wixUser from ‘wix-users’;

$w.onReady(function () {
$w(“#newUserEntry”).onCustomValidation((value, reject) => {
$w(“#newUserEntry”).resetValidityIndication();

	wixData.query("UserCollection") 
		.hasAll("user", value.toString()) 
		.find() 
		.then((results) => { 
			if (parseInt(results.length) > 0) { 
				$w("#newUserEntry").validity.customError = true; 
				$w("#newUserEntry").updateValidityIndication(); 
				reject("That user already exists."); 
			} 
		}); 
});

});

The if statement fires, but the TextInput doesn’t update; am I just being stupid?

1 Like
2

Hi,
Firstly note that you don’t need to use parseInt to check the results length. As for the validation, I recommend using Regex to validate the content of the user input:

946×1204 118 KB

Good luck,
Tal.

3

Hello again Tal.
I’m checking names against a database so, as far as I’m aware, REGEX isn’t any good.
This check is also updating with each key press and Wix’s default validation checking doesn’t happen until the element has lost focus…

4

Hi Sam,

This video might help you

5

Hey Ido,
Thank you for the video. I have a working query. I can log the results perfectly fine. The problem is the actual TextInput element. I’m trying to flag a custom error on the validation so that it’ll turn red.

6

Hi Sam, how are you? where you able to figure out how to do this - would be great to hear if you have a solution. Thanks much.

7

I have the same issue - needing to do a DB query inside an input validation function. It appears the results of the query occur “later” and the input validation is already completed. I’d like to block validation until DB query is completed - how? I also tried creating a separate function to do the DB query and passed the ‘reject’ variable to it but that didn’t work either.

How can input validation with a DB query work successfully?