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 know its been a few days but can I place this excel in each workset and it still work? I changed my configuration variable to look in the workset that I am currently in and go to that file location within the workset and when I test the expression builder it says it works but still isn't showing the value that I set. Is there a certain way to set up the configuration variable to do this?
Yes, make sure you have your ITEMTYPE_LOOKUP variable mapped to pull the excel sheet from your WorkSet location. You can have multiple instances of this variable, just make sure the appropriate operator is used in your CFGs.
2022R1 Item Type Test.dgn
5125.Project Information.xlsx
I believe I found the issue yesterday. I still had the extra information really far down on the excel. Thank you so much for all your help!