Server validations not working as expected
I'm trying to check to see whether a user exists before inserting it to the database.
I have taken the below steps.
1: created a query that checks to see whether the user exit
2: Created a WA server validation
3: Created a Show If Validation
4: Also, updated other fields to ensure if values in others are entered and username exists, the data is still there and users don't have to input again.
What's happening is that it looks like the server validations work but;
1: Data in other fields are being cleared
2: The server validation message stays even though I clear the page or navigate away from the page.
What am I doing wrong? See attachment?