• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 16 replies
  • Answers 1 answer
  • Subscribers 121 subscribers
  • Views 4546 views
  • Users 0 members are here

Item Type Lookup with Arrays

Luke Arnold
Offline

I would like to use Item Types as a way to calculate quantities for transportation projects. I am using an "ItemNumber" field to lookup the item description as well as other information about the pay item. from a spreadsheet located in the workspace.

There are many instances when the same microstation element may have multiple pay items. For instance, a manhole we would pay for the manhole and the cover separately. I can make a property type called "Pay item" and use this to create an array of pay items on the microstation element. However, when I do this the lookup functionality fails. Anybody else try to do something like this with any success?

-Luke

Parents
  • 0 Offline

    Hi Luke,

    Expression does not support array property type. Can you please explain your use case with examples how will you like value should appear for your array property?

    Thanks,

    Mangesh


    This is a test

  • 0 Offline in reply to Mangesh.Shelar

    Hi Mangesh,

    I would like to create a property type called "Pay Item". This property type will have properties of item code, item description, and units of measure. Using ItemCode, I would like to look up item description and units of measure from a spreadsheet.

    In our industry, multiple pay items can be represented by the same microstation element. For example, a manhole is a microstation cell, but the contractor will get paid for installing the manhole and installing the manhole cover separately. So I would like to assign an array of pay items where each unique ItemCode within the array will look up the subsequent item description and units of measure.

    Thanks for following up on this!

    Luke

Reply
  • 0 Offline in reply to Mangesh.Shelar

    Hi Mangesh,

    I would like to create a property type called "Pay Item". This property type will have properties of item code, item description, and units of measure. Using ItemCode, I would like to look up item description and units of measure from a spreadsheet.

    In our industry, multiple pay items can be represented by the same microstation element. For example, a manhole is a microstation cell, but the contractor will get paid for installing the manhole and installing the manhole cover separately. So I would like to assign an array of pay items where each unique ItemCode within the array will look up the subsequent item description and units of measure.

    Thanks for following up on this!

    Luke

Children
Communities
Support and Services
Training and Learning
Social Media