Zapier for Image Upload

[Andrew_Enright]

Hello, I’d love some help refining a Zap such that it:

Copies a text string from an Airtable formula field to an Airtable URL field, and THEN goes to that URL (which is a hard link to an image) and uploads the image file back into an Airtable attachment field.

The use-case here is barcoding. We have a formula that is dynamically generating image URLs to barcode images. The links work fine, but I don’t yet have a way of actually pulling and uploading the barcode images we’ve linked to.

Any/all help appreciated, THANX!

[Christopher_Rex]

It will be helpful if you can clarify how the text string is applied to Airtable. Is this added manually through UI or is it also added via Zapier or some other means?

[Andrew_Enright]

Column/Field 1, Formula, API: “http://www.barcodes4.me/barcode/c128b/” & {Job #}

Column/Field 2, Formula, Image URL: (“http://www.barcodes4.me/barcode/c128b/” & {Job #}) & “.jpg”

Column/Field 3, URL: Copied from Column/Field 2 via Zapier

Column/Field 4, Image Attachment: Image from Column/Field 3 URL to be uploaded via Zapier

---

The first three fields function fine, as does the Zap that supports Column/Field 3. What I need is the Zap to support Column/Field 4.

Hope that helps clarify; THANKS!

A.

[Christopher_Rex]

Andrew_Enright:

http://www.barcodes4.me/barcode

Actually, this works simply by loading the URL into your attachment field in Zapier. I tested this with their sample:

and the image displayed just fine. Does this solve your issue or are you looking for how to trigger this action in Zapier?

[Andrew_Enright]

Not sure what I’m missing, but I can’t get my zap to copy the URL string from the formula field into the attachment field.

And I can’t test via Airtable, as it does not allow you to paste an image URL into the attachment field…

[Christopher_Rex]

did you test your URL string in a web browser to make sure it downloads the
image?

[Andrew_Enright]

@Christopher_Rex Yes, and they resolve fine.

I did manage to get it working, after rebuilding the Zap. I suspect that the field name mapping got confused along the way, because I didn’t change anything, I simply replicated from scratch.

But regardless, THANK YOU for your help!

@airtable I look forward to a Image URL field type. Or even better, integrated barcode-generation. This would help greatly for anyone using a database to track inventory or discrete items (in our case, creative requests).

A.

[W_Vann_Hall]

Not necessarily your use case, but for anyone who comes across this discussion in the forum this may help, my Sales CRM Dashboard base in Airtable Universe fakes a pie chart by using Zapier to read a calculated win:loss ratio and, based on it, copying a pre-built pie chart image from an attachment field in one table to an attachment field in the [dashboard] table itself. Instructions for building the necessary Zap are contained in a PDF file stored as an attachment field located at the far right-hand side of the [dashboardCalc] table.

[R_Felciano_QIAG]

This is very cool – did you ever get this working? If so, would you be willing to share your Zap?

Ramon

[Andrew_Enright]

Yes, it’s working fine. And happy to share my Zap, though not sure how best to do so. Screenshots? Zapier isn’t very export friendly.

But to top-line it… 1. Trigger: New Record in View. 2. Find Record, Search Value is Title from Step 1. 3. Update Record; Record equals Custom Value, Custom Value for Record ID from Step 2, Barcode Image URL equals URL from Step 2.