Skip to main content

Attachment field with multiples images. Formula?

  • August 27, 2022
  • 3 replies
  • 46 views

Scott_Gardner1
Forum|alt.badge.img+15

Hello-

Looking for a solution please, I need a formula or a zapier suggestion - for if I have a attachment field with 4 versions of a design, and I want to auto send the last version added say version 4 to a new field that only show the latest revision - possible?

Thank you!

3 replies

Alexey_Gusev
Forum|alt.badge.img+25

Hi,

-not very precise but no-code
you can create such formula and then, when trigger clicks, put that value into new attachment field (by automation).

IF(Attachments,SUBSTITUTE(
  RIGHT(''&Attachments,1+
  LEN(''&Attachments)-FIND('https:',''&Attachments,LEN(''&Attachments)-133)
),')',''
))

try do increase 133 if some docs not fit, or decrease if 2 fits instead of 1


Scott_Gardner1
Forum|alt.badge.img+15
  • Author
  • Known Participant
  • August 27, 2022

Hi,

-not very precise but no-code
you can create such formula and then, when trigger clicks, put that value into new attachment field (by automation).

IF(Attachments,SUBSTITUTE(
  RIGHT(''&Attachments,1+
  LEN(''&Attachments)-FIND('https:',''&Attachments,LEN(''&Attachments)-133)
),')',''
))

try do increase 133 if some docs not fit, or decrease if 2 fits instead of 1


This is great, thank you - any idea on how that automation works to get that link sent to the attachment field to create the same PDF?


Alexey_Gusev
Forum|alt.badge.img+25

This is great, thank you - any idea on how that automation works to get that link sent to the attachment field to create the same PDF?


Very simple, just put it there :slightly_smiling_face: