8 Kudos

Formulas for UDP's

Status: Accepted
by *Expert Elite* | International Moderator on ‎06-20-2012 12:09 AM

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

Status: Accepted
MiWaNiZa, Can you provide some examples of formulas you would need and what you would use them for?
by Board Manager ihayesjr on ‎07-05-2012 11:55 AM
Status changed to: Accepted
MiWaNiZa, Can you provide some examples of formulas you would need and what you would use them for?
by *Expert Elite* | International Moderator ‎07-10-2012 03:30 AM - edited ‎07-10-2012 03:36 AM

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.

MS Access 2010 Expression Builder

by Valued Contributor tmoney2007 on ‎04-19-2013 09:00 AM

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

by *Expert Elite* | International Moderator on ‎04-19-2013 09:06 AM


Or like a 

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


You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

IdeaStation Guidelines
Review guidelines and best practices
before posting a new idea
Top Kudoed Authors
User Kudos Count