I only want to know which fields have content in a group

Custom Fields are fields that are created in EasyCatalog that are not present in the source data. Their content is created using one of our in-built functions, in a similar way to using functions in Excel. So, for example, it’s possible to create a custom field that summarises data from a collection of records. Custom fields are created by right-clicking in the panel and using the ‘New Custom Field’ menu option.”

There’s a custom field function that, given a list of fields, will return the name of the n’th populated field. This function is required as we don’t know which of the fields in the data will actually contain content. We’re assuming that there will be a maximum of, say, six fields populated so we create six custom fields – e.g.

Field Name: Column 1 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,0,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

Field Name: Column 2 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,1,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

Field Name: Column 3 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,2,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

Field Name: Column 4 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,3,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

Field Name: Column 5 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,4,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

Field Name: Column 6 Name
Function: GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,5,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

The function has two fixed parameters followed by a list of field names:

GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’,0,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

The first parameter defines the grouping in the panel, so this ensures we only look at the populated fields in the Range ID:Sub-Range ID:Product Group ID grouping.

GROUPGETNTHPOPULATEDFIELDNAME(‘Range ID:Sub-Range ID:Product Group ID’, 0,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

The second parameter defines the nโ€™th populated field that we want to retrieve (starting at zero), so youโ€™ll notice that each of the custom fields supplies a different value for this parameter.

The remainder of the command is just a list of fields that we want to check.

So, we now have a list of (up to) six field names that contain populated data for each Product Group group. We now need the same number of custom fields to actually get the field values from these fields. This is achieved using the following custom fields:

Field Name: Column 1 Value
Function: FIELDSTR(FIELDSTR(Column 1 Name))

Field Name: Column 2 Value
Function: FIELDSTR(FIELDSTR(Column 2 Name))

Field Name: Column 3 Value
Function: FIELDSTR(FIELDSTR(Column 3 Name))

Field Name: Column 4 Value
Function: FIELDSTR(FIELDSTR(Column 4 Name))

Field Name: Column 5 Value
Function: FIELDSTR(FIELDSTR(Column 5 Name))

Field Name: Column 6 Value”
Function: FIELDSTR(FIELDSTR(Column 6 Name))

The FIELDSTR() function just retrieves the contents from a named field, so in this case itโ€™s getting the contents of the field named in the contents of the โ€œColumn 1 Nameโ€,โ€ Column 2 Nameโ€,etc fields.”