Formulas for UDP's

[MiWaNiZa]

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...

[ihayesjr]

MiWaNiZa, Can you provide some examples of formulas you would need and what you would use them for?

[MiWaNiZa]

It's nested to create formulas that can operate with strings, logical conditions/statements, get properties of specific objects, make requests to search last.

Some examples: 

' ====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.

[tmoney2007]

It could be as simple as <Property6>="<Property1>, <Property2>,<Property3>,<Property4>,<Property5>"

[MiWaNiZa]

Right.

Or like a 

---

<Property6>="<Property1> <Property2> diameter <Property3>, standard # <Property4> mfg. by <Property5>"

---