
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 07, 2022 08:41 PM
Hi everyone, I’m trying to set a field value based on a formula :
IF(
OR(
{Commandes} = BLANK(),
{Date_heure_RDV} = BLANK()),
"", CONCATENATE({Commandes} , " - ", DATETIME_FORMAT(Date_heure_RDV, 'M/DD/YYYY H:mm')),
IF(
OR(
{SILGAN BOL} = BLANK(),
{Date_heure_RDV} = BLANK()),
"", CONCATENATE({SILGAN BOL} , " - ", DATETIME_FORMAT(Date_heure_RDV, 'M/DD/YYYY H:mm'))
)
)
But when saving the formula… it just keep the first part. Is it possible to do this kind of nesting?
Thanks for your help
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2022 07:44 AM
Hey @Sebastien_LEBLANC!
Here’s my version of your formula:
IF(
AND(
{Date_heure_RDV},
OR(
{Commandes},
{SILGAN BOL}
)
),
IF(
AND(
{Commandes},
{SILGAN BOL}
),
{Commandes} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
)
& '\n' &
{SILGAN BOL} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
),
IF(
{Commandes},
{Commandes} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
),
IF(
{SILGAN BOL},
{SILGAN BOL} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
)
)
)
)
)
This formula produces the following results:
Let me know if I’m misunderstanding something about the formula, or if you want to tweak something about it’s behavior.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2022 05:20 AM
Hi Sebastien,
Yes, it’s possible to nest, but a bit differently.
You can write the formula like this: IF(CONDITION1,OPTION1,IF(CONDITION2,OPTION2,OPTION3))
Maybe in javascript it makes more sense…
if (CONDITION1) { OPTION1 } else if (CONDITION2) { OPTION2 } else { OPTION 3 }
With this nested technique you only have 3 options. In your case you have twice “” (or Blank()) as option, so you could set “” as option 3 (in my shema), change your conditions a bit around and it should work.
Hope this helps!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2022 07:44 AM
Hey @Sebastien_LEBLANC!
Here’s my version of your formula:
IF(
AND(
{Date_heure_RDV},
OR(
{Commandes},
{SILGAN BOL}
)
),
IF(
AND(
{Commandes},
{SILGAN BOL}
),
{Commandes} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
)
& '\n' &
{SILGAN BOL} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
),
IF(
{Commandes},
{Commandes} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
),
IF(
{SILGAN BOL},
{SILGAN BOL} & " - " &
DATETIME_FORMAT(
{Date_heure_RDV},
'M/DD/YYYY H:mm'
)
)
)
)
)
This formula produces the following results:
Let me know if I’m misunderstanding something about the formula, or if you want to tweak something about it’s behavior.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 08, 2022 12:33 PM
@Ben.Young : You have indeed gave me the right solution… but I’m not sure I can grasp how you came to it. Anyway thanks a lot, I’ll look more into it so I could “reboot” my logic and old programmer mindset… I’ve done this for almost 20 years… but it’s been almost 10 years since I left the trade… I’m rust :thinking:
@Marielle_Gueissaz1 : Thanks for your input, I’ll “mix it” with Ben.Young solution and try to better understand why I couldn’t came with a working solution all by my self.
