Jump to content
Sign in to follow this  
VWLP

Multiple descriptions in the same database column

Recommended Posts

I am having difficulty finding the right formula to allow multiple record descriptions in the same column. For example, I set the criteria of the first row to show all items with Record A and Record B. In column A I would like to show the item description. I was able to show the description for Record A by using the formula ='Record A'.'description' . However, I would also like to include the description for record B in the same column. How should I modify this?

I also have a bonus question of a function that probably is not possible, but it's worth a shot to ask. Is it possible to set items of a certain record to automatically show up in a different font color in the database?

Thank you.

Share this post


Link to post

It's not clear from your question: Do some objects have A and some have B or do they have both?

See the attached example. I think it answers your question.

Bonus answer: No.

hth

mk

Share this post


Link to post

Michael, thank you for your response. To clarify my example, objects will have either A or B records, but not both.

I am using VW2011 and for some reason was unable to open the attached file. If it's not too much trouble, would it be possible to take a screenshot or paste the example formula?

Share this post


Link to post

Separate Records are going to make it challenging as you will have to define a criteria set that gets all of the objects that you need in the schedule.

As long as none of them have both records, you should be able to do something like:

=('Record A'.'description' | 'Record B'.'description')

where the vertical bar acts as a logical "OR"

Share this post


Link to post

Thank you, Pat. Your formula makes sense, but it is not working for me in practice. I followed it exactly and am getting the #VALUE! error.

I'm attaching an example in case anyone can figure out what is wrong.

Thanks, Lindsay

Share this post


Link to post

Thanks Michael, your example completely helped! I was able to use your formulas to work in my own database. Thanks to both of you for the assistance.

Share this post


Link to post

Glad to help.

It's helpful to put your VW version and computer OS in your signature. It's under My Stuff > Edit Profile at the top of this page.

mk

Share this post


Link to post

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.

Sign in to follow this  

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...