Hi,
Since I'm not expert in programming....
How can do (in details step by step) to check if the record/data already exist in database before user submit or save to database.
1) User enter the data in registration form
2) System will check when user click submit
3) If record already exist, message will appear: "Email/ Phone number already exist"
4) If record not in database, submission will be save and email to admin.
UPDATE
---------------------------------
I already used the Read Data action.
But the messages "already registered" still appear even there's no record registered. And not save
The form only can register one time.
I have attached my backup sample form for checking[file=11760]Test_Read_and_Save_Data_17_Mar_2019_12_50_28.cf6bak[/file]
Since I'm not expert in programming....
How can do (in details step by step) to check if the record/data already exist in database before user submit or save to database.
1) User enter the data in registration form
2) System will check when user click submit
3) If record already exist, message will appear: "Email/ Phone number already exist"
4) If record not in database, submission will be save and email to admin.
UPDATE
---------------------------------
I already used the Read Data action.
But the messages "already registered" still appear even there's no record registered. And not save
The form only can register one time.
I have attached my backup sample form for checking[file=11760]Test_Read_and_Save_Data_17_Mar_2019_12_50_28.cf6bak[/file]
You haven't put anything in the Where Conditions of the data read, so how's it supposed to know what it's looking for? You're basically telling it "If there are any records in the database AT ALL, don't save"
Hi Healyhatman,
I have put the condition like this in Where Conditions, but its not working
Data.14:{nama:nama}
Data.14:{email.email}
It is the correct format.? If no, what are the correct format.?
I have put the condition like this in Where Conditions, but its not working
Data.14:{nama:nama}
Data.14:{email.email}
It is the correct format.? If no, what are the correct format.?
Not at all.
dbfieldname:{data:form_field_name}So that's
name_of_the_field_in_your_database:{data:name_of_the_field_in_your_form}
This topic is locked and no more replies can be posted.
