Help - a script to sort / reorder symbol names within a database worksheet please

[Flair-Studio]

Hi,

I am currently completing my custom electrical symbols library (UK based) have prepared all the symbols I need and assigned a custom record.

This time I want to use a workseet as legend, very simple with an image feature and the symbol description, eventually also the count.

 

How can I reorder the symbols within said workseet so that fused spurs are close to one another, same for switches, etc? Here is a screenshot of what achieved so far (still a lot to do).

Thank you

[MullinRJ]

Hello @Flair-Studio,

   If you are using a Worksheet as you say, in your worksheet column header for the SymbolName, do you have the Sort menu set to Ascending or Descending? If it is set to None you will get a random order. 

 

   To get to the Sort control, click on the little button at the right of the column header formula, as shown in the picture below. The dialog shown will appear.

 

 

   You can also use the Graphic Legend tool to do something similar with symbol names and images, but I don't know if you can format other information like you can in a Worksheet.

 

Raymond

 

[Tom W.]

I think you will need to rename your 'unswitched fused spur' symbol 'fused spur (unswitched)' in order for it to appear alongside the other fused spurs...

 

Or like Raymond says use a Graphic Legend as you can then reorder the cells manually if need be.

[Pat Stanford]

Or add an additional field in a record for each symbol to use as the Sort Order. If you don't want it to show you can set the column widths to zero after you have sorted by that column.

[Flair-Studio]

Pat you such a Star!

It came across my mind to add a field in the record for numbering purposes but, to give it zero width in the worksheet is the refinement I was looking for.

Thank you as always