Associate IDs

Back to index page

This ribbon button is very useful if you have a list of IDs in a column on the sheet and you want to convert to structures stored in a database.

 

1. Create a list of IDs, which should be equal with the ones in a database column.

 

Cell.AssociateIDs

 

2. Select the list of IDs. The IDs can be selected continuously or by cherry-picking as well.

3. Press Associate IDs button. Structures belonging to selected IDs will be imported to the sheet as a JCIDSYSStructure function, which provides the opportunity to flip-flop between structures and IDs by pressing Structures or IDs button in ribbon.

 

Cell.AssociateIDs_result


Back to index page