Forum Discussion
EdjeVis
2 years agoNew Member
Set value in string variable in multiple steps
Hi, Could someone please help me on this. Been searching for hours on several platforms, but can't find any solution. Challenge: I want to put a text in my column "Reason", but this text is depend...
- 2 years ago
EdjeVis i'va also created a more modular and scalable code:
Reason =
VAR DescriptionTrimmed = TRIM([Description])
VAR DescriptionCheck = IF(LEN(DescriptionTrimmed) = 0, "Description is empty", "")VAR KindTrimmed = TRIM([Kind])
VAR KindCheck = IF(LEN(KindTrimmed) = 0, "Kind is empty", "")VAR TypeTrimmed = TRIM([Type])
VAR TypeCheck = IF(LEN(TypeTrimmed) = 0, "Type is empty", "")VAR AdditionalCheck1 = ""
VAR AdditionalCheck2 = ""
-- Add more check variables here as neededVAR Checks = {
DescriptionCheck,
KindCheck,
TypeCheck,
AdditionalCheck1,
AdditionalCheck2
-- Add more checks here
}VAR CombinedReason =
CONCATENATEX(
FILTER(Checks, [Value] <> ""),
[Value],
UNICHAR(10)
)RETURN
TRIM(CombinedReason)BBF
BeaBF
2 years agoSuper User
EdjeVis Hi!
Here the calculated column:
Reason =
VAR DescriptionTrimmed = TRIM([Description])
VAR DescriptionCheck = IF(LEN(DescriptionTrimmed) = 0, "Description is empty", "")
VAR KindTrimmed = TRIM([Kind])
VAR KindCheck = IF(LEN(KindTrimmed) = 0, "Kind is empty", "")
VAR CombinedReason =
DescriptionCheck &
IF(DescriptionCheck <> "" && KindCheck <> "", UNICHAR(10), "") &
KindCheck
RETURN
TRIM(CombinedReason)
BBF
BeaBF
2 years agoSuper User
Here the screen: