Thank you @Sven-iX I couldn't achieve the thumbnail using your expression as it looks as if there's an abrupt ending on line 4 BUT with some working out, I did get a thumbnail to appear. {DE:IC - docID+versionID} being my text field. valueexpression=if(isblank({DE:IC - docID+versionID}),'','<img src...

...worked it out... IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <=12 && YEAR({DE:Event Start Date}) =2022or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <=9 && YEAR({DE:Event Start Date}) =2023),"FY23",IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Ev...

Hi all, I'm trying to work out this expression to display a value (FY25) if a date in a picker is between Oct 1 (24) - Sept 31 (25) Works when I use the first part > than:IF(({DE:Event Start Date}) >= 01/10/2024, IF(({DE:Event Start Date}) <= 30/09/25, "FY25", "-")) But not when I add the second sec...

Sure, you could try:IF(LEN({name}) <40, "Good!", "Too Many!") '<40' being the character limit although you may want to play around with this as 41 may be the number you need to return the desired result.

@stan255  I needed something similar recently but had to just fall back on the LEN({value}) expression in another field which gave the user an idea of how many characters they were using.Not really a fix but guided the requester. Andy

Hey all, Not really a question but in response to a lot of posts re. REPLACE() not working as expected, thought I'd share this:REPLACE({value}," ", "\u200B") \u200B removes character spaces in {value} Thanks to @Doug_Den_Hoed__AtAppStore for the steer Hope this helps! Andy

@Doug_Den_Hoed__AtAppStore @RobertDy CONCAT({project}.{DE:Fiscal Year for DAM},"_",{project}.{DE:Product},"_",{project}.{DE:IC - Market},"_",{project}.{DE:Segment},"_",{DE:IC - Asset Type},"_",{DE:Funnel},"_",REPLACE({name}," ", "\u200B"), "_",{project}.{DE:Prospective customer industry/vertical},"_...

Hey DougSimilar issue, I have the following calculation to create a string but I need to remove the character spaces in {name}CONCAT({project}.{DE:Fiscal Year for DAM},"_",{project}.{DE:Product},"_", {project}.{DE:IC - Market},"_",{project}.{DE:Segment},"_",{DE:IC - Asset Type},"_",{DE:Funnel},"_",R...

Thanks Rich.

Hi all, Can't seem to get this calculated field to display correctly, I need to replace the {submittedByID} with the name of user submitting the request. As {submittedByName} doesn't appear to be a native field. REPLACE({submittedByID}, {submittedByID}, {name}) Feels as if I'm missing something real...