Using Custom Property Lists
When you have a shape with a Custom Property/Shape Data List you may want to refer to it from within the shapesheet or an associated shapesheet. The first inclination would be to do a string comparison within the test. My preference is to create a User cell that uses Lookup to convert the text into a numeric value. So for a list named Relation, the Shape Data row would be:Name: Prop.RelationType: 1Format: “Hostile;Close;Distant” Value: =INDEX(1,Prop.Relation.Format) So what would be in the Value of the User Property cell User.Relation_nbr? The LOOKUP function would need the string to search for (which is … Continue reading Using Custom Property Lists