Submission Date Field ID

By: Todd Christensen | Asked: 03/15/2023
ForumsCategory: How-toSubmission Date Field ID
Todd ChristensenTodd Christensen asked 1 year ago

I am issuing certificates to people who complete interactive courses I've created with FormidableForms. The plug-in I'm using to create and send the PDF certificates lets me add info from FormidableForms just using the field ID. Where do I find the field ID # for the date the form is submitted? The submission button doesn't show me an ID #. Thanks for your help! Todd

2 Answers
Roland Jungwirth answered 8 months ago
Hi Todd, did you ever find an answer to that question? I need to get access to the submission date (or "created_at" field)'s value in PHP as well.
Victor Font answered 8 months ago
There is no field ID for the submission date unless you've added a date to the form to capture the date. Submission date is found in the entry's header record in the frm_items table. Formidable provides the [created-at] shortcode to display the entry's date.
Victor Font replied 8 months ago

BTW, the [created-at] shortcode is found on the advanced panel in the view editor.

Roland Jungwirth replied 8 months ago

Thank you, Victor. Any idea how to retrieve the submission date using PHP?

Victor Font replied 8 months ago

You can use the global $wpdb object to execute a SQL statement" SELECT created_at FROM frm_items WHERE id = '999'. Change 999 to the entry ID.

Roland Jungwirth replied 7 months ago

Thank you for your help, Victor.

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community