Why not to create formulas for UDP's? Even very-very simple just for text processing and calculation on-request.
Guys, Vault's running on SQL - como Dios manda...
It's nested to create formulas that can operate with strings, logical conditions/statements, get properties of specific objects, make requests to search last.
' ====For whole Vault====
= Iif(This.CategoryName!="Drawing"; True; False) ' Set value, depending on object property
= This.ParentFolder.GetProperty("Constructor") ' Set value for file in folder, not using "AutoProperties" extension from apps.exchange.autodesk.com
' ====For specific object====
= GetProperty("$/Designs/AA-1180", CustomProperty("Project Name")) ' Get UDP "Project Name" from folder "$/Designs/AA-1180"
= GetProperty("$/Designs/AA-1122", CustomProperty("Project Start Date")) + Date.Days(183) ' Set deadline
= Math.Average(This.Children.Property("% ready") ' Calculate ready state, based on children state
= This.ParentFolder.Name + ".000.iam" ' Append text to string
= CustomObject("Designer").Item(This.CustomProperty("Responsible")).GetProperty("Phone") ' Get UDP "Phone" from custom object "Designer". Name recieved from object's property "Responsible"
= This.Parent.Name + ".000 " + Vault.This.LookupTable("Responsible").Item(1) ' Append text and value from lookup table
Ideally it's looks similar to Expression builder in MS Access, or others builders.
It could be as simple as <Property6>="<Property1>, <Property2>,<Property3>,<Property4>,<Property5>"
Or like a
<Property6>="<Property1> <Property2> diameter <Property3>, standard # <Property4> mfg. by <Property5>"
You must be a registered user to add a comment here. If you've already registered, please log in. If you haven't registered yet, please register and log in.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register
Upgrading to a 2015 product? Make sure to check these out 1st!