Skip to main content

Hello:


Question, The Formula link is not generating for Files (PDF, PNG, JPEG, MP4, Etc.) that are saved with an underscore _ in the file name.


IF({DESIGN: REVISIONS},SUBSTITUTE(

RIGHT(‘’&{DESIGN: REVISIONS},1+

LEN(‘’&{DESIGN: REVISIONS})-FIND(‘https:’,‘’&{DESIGN: REVISIONS},LEN(‘’&{DESIGN: REVISIONS})-133)

),‘)’,‘’

))


Is there anyway that we can fix this?


Thank you!

Hi,

check LEN(''&{DESIGN: REVISIONS}). maybe it’s less than 133 ?


also, always use this tag



for formulas and code, because otherwise quotes “chose the side” and formula won’t work after copy-pasting.


if the number 133 works for others, but for underscore it should be, 113 for example, you can substitute 133 with

133-20*(FIND('_',{fieldname})>0)


but maybe classic style even better - substitute 133 for IF(FIND('_',{fieldname}),113,133)


Reply