nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

A phrase in a Column to a marker

rshehadah

Hi,

I have a col with different type of annotations. I was wondering how can I create a script to change the markers for the speficic pharse.

For example, If i have the color red, I want the marker to be a circle, if I have the color blue I want it to be a sqaure and so on.

Thank you,

Rami

Accepted answers

txnelson

Here is a modification using the Combine States() function that reads the Hidden and Excluded row states and then reapplies them along with the Marker State to the row.

Names Default To Here( 1 );
dt = Current Data Table();
For( i = 1, i <= N Rows( dt ), i++,
	If(
		dt:AnnotateColumn[i] == "red",
			Row State( i ) = Combine States(
				Marker State( 8 ),
				Excluded State( Excluded( Row State( i ) ) ),
				Hidden State( Hidden( Row State( i ) ) )
			),
		dt:AnnotateColumn[i] == "blue",
			Row State( i ) = Combine States(
				Marker State( 3 ),
				Excluded State( Excluded( Row State( i ) ) ),
				Hidden State( Hidden( Row State( i ) ) )
			)
	)
);

All comments

txnelson

Here is a simple script that reads information from your column that has the annotations, I refer to it as "AnnotateColumn", and changes the marker based upon the value in the annotate column.

Names Default To Here( 1 );
dt = Current Data Table();
For( i = 1, i <= N Rows( dt ), i++,
	If(
		dt:AnnotateColumn[i] == "red",
			Row State( i ) = Marker State( 8 ),
		dt:AnnotateColumn[i] == "blue",
			Row State( i ) = Marker State( 3 )
	)
);<BR /><BR /><BR />

This is all documented in the Scripting Index

Help==>Scripting Index............search for "marker"

rshehadah

Thank you this works!

However is there a way that when I run the script it does not un hide/exlcude rows. Right now when I run it, the rows that I am hiding or exclduing are not excluded anymore.

Thank you,

Rami

txnelson

Here is a modification using the Combine States() function that reads the Hidden and Excluded row states and then reapplies them along with the Marker State to the row.

Names Default To Here( 1 );
dt = Current Data Table();
For( i = 1, i <= N Rows( dt ), i++,
	If(
		dt:AnnotateColumn[i] == "red",
			Row State( i ) = Combine States(
				Marker State( 8 ),
				Excluded State( Excluded( Row State( i ) ) ),
				Hidden State( Hidden( Row State( i ) ) )
			),
		dt:AnnotateColumn[i] == "blue",
			Row State( i ) = Combine States(
				Marker State( 3 ),
				Excluded State( Excluded( Row State( i ) ) ),
				Hidden State( Hidden( Row State( i ) ) )
			)
	)
);