Start expressions with condition

AppSheet AppSheet Q&A
,
1

Hello everyone,
I wonder if it is possible to add a condition to the expression below. if the FRENCH NAME is not written in the product table I don’t want an expression that came with a blank row, is it possible to pull the PRODUCT NAME on condition?

<START:RELATED_ORDERS>
<>
<>
<<[PRODUCT CODE]>>
<<[PRODUCTCODE].[FRENCH NAME]>> “if FRENCH NAME is blank” than add PRODUCT NAME"
<<[QTY]>>
<>

Thanks in advance

2

Please try

<START:RELATED_ORDERS>
<>
<>
<<[PRODUCT CODE]>>
<<IF(ISBLANK([PRODUCTCODE].[FRENCH NAME]), [Product Name], [PRODUCTCODE].[FRENCH NAME]) >>
<<[QTY]>>
<>

4 Likes