Date format as 'Time Ago'

From the CFDB Options page, you can set the data format based on PHP Date but I don’t think there is any kind of of option for “ago”.

To accomplish this, you would need to add a transform function, something like this in your short code:

[cfdb-table form="your-form" trans="agotime(submit_time)" hide="Submitted"]
then you would have to code that agotime function as a custom transform function

That can be used in short codes but not in the admin page view.

Thank you for the fast response!

I found this function to convert the time in a post, using a wordpress native function. Could this be modified so it would work for the time field in the table?

function time_ago( $type = 'post' ) {
    $d = 'comment' == $type ? 'get_comment_time' : 'get_post_time';

    return human_time_diff($d('U'), current_time('timestamp')) . " " . __('ago');

}

As a non-coder I don’t really have an overview of how much time it would take to get this working. If this is too time consuming to figure out for you, I understand!

OK, this won’t be that hard.

In the Add Actions and Filters plugin (Tools -> Add Actions and Filters), add this code:

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBPermittedFunctions.php');

cfdb_register_function('human_time_diff');

Then make your short code something like this:
[cfdb-table form="Form-Name" hide="now" trans="now=time()&&ago=human_time_diff(submit_time,now)"]

That worked perfectly! Thank you so much! If I may bother you one last time.

Could I add something in there to make it say ‘ago’? For example it would now say ‘4 hours’, and I was wondering if the transform could make it say ‘4 hours ago’.

[cfdb-table form="Form-Name" hide="now,ago1" trans="now=time()&&ago1=human_time_diff(submit_time,now)&&ago= concat(ago1,' ago')"]

It the latest update, you no longer need to add the code in Add Actions and Filters. Just use human_time_diff in the short code.