0
Is it possible to add a condition at the beginning of the table?
![](https://s3-us-west-2.amazonaws.com/media.forumbee.com/i/8c789bf9-07de-4cc8-848f-ae880e6dbd49/h/547.png)
I am using concat here to display the data from (invoiceitems.‘1 or 2’). Is it possible to use conditional statements in the code, for example: if it returns 1, then display 0; otherwise, keep it unchanged. If it previously returned 1, 2, 1, 2, then it should now return 0, 2, 0, 2.
6 replies
-
It would be easier to write a new formula field in the invoiceitems table that does checking. Then you can just reference the new field in your column.
Content aside
- Status Answered
- 1 mth agoLast active
- 6Replies
- 49Views
-
2
Following