Custom Formulas

[tmwarchitecture]

No description provided.

[visualizor]

is this something that can be implemented for 2.0 release?

[tmwarchitecture]

Seem like a lot of work, but here's my thought. Its a column that displays the value from a user input expression. This could then, for example, allow people to do =Area * 300 to see a cost factor, where Area is a keyword linked to the area column. Or =(Area) / 200 to display an estimate for car parking. Or =Length/(numPts-1) if you wanted to see the average length of a polyline segment. Or =Volume*2315 to get the mass of an object. Or maybe you are 3d printing and want to know the cost of your object =Volume/23.21.

For now the function could just return floating point values, but if booleans were returned and logic was introduced as keywords you could have something like =if(Area>400, True, False)

The hardest part is creating this user entered language that can be parsed into a mathematical formula. It has to be something like the eval() or exec() function in python. But is stored as a function with variables.

There would be a new property (column) in Tabl_ called something like "Custom Formula". Would be great to have as many as the user wants, but then the GUI would have to dynamically adjust (seems tricky?), so I think just one Custom Formula would make sense for now. This column displays the value output of the user entered expression.

There needs to be a new dialog that is activated either through the context menu, or settings that has a textbox input where the user enters the expressions (see revit image below). If the column header could also be changed so it can display a custom name, that would be a bonus (example: "Cost" or "Weight")