You are viewing limited content. For full access, please sign in.

Question

Question

Feature Enhancement - Forms Data Sources

asked on June 12, 2024

On the forms administration page, it shows the Data Sources which are the SQL databases used for lookups. For us, most of these SQL databases have many tables used for lookups.

It would be even more helpful if I could select the data source (SQL database) and then have it display the tables used from that database and which processes are using them.

This will help us maintain our SQL databases, in that if we want to delete a process, we know that the table is no longer used. Or if we need to identify which process is using a particular table in the database, it would be easier to do than reviewing each process/form's lookups that is now displayed to find if the table is used there.

 

6 0

Replies

replied on June 17, 2024

It would also be great if when configuring the data source you could choose which tables, views, or stored procedures should be used with the data source. Some data sources are quite large and giving end users too many options can be confusing for them.

1 0
replied on June 16, 2024

Hi Craig,

Thanks for sharing this idea, but let's wait to see if more votes on this feature then consider working on it.

0 0
replied on January 6

The ability to identify all form processes using a specific table would have helped me in identifying all processes that need to updated before migrating a table to another DB.

Even if there was a way to query Forms DBs to get this information, it would be helpful.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.