Details about this thread
  • State Not Answered
  • Replies 7 replies
  • Subscribers 314 subscribers
  • Views 11457 views
  • Users 0 members are here
Related content from around SugarClub

Dependent & Required Fields

Annie Kielian

I have over 200 fields which may or may not be in my layout.
Some of them may be required.

I am having trouble saving out of a record because i'm missing a required field, however, i'm not sure which one it is (because it must not be placed in that particular dropdown based layout)

How can i quickly/at a glance/ look at all of my fields and see which ones are required (without going into them 1x1)

Parents
  • 0

    Hi Annie,

    If the required fields are custom fields (added after the first creation of the module) then you can do a custom query in the Advanced Reports

    Here is an example of the SQL you could run, just change the module name below.
    select * from fields_meta_data where custom_module = 'Accounts' and Required = 1


    Having said that, in my experience, if a field is not displayed in a layout, it should not block you from saving even if it has been checked required in Studio.

    Muriel

Reply
  • 0

    Hi Annie,

    If the required fields are custom fields (added after the first creation of the module) then you can do a custom query in the Advanced Reports

    Here is an example of the SQL you could run, just change the module name below.
    select * from fields_meta_data where custom_module = 'Accounts' and Required = 1


    Having said that, in my experience, if a field is not displayed in a layout, it should not block you from saving even if it has been checked required in Studio.

    Muriel

Children
No Data