+15Hello:
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!
+25Hi,
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.