Merge command: [strsidekick-imgfilepresent ]
Merge variable/item: strSidekickImgFilePresent
Comments:
This variable contains the value 1 if a valid attachment is present on the (notes)document that corresponds with the filename as stored in `sidekickFilePath` item
Formula:
strSidekickSourcefield:=@ReplaceSubstring(sidekickFilePath;"/";"\\"); strSidekickSourcefile:=@If(@RightBack(strSidekickSourcefield;"\\")="" & strSidekickSourcefield!="";strSidekickSourcefield;@RightBack(strSidekickSourcefield;"\\")); strSidekickImgFilePresent:=@If(strSidekickSourcefile!="" & @IsMember(strSidekickSourcefile;@AttachmentNames);"1";"");
Example:
1 or ""
Merge variable/item: strSidekickImgFilePresent
Comments:
This variable contains the value 1 if a valid attachment is present on the (notes)document that corresponds with the filename as stored in `sidekickFilePath` item
Formula:
strSidekickSourcefield:=@ReplaceSubstring(sidekickFilePath;"/";"\\"); strSidekickSourcefile:=@If(@RightBack(strSidekickSourcefield;"\\")="" & strSidekickSourcefield!="";strSidekickSourcefield;@RightBack(strSidekickSourcefield;"\\")); strSidekickImgFilePresent:=@If(strSidekickSourcefile!="" & @IsMember(strSidekickSourcefile;@AttachmentNames);"1";"");
Example:
1 or ""