How can I find which database table used by which forms or connections?

Identify which database tables are used by specific forms or connections in ChronoForms.

Overview

The issue arises when needing to modify a database view that could affect multiple forms, requiring a way to locate all forms or connections referencing a particular table without manually checking each one.
Use the Forms Manager and review the Connected Tables column, which includes a drop-down for each form with a DB Read or Save action to quickly scan table usage. For connections, manual checking may be necessary as there is no equivalent feature.

Ni NickOg 08 Mar, 2017
Hi

How can I find which database table is used by which forms or connections? I need to change one view that I use and that change might impact several forms. Short of looking at each form or connection, is there some way that I can search the chronoengine tables to find where a table is used?

Nick
Gr GreyHead 08 Mar, 2017
Answer
Hi Nick,

In the Forms Manager check the Connected Tables column - there is a drop-down for each form with a DB Read or Save action; you can probably scan those fairly quickly.

Bob
Ni NickOg 08 Mar, 2017
That does it Bob - thanks. No connection equivalent but I have less of them.

Thanks
Nick
This topic is locked and no more replies can be posted.