Custom Fields

Discussions related to integration with SoftPro Standard or SoftPro Enterprise editions.
Post Reply
enendza
Posts: 67
Joined: Wed Oct 16, 2019 12:22 pm

Custom Fields

Post by enendza » Mon Aug 03, 2020 2:51 pm

Hi -

When I look in our DB we have 7,000 ++ custom fields. Out of that 7,000 we have 1,044 that are NOT HIDDEN.

Are there any known concerns with making all the custom fields that we don't THINK are being used as HIDDEN?
Is there a SQL Statement that I can use to determine when and if the custom field has ever been used and we have data associated with it on some order? (custom fields date back to 2015)

Looking to reuse the custom fields that we already have in place but want to better understand the current usage of the fields. I don't want to change the name.

Any advice or articles would be much appreciated.

Thanks

Emma

Gil McNeill
Posts: 15
Joined: Mon Oct 06, 2008 9:29 am

Re: Custom Fields

Post by Gil McNeill » Mon Aug 03, 2020 3:22 pm

Hi Emma. I think you may have posted this in the wrong forum. This is the forum for the Classic product, and I think you are referring to the Select product. Can you report your question over in the section entitled "Custom Order Rules"
Gil McNeill
SoftPro Software Engineer

Post Reply