Choose your top Archicad wishes!

Read more
Wishes
Post your wishes about Graphisoft products: Archicad, BIMx, BIMcloud, and DDScad.
SOLVED!

Property expression IFNA (or similar)

Bruce
Expert

There needs to be an expression that tests for a non-existent property.  Excel's formulas IFNA, or IFERROR are along the lines of what I'm thinking.

 

An example would be when you have several properties that are for independent information (wall type, fire rating, acoustic rating, etc), that then concatenate in yet another property for a completed code.  If one of the properties is missing because it isn't included in the element's classification, the result is #propertyName.  There needs to be a way to error handle this.

 

E.g. CONCAT(IFNA(Property 1, ""), " | ", IFNA(Property 2, ""))

Bruce Walker
www.brucepwalker.com
Barking Dog BIM YouTube
Mindmeister Mindmap
-- since v8.1 --
AC27 5003 INT Full | Windows 11 64 Pro | 12th Gen Intel i7-12700H 2.30 GHz | 64 Gb RAM | NVIDIA GeForce RTX 3060 32 Gb
1 ACCEPTED SOLUTION

Accepted Solutions
Solution
Bruce
Expert

Wish submitted.

 

https://community.graphisoft.com/t5/Wishes-forum/Property-expression-IFNA-or-similar/td-p/370335

Bruce Walker
www.brucepwalker.com
Barking Dog BIM YouTube
Mindmeister Mindmap
-- since v8.1 --
AC27 5003 INT Full | Windows 11 64 Pro | 12th Gen Intel i7-12700H 2.30 GHz | 64 Gb RAM | NVIDIA GeForce RTX 3060 32 Gb

View solution in original post

3 REPLIES 3

I’ve kind of done a workaround to this. Where we have created our own properties which are based on an option set I have set one of the options to be ‘Select’ which should never be the option used. I then have an expression that says if that property is defined as ‘Select’ then display ‘ERROR’ in the label. 

Lee Hankins
ArchiCAD 4.5 - Archicad 27UKI Apple Silicon 27.2.0
macOS Sonoma (14.4.1)
Bruce
Expert

Thanks Lee, but not quite the same thing.  If Property 1 doesn't exist in the element's classification, then it won't report anything to the enquiring Property.  

Bruce Walker
www.brucepwalker.com
Barking Dog BIM YouTube
Mindmeister Mindmap
-- since v8.1 --
AC27 5003 INT Full | Windows 11 64 Pro | 12th Gen Intel i7-12700H 2.30 GHz | 64 Gb RAM | NVIDIA GeForce RTX 3060 32 Gb
Solution
Bruce
Expert

Wish submitted.

 

https://community.graphisoft.com/t5/Wishes-forum/Property-expression-IFNA-or-similar/td-p/370335

Bruce Walker
www.brucepwalker.com
Barking Dog BIM YouTube
Mindmeister Mindmap
-- since v8.1 --
AC27 5003 INT Full | Windows 11 64 Pro | 12th Gen Intel i7-12700H 2.30 GHz | 64 Gb RAM | NVIDIA GeForce RTX 3060 32 Gb