x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 260 views
  • Users 0 members are here
Browse Forums
Announcements
106
topics
32
replies
General Discussion
6k
topics
18k
replies
Stephane2

Multi-Select Field Type

Posted By

Hi.

I have a multi-select field type. It is called Business Type within the Company Table.

I notice that when I queried the table that the Business Type Field had values instead of the selection name that appears in CRM.

Example: 42, instead of Grower/Packer/Shipper/Marketer

I get that 42 = Grower/Packer/Shipper/Marketer

My question: In what table is the translation (selection) of the value from this multi-select field reside in?

See Screenshot.

Thanks,

Stephane

  • 0

    Stephane

    A field that is a multi-select is described in the custom_edits tables as being of colp_entrytype '28'.

    The values that are possible for the multi-select as described in the custom_captions table.

    Each option would be a separate entry

    Capt_family = "comp_businesstype" (The name of the field)

    Capt_familytype = "Choices"

    Capt_Code = "A" (This is a string so could be anything e.g. 42)

    Capt_US = "Translation 1" (Appropriate prompt for the user)

    Capt_family = "comp_businesstype"

    Capt_familytype = "Choices"

    Capt_Code = "B"

    Capt_US = "Translation 2"

  • 0

    Perfect - I always wanted to know the answer to this question.

    Thanks again.

    Stephane

*Community Hub is the new name for Sage City