Adding Values, Return 0

I can’t think of a quick way. I think you have to add a custom transform function like this:

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php');
function zero_if_null($x) {
    return is_null($x) ? 0 : $x;
}
cfdb_register_function('zero_if_null');

so you can add in the “trans”:
Value=zero_if_null(Value)

Hi Michael,

Thanks so much for the reply.

I can see how that should work, so I created the function using your shortcodes, actions, filters plugin and then added the extra part within the trans string but it still outputs nothing.

Should the function code be referencing the ‘value’ somewhere?

If it helps, I’m also using the below function, so there may be conflict?

require_once(ABSPATH . ‘wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php’);
function parse_form_money($value) {
return floatval(preg_replace(‘([^0-9.])’, ”, $value));
}
cfdb_register_function(‘parse_form_money’);

Hmmm…

There shouldn’t be a conflict. But you might want to add the convert-null-to-zero code into your functions so that you don’t have 2 functions.

I suggest pull all the “trans” clauses out, then add them back in one-by-one, checking what results you get each time.

Hi Michael,

Thanks for that. I’ve already taken up a lot of your time, but I’ll show you what I have in place which still returns nothing, as opposed to zero.

Function code:

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php');
function parse_form_money($value) {
return floatval(preg_replace('([^0-9.])', '', $value));
}
cfdb_register_function('parse_form_money');
function zero_if_null($x) {
    return is_null($x) ? 0 : $x;
}
cfdb_register_function('zero_if_null');

Shortcode:

[cfdb-value tfilter=”Customer=$user_login&&Status=Completed” trans=”Value=parse_form_money(Value)&&SumField(Value)&&Value=number_format(Value,2)&&Value=concat(￡,Value)&&Value=zero_if_null(Value)” form=”FORM NAME” show=”Value”]

Maybe I am being silly and have missed something?

Thanks again,
S

• This reply was modified 8 years, 2 months ago by Fabbstar.