IF formula question

[Scott_Gardner1]

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!

[Alexey_Gusev]

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)