What is the database table for the submissions?

To anyone reading this, I discovered the database tables being used:

The form submissions are treated as a post type called elementor_cf_db … so, wp_posts and wp_postmeta hold the data.

Sadly the actual form data is stored in a horribly huge serialized string in wp_postmeta: in meta_value of a meta_key named sb_elem_cfd.

This is a huge serialized string with all elements of elementor page display and even all data elements (including all select options of the form) within this one serialized field. YIKES!!!!

There is absolutely no practical way of querying this from SQL. PHP may offer more options to unserialize and parse this data.

Elementor now has a beta feature for submissions that does arguably a better job … and it needs to be enabled in Elementor settings. However, I suspect getting at it’s database tables data will present similar challenges, but at least Elementor’s beta submissions allow easy bulk export of all submitted data.

Best of all, the plugin Form Vibes is excellent for this. Like the other 2 already mentioned, it autodetects the submissions (and won’t see already made submissions). It excels in having the data in 2 custom mysql tables that are easy to query from SQL.

• This reply was modified 3 years, 7 months ago by laymonk.

Hi, Here’s a sql query to get the form submissions:

select
	s.referer,
	s.referer_title,
	s.form_name,
	s.created_at,
	sv.key,
	sv.value
from
	[your_table_prefix_]e_submissions s
inner join [your_table_prefix_]e_submissions_values sv on
	s.id = sv.submission_id
where
	type = 'submission'