How do I to prevent new members who do not have the an ID code on my data collection from submitting a sign up form?

Ask the community
, ,
1

Each of our new members is required to have a Unique code that they enter in the sign up sheet. How do I search the code against the database to see if it is availableand show the user an error if its not ?

Defined Terms:
Form Name: Registrationform5
Text Field I want to validate " input8 "
Database/collection I want to search " AllAvailableCodes "
FieldName I want to search “Input 8” values against: " allCodes " (column 2)
FieldName I want to validate: " assignedCodes " (column 3)
Submit Button: " Button2 "

After the user clicks the submit (" Button2 "), the query should search the value inputted in to input8 against the Field " AllCodes " in the database collection of available codes: " AllAvailableCodes "

If input8 does NOT match any value in field " AllCodes " then:
—> it should result in error message that says “Code Invalid” and member registration form should not submit.

If the input8 value matches any value in field " AllCodes " then:
→ it should validate there has been a “1” inputted in to column 2, field name " AssignedCodes ". If there is a “1”, then submit successfully.
→ If there is no “1” it should send an error message “Code Not Assigned”

334×551 6.59 KB

1149×492 18.3 KB

Here is my Code so far but I don’t know how to finish it:

import wixData from'wix-data'exportfunction button2_click(event,$w){

wixData.query("AllAvailableCodes") 
  .find()
  .then( (results) => {
 if(results.items.length > 0) {
 let itemsAmount = results.length
 let firstItem = results.items[0]; 
 
 //looking if the entered value is in ---> AllCodes [if ---> YES then ----> ??? do something   /   if ---> NO ---> do something else]
 for (var i = 0; i < itemsAmount; i++) {
 if ($w('#input8').value == results.items[i].AllCodes){  }   // <------- Matching items found here (YES)
 else {   }  // <------- No matching items found here (NO)
    }

    } else {    }
  } )
  .catch( (err) => {
 let errorMsg = err;
  } );

Thank you!!!

2

:rofl::rofl::rofl: hello again my friend.

Like i see you let me do your work!!!
I gave you the code, so that you complete it bay your own.

As you can see, this part here was not complete…

for (var i = 0; i < itemsAmount; i++) {
 if ($w('#input8').value == results.items[i].AllCodes){  }   // <------- Matching items found here (YES)
 else {   }  // <------- No matching items found here (NO)
    }

Of course it will not work, because you did anything to get it to work.

if($w('#input8').value == results.items[i].AllCodes){}
else{ }

The —> { } <---- are EMPTY ! ! !

You have to tell the programm what to do, when result = valid
and when result = invalid ! ! ! What shall hapen ???

And please NO-CROSS-POSTINGS !

3

Here you can se a live-example,

CREATED JUST 4 YOU!

So please take a look how it works! Study it and then improve it by your needs.

https://russian-dima.wixsite.com/meinewebsite/validation

import wixData from 'wix-data';

$w.onReady(function () {   });

export function button1_click(event) {set_NewValue()}

function start_VALIDATION (parameter) {
    wixData.query("Validation") 
    .find()
    .then( (results) => {
 if(results.items.length > 0) {
 let itemsAmount = results.length
 let firstItem = results.items[0]; 
 
 for (var i = 0; i < itemsAmount; i++) {
 if ($w('#input1').value === results.items[i].column1){console.log("KEY-FOUND"), $w('#TXToutput').text = "KEY-FOUND", $w('#TXTkey').text = results.items[i].column1}  
 else {console.log("NO-KEY-FOUND"), $w('#TXToutput').text = "NO-KEY-FOUND", $w('#TXTkey').text = ""}  
            }
 
        } 
 else {    }
    })
    .catch( (err) => {
 let errorMsg = err;
    } );
}

export function button2_click(event) {start_VALIDATION()}

function set_NewValue() { console.log("SET")
 let myValue =  $w('#input1').value 
 let toInsert = {"column1":    myValue};

    wixData.insert("Validation", toInsert)
    .then( (results) => {
 let item = results;
        $w('#dataset1').refresh()
    } )
    .catch( (err) => {
 let errorMsg = err;
    } );
}

You can also PRESS-F12 to see all the action in CONCOLE (using google-chrome)

EDIT: some code-improvements were done.

import wixData from 'wix-data';

$w.onReady(function () { });

export function button1_click(event) {set_NewValue()}

function start_VALIDATION (parameter) {
    wixData.query("Validation") 
    .find()
    .then( (results) => {
 if(results.items.length > 0) {
 let itemsAmount = results.length
 let firstItem = results.items[0]; 
 let foundKey = ""
 for (var i = 0; i < itemsAmount; i++) {
                console.log(results.items[i].column1)
 if ($w('#input1').value === results.items[i].column1){foundKey = results.items[i].column1, console.log("KEY-FOUND")}  
 else {console.log("NO-KEY-FOUND")}  
            }
 if (foundKey>0) {$w('#TXToutput').text = "KEY-FOUND", $w('#TXTkey').text = foundKey}
 else {$w('#TXToutput').text = "NO-KEY-FOUND", $w('#TXTkey').text = ""}
        } 
 else {    }
    })
    .catch( (err) => {
 let errorMsg = err;
    } );
}

export function button2_click(event) {start_VALIDATION()}

function set_NewValue() { console.log("SET")
 let myValue =  $w('#input1').value 
 let toInsert = {"column1":    myValue};

    wixData.insert("Validation", toInsert)
    .then( (results) => {
 let item = results;
        $w('#dataset1').refresh()
    } )
    .catch( (err) => {
 let errorMsg = err;
    } );
}