Custom Field Validation

[crmqwerty]

hi

i create user_name and password (custome field) in account form sugar
crm .Now i face a problem i need this username and password unique,if
any body created sername and pasword earlier then alert already exist
msg.How can i validate form.
help me plz..

[eNick]

The method will depend, somewhat, on whether you wish to use the normal Javascript validation routines. If it is critical, with something like passwords, I'd be inclined to validate both in Javascript and in PHP.

From Javascript, I'd probably use an Ajax call to call the server and run a database query to see if the username and password is ok. Otherwise, for vanilla javascript, you're going to have to transport every username and password to the client screen so it can be checked.

For backend validation, it's much easier... code up a custom hook on the before_save event. In the hook, call a routine which queries the database. If no match found, you're good to continue. If a match is found, I'd save the bean in the current user's session and redirect back to the edit page.

You'd then need a second hook which triggers on retrieval of the bean, so that you can check if there is a previous edited bean in the user's session. That way, you can update the values before display (or just swap the bean) so the user doesn't lose everything they've typed in.

[cptmac]

eNick,

I am new to sugar and I have the logic hook coded to run a query on the DB for what I am trying to validate.

Can you elaborate on the following process (or refer me to a link I can read)?

1. Save the bean in current user session and redirect back to the edit page
2. 2nd Hook for bean read to check for session bean to not lose typed in values. (not sure which hook to implement here)

Thanks in advance,

Mac