- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2023 10:49 AM
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2023 01:09 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 30, 2023 06:00 PM
Move your line breaks inside the appropriate IF() function instead of between your IF() functions, as I explain here.
You do not have a line break after every field, so you might need to add some logic that looks at multiple fields to determine if there should be a line break:
IF(
OR({field1}, {field2}, {field3}),
"\n"
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 01, 2023 12:02 PM
It's not script, it's a formula ))
You need to finish IF( ) after the line break, not after the field name, as it is now
To save time, you can open Notepad, paste it there and
press 'Replace all"
The result is (I don't want to create all these fields to test):
{MARQUES} &
IF({DESIGNER}, " X " & {DESIGNER}) &
IF({DATATION}, " - " & {DATATION} & "\n") &
IF({COLLECTION}, " " & {COLLECTION} & "\n") &
IF({FABRICATION}, " " & {FABRICATION} & "\n") &
IF({PRODUIT}, " " & {PRODUIT}) &
IF({MODELE}, " - " & {MODELE} & "\n") &
IF({MATIERES}, " " & {MATIERES} & "\n") &
IF({COULEURS}, " " & {COULEURS} & "\n") &
IF({DETAIL}, " " & {DETAIL}) &
IF({GRIFFES}, " , " & {GRIFFES} & "\n") &
IF({PROVENANCE}, " " & {PROVENANCE} & "\n") &
IF({TAILLES}, " " & {TAILLES} & "\n") &
IF({CONDITION REPORT}, " " & {CONDITION REPORT} & "\n" &
IF({ICONOGRAPHIES}, " " & {ICONOGRAPHIES})
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 02, 2023 01:09 AM
Thanks so much, it is working fine this way.
