Pre-Populating and Validating Custom Field

[acesfull9]

I added a custom field in the studio and now I need it to be prepopulated on edit/create. Can this be done in a upgrade-safe way?

Also, I will need to validate the field to make suer it is unique across all the other records. I see that this can be done with a logic_hook, but what do I do if it is not unique? How can I return the user to the edit-view and display an error back to the screen? Or does this have to be an AJAX validation? IF so, can this be done in an upgrade-safe manner?

Thanks in advance!

[DragonflyMaster]

I added a custom field in the studio and now I need it to be prepopulated on edit/create. Can this be done in a upgrade-safe way?

Also, I will need to validate the field to make suer it is unique across all the other records. I see that this can be done with a logic_hook, but what do I do if it is not unique? How can I return the user to the edit-view and display an error back to the screen?

I think this can be done using a before_save hook.

[acesfull9]

Ok so I got it to recognize whether the field is unique on the before_save. Is there a standard way of sending an error back to the screen retaining the user-entered/modified fields?

[DragonflyMaster]

Ok so I got it to recognize whether the field is unique on the before_save. Is there a standard way of sending an error back to the screen retaining the user-entered/modified fields?

How about using a javascript alert() passing to it the field which is wrong?

[acesfull9]

How about using a javascript alert() passing to it the field which is wrong?

I am talking about in the hook on the server side when the form has already been submitted

[DragonflyMaster]

Hum, as far as I know, before_save is a hook that runs just before saving the edits. I'm talking about the opportunity to run an alert from it.

[acesfull9]

Hum, as far as I know, before_save is a hook that runs just before saving the edits. I'm talking about the opportunity to run an alert from it.

Ok now I think I am confused. I have the hook set up and I can recognize if there is an error. Could you give an example of a function that runs an alert that you are speaking of? I am familiar with javascript I am just confused about how I would go about doing what you speak of.

[DragonflyMaster]

Ok now I think I am confused. I have the hook set up and I can recognize if there is an error. Could you give an example of a function that runs an alert that you are speaking of? I am familiar with javascript I am just confused about how I would go about doing what you speak of.

Could you post the file with the logic hook?

[acesfull9]

  
    function account_before_save(&$bean, $event, $arguments){
               $cid = mysql_connect($host,$usr,$pwd);
               $SQL = " SELECT * FROM accounts_cstm where  id_c = '" . str_replace("'", "''", $bean->account_number_c) . "'";
               $retid = mysql_db_query($db, $SQL, $cid);
               if ($row = mysql_fetch_array($retid)) {
                     if($bean->account_number_c != $row["id_cl"]){
                             //there is another account with the same 
                             echo "error";
                             exit;
                      }
                }
         } 
  

How do I get an error message to display back to the screen with the submitted fields still intact? Is there an easy way? Thanks in advance!

[DragonflyMaster]

  
     function account_before_save(&$bean, $event, $arguments){
                $cid = mysql_connect($host,$usr,$pwd);
                $SQL = " SELECT * FROM accounts_cstm where  id_c = '" . str_replace("'", "''", $bean->account_number_c) . "'";
                $retid = mysql_db_query($db, $SQL, $cid);
                if ($row = mysql_fetch_array($retid)) {
                      if($bean->account_number_c != $row["id_cl"]){
                              //there is another account with the same 
                              echo "error";
                              exit;
                       }
                 }
          } 
  

How do I get an error message to display back to the screen with the submitted fields still intact? Is there an easy way? Thanks in advance!

Now I understand what you meant.
I don't know of any way to call a javascript function from this file.
What I know is you can add/call javascript code from editviewdefs.php.
In this manner you can set up an AJAX (js+php) thing...