Open roads Expression Builder

Hi Richard - just to verify the FMS value does not appear in the scroll list (left image) on the right hand side of the expression dialog? Have you tried copying the expression text shown and pasting in the FMS item type and replacing "County" with "FMS" as a manual edit?

Would you mind sharing the excel sheet so I could recreate on my end?

Thanks,

Justin

I tried to manual edit like you are saying and it just gives me an error in the expression and it says "A CalculatedECPropertySpecification with ECExpression of "LookUp.GetEntry("Project Information","Variable",this["FMS"])["Value"]" cannot be applied to the ECProperty "FMS" because it is dependent on that ECProperty". Here is the Excel sheet.

Project Information.xlsx

I put the File in our workset to be copied for every project but the sheets provided for us through our DOT have Item types that can be changed so every project I was hoping to set up this excel so each sheet that has a FMS,Detail,Date,etc. can all be changed according to the project that is being worked on. Sort of the way they change it through projectwise.

I had to get a little creative with this since the lookup tool is matching the IT property name with the lookup value. The way it is now, FMS is not defined, so there is no value to match in the spreadsheet. Ultimately, I created an item type for FMS and an item type for the FMS lookup. The lookup value is a hidden IT in the property and the FMS is the return value for it.

FMS:

FMS Lookup:

Properties and Returned FMS Code:

Lookup Spreadsheet:

I also cleared out all the extra data shown in your spreadsheet so it only has the info shown in the screenshot.

HTH,
Justin

I had to get a little creative with this since the lookup tool is matching the IT property name with the lookup value. The way it is now, FMS is not defined, so there is no value to match in the spreadsheet. Ultimately, I created an item type for FMS and an item type for the FMS lookup. The lookup value is a hidden IT in the property and the FMS is the return value for it.

FMS:

FMS Lookup:

Properties and Returned FMS Code:

Lookup Spreadsheet:

I also cleared out all the extra data shown in your spreadsheet so it only has the info shown in the screenshot.

HTH,
Justin

I can link these item types to a certain text on our sheets correct? So it shows up every time that text is showing for our borders.

You would want to create text favorites for the fields they represent.

You would want to make sure that an element in your border file has the item type attached. For example, attach the item type to a construction line in the border file.

There may be other ways to get this information into your border through WorkSet properties & sheet index properties which may be easier to apply.

I tried all of the stuff you said to do and when I opened a new file to test it all of the Item Types were set the way I want but when I created a title sheet the item types went right back to the way they were set up before. I am trying to figure out where it is pulling the default Item types.

Also when I updated the item types they finally showed up but there were no numbers or anything filled in even though I have the expression set up the way you said, they showed up as "N/A" which is the Failure Value. Is there a certain location in our workset that the excel file should be placed?

Hi Richard,

There is a Microstation defect that is present in ORD where text fields based on Item Types will not update unless Explorer is open at session start (its ridiculous, i know). Could that be causing your update issues?

I have my preferences set up to where the explorer always on the left side of my screen so I don't believe that would be the issue.