Adding a Group/Target List field to a screen

Less than one minute read time.
Within the marketing area an individual waveitem or wave activity can be linked to a Group. (The old terminology was Target List).

How can a Group field be added to another entity?

  • Add a new field called 'comp_targetlist' to the company table. Make sure it is of type 'Integer'.
  • Add the field to the companyboxlong
  • Open your Query Analyser or SQL query tool and then change the meta data by running
update custom_edits
set colp_entrytype = 60, colp_defaulttype= null, colp_entrysize=null
where colp_colname = 'comp_targetlist'

The Group field has to be of type '60'.
  • Refresh the metadata.
  • Navigate to a company summary page and test.