8.0/N - Text and Logic formulas! - O

[janunson]

(upgraded to a 9.0 wish)
In Calculated Values on tables and parameters in Families, i want to use formulas that include text and logic. If only the following 4 funcions were supported in formulas, a whole new world of cool options for smart schedules and objects would be opened up!

If(Condition, TrueValue, FalseValue) where the value can be a string
Left(String, Length)
Mid(String, Start, Length)
Right(String, Length)

[aaronrumple]

We need full VB scripting in all field and more of the datafields exposed. For example:
We have keynotes - the name of the type might be "09-01 GYPSUM BOARD" then we have a description- "GYPSUM BOARD", then a tag - "09-01" Of course someone will go in and change the number, name or title without changing the other field. Throws the whole system off. If I could script the fields off the main type name it would help keep things coordinated.

[janunson]

Another function - Field & "string value" & Field.

The other day i was helping someone with a project where they just could not get rooms to show up on the door schedule. The problem was the project has many, many different floor elevations, and so room names are not always associated with the level the door lives on. What i tried to do first was add a new field where they can just type a room name, rather than have to try to create room tags on every level of the project and then try to filter them out... This works fine, but it would be really nice to be able to clean up the table by making a 3rd column that takes the automatic room name column, the manual one, and appends the 2 together so that we can still have a room name column that works.

[dbaldacchino]

Yes yes yes we do need the ability to use strings and not just numbers in conditionals. I strongly agree. It would be really great if the formulas follow those in Excel.