Alter the columns which are shown in the connected tables list

How to display custom form fields in the connected tables list view.

Overview

The list view for connected tables in CF only shows default columns like ID and creation date.
Navigate to the DB Viewer tab in the form settings to specify additional custom fields, such as first and last name, for display in the list.

Answered
oa oasealt 17 Oct, 2016
Hello,

when forms are submitted all the data is stored in the database. Important fields for me are first- and lastname. But when go to the list of forms after each form I have the drop-down box for connected tables. When I open the list for one form i see all entries which where made from this form. But the problem is, in the list i only see the "ID" and "Create Date/Time".
Is there a possibility to add my custom fields "firstname" and "lastname" in this view.
Because now i always have to open the detail view of one entry to get to this information. It would be much easier if I see this info in the list itselve.

Thanks in Advance.
René Glanzer
Gr GreyHead 17 Oct, 2016
Answer
Hi René,

You can specify extra columns in the DB Viewer tab

Bob

PS Personally I prefer to use PHPMyAdmin, MySQL Workbench or a Joomla! extension like MijoSQL/AceSQL
oa oasealt 18 Oct, 2016
Good morning Bob,

thank you for your help, worked perfectly!
Yes personally i also prefer phpMyAdmin or MySQL-Workbench, but the question comes from our customer so we want to make it as easy as possibly form him :-)

With kind regards
René Glanzer
This topic is locked and no more replies can be posted.