Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Sep 21, 2022 09:22 PM
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!
Sep 22, 2022 03:26 AM
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)