Join without empty lines
Hi all,
I have a few fields (yes/no) to list all the papers that i might receive from people when they sign a contract. Let's say it's a list of ten different documents.
Some people deliver them all, others just a few of them.
I want to list those papers without having "empty lines" in the list. I used the join function in a formula field, but i get empty lines.
This is the formula i used:
and this is the result i get when i select just a few of them
Is there a way to achieve what i want?
10 replies
-
No need of the else then null, also not using the join function is easier.
Steven
-
Thank you so much RoSoft_Steven
seems like I’m good at making hard task out of easy things
-
Hi Gianluca
A different take would be
Where a is an array of all your lines of text and b is an array of all your yes/no fields.
Regards John
-
Hi,
I find myself in a similar situation. When I want to display different texts in a formula while separating each type of text with a "-", I use the join() function
The problem is that when I have empty fields, the join() function still adds the "-" which gives me several "-" in a row while I don't want to have any when an info is empty .
Formula :
Result :
Test - - - - Nouveau palier de parrainage - Envoyer plan d'hygiène vitale
In this example, lines 2, 5 and 6 give no text to display. The "-" are still added which poses a problem for me to read the result.
Is it possible to do something to avoid the extra "-"?
Content aside
- 1 yr agoFri, July 28, 2023 at 4:09 PM UTCLast active
- 10Replies
- 158Views
-
5
Following