Shortcode cfdb-html – Formatting Date

Use ${Submitted}

submit_time is the raw unix timestamp. Not specific to a language. That’s seconds since 1970.

Thanks for the quick reply. But…

1. How do I format the UNIX “date” data via the “html” shortcode – or do I have to use the “table” shortcode in order to format the DateTime to my liking?
Do I need to use the info from this support doc?
“Changing Form Data Before it is Saved”
https://cfdbplugin.com/?page_id=747
… or ???

2. As an example regarding the language…
If I have my CF7 form input name as: name=”firstname”
If the CFDB “html” shortcode variables coded as: ${firstname}
… and I want to alter the data to ” strtoupper ” (as in PHP), where would I edit this variable/value?

Do I need to use the info from this support doc?
“Changing Form Data Before it is Saved”
https://cfdbplugin.com/?page_id=747
… or ???

Thanks so much for your help.

… and one follow up question …

If my form and the data display page require that the user be logged in before submitting the form, is there a variable to have the “logged in user email” displayed/stored?

Thanks.

Date:
I think you are making this overly complicated. As I understand it, you want to show the date in a specific format in [cfdb-html]. Forget about ${submit_time}. Use ${Submitted}. If you want to change the date format, go to the CFDB Options page where there is an option to change it. That changes how Submitted is displayed for all shortcodes and the admin page. Hopefully that works for you.

Login name:
If a person is logged in when he submits a form, then his user name is captured in the “Submitted Login” field. Use ${Submitted Login} in the shortcode.

Uppercase:
See: https://cfdbplugin.com/?page_id=1076

Michael … Thanks so much for your help and explanation.

Hi,

I need data between two date from this “wp_cf7dbplugin_submits” table.Here is my query
SELECT
form_name,
DATE_FORMAT(FROM_UNIXTIME(submit_time), ‘%b %e, %Y ?%l:%i %p’) As Submitted,
max(if(field_name=’name’, field_value, null )) As ‘Name’,
max(if(field_name=’email’, field_value, null )) As ‘Email’,
max(if(field_name=’mobile’, field_value, null )) As ‘phone’,
max(if(field_name=’utm_medium’, field_value, null )) As ‘utm_medium’
FROM wp_cf7dbplugin_submits
WHERE
form_name = ‘Act Now’ and submit_time =’Mar 5, 2017 6:08 AM’

But because in table date are in raw format m not getting any result .Please help

• This reply was modified 7 years, 8 months ago by geet1.

Use a shortcode
[cfdb-table form="Act Now" filter="submit_time>=Mar 5, 2017 6:08 AM&&submit_time<Mar 6, 2017 6:08 AM"]

https://cfdbplugin.com/?page_id=553