Jump to content

get list of Object_Info_Data Names into worksheet


Recommended Posts

Hi all

I have a series of objects where I'm entering plant species codes (e.g.ULance_CopBru.Meu) into Object_Info_Data and then doing calculations in a worksheet - =Area etc. 

How do I extract the Name from e.g.  =Area(N='ULance_CopBru.Meu') and print it to the same line in the worksheet?

 

 

 

 

 

Link to comment

Since you are using the Name field, that means that species can only be in the drawing once as each object must either have no name or a unique name.

 

Better to add a custom Record/Field combination and use that for the name, then you can get a total of the area of all the different plants with the same species. You probably also want to read up on database rows.

 

If you want to continue with what you are doing, do it the other way around. Rather than type the name into the =area function, type the name directly into the cell where you want the name (Maybe A1) then set the area formula to =Area(N=A1)

 

Ask again if I misunderstood your question.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...