Form Table name

Digital Team asked on December 16, 2016 13:41

Hi,

I'm looking where the forms save the "Form Table Name" in the database.

When you edit the form in CMSDESK it says in the field "FORM_ContactForm_1" and the table exists on the database. The thing is that i'm not able to find where and how "FORM_ContactForm_1" is related with the CMS_Forms entry. I thought in CMS_Forms is a "Form_table_name" field, but definitively not in there.

Thanks!.

kentico 7

Recent Answers

Anton Grekhovodov answered on December 16, 2016 13:51 (last edited on December 16, 2016 13:51)

Hi,

It's for kentico 8, but I think it's the same for Kentico 7:
In CMS_forms there is FormClassId, you can find the class by this id in CMS_Class table and there is ClassTableName in this table

1 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on December 16, 2016 14:02

The CMS_Class table holds the main definition of the form (class name, table name, field definitions, etc). The CMS_Form table holds pretty much everything else on the general and other tabs except the Recorded Data tab. The data the form actually collects is stored in the table name Recorded on the general tab. So if you were to run a query to get the form and the class definition, it would look something like this:

select *
from cms_class
    inner join cms_form on ClassID = FormClassID and ClassIsForm = 1

2 votesVote for this answer Mark as a Correct answer