I had a question about using the Expression Builder for Item types. I have my excel set up and the Item types but when I go to use the expression builder it gives me a choice for everything except the one I am currently trying to make an expression for. I added some pictures to show how my expression builder looks and the excel for reference. If anyone could help with how my expression should be set up that would be great!
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
Justin Guiliano, PE
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 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.