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.