We are encrypting information and letting GF store it. However the 200 varchar limit breaks GPG output since its always going to be larger then that. Two questions:
1) Why the tight limit? Was it a setup option I missed?
2) Our fix was modifying the table: alter table wp_rg_lead_detail modify value varchar(2048);
Any concerns with this?
Thx for the API, made my life way better today!
John-
The reason for the 200 character limit was for speed in loading the entries in the admin. If it works for you, it works.
There is also a wp_rg_lead_detail_long for the full entry.
Is there a way to access 'wp_rg_lead_detail_long' within the notification?
When I check wp_rg_lead_detail_long it is empty. How do entries get into this table?
Entries get into the wp_rg_lead_detail_long table when they exceed 200 characters. Gravity Forms stores the first 200 characters in the wp_rg_lead_detail table and if the submitted value is larger than 200 characters, the full value is stored in the wp_rg_lead_detail_long table. So the wp_rg_lead_detail_long table will only have entries when needed.
All of that should be transparent to you though. When you access the $entry object within one of our hooks, it should give you the full value of the field (it will get it from the wp_rg_lead_detail_long table if needed).
How exactly are you storing these encrypted fields? Are you inserting them manually or are they fields in the form? How are you reading the encrypted value? Which hook(s) are you using?
I am using the hook as below. When I use this the detail is NOT updated. We get no detail entries.
Here is our hook function.
----
[php]
function save_field_value($value, $lead, $field){
if($field['adminLabel'] == $SPECIALFIELDNAME){
require_once 'Crypt/GPG.php';
$gpg = new Crypt_GPG(array('homedir' => $KEYDIR, 'debug' => false));
$gpg->addEncryptKey($KEYNAME);
$encrypted = $gpg->encrypt($value);
return $encrypted;
} else {
return $value;
}
}----
Ok. Now I understand what is going on. There was actually a problem with the position of the gform_save_field_value filter that prevented it from accepting values greater than 200 characters. I have made an adjustment and it looks like it will work OK for you. Please email me to alex@rocketgenius.com and I will send it your way.
Sent, tx Alex!
Hi Alex, I'm also having issues with this. Could you send this update to me as well?
Bjørn, please send an email to alex@rocketgenius.com and reference this topic and your reply. Thank you.
