Hi ​@arappai,

Welcome to the Community.

Zapier doesn't directly support adding a photo to a database, but you can work around this by storing the photo's URL instead. First, upload the image to a cloud storage service like Google Drive or Dropbox and obtain a shareable link. Then, add the URL to the database instead of the photo in your Zap. This lets you store and display the image by fetching it using the URL. The exact process may vary depending on your setup.

Feel free to reach out to us if you have further questions.

Hi, this is interesting, what if the photos URL was in Airtable, how would we be integrating the expiring url from Airtable, is that conceptually possible ? 

Hey ​@arappai 

Hi i am planning to prototype a interface where i can setup a visitor mgmt system, but i can not find a way to add a photo column, is there a workaround ? 

Are you wanting to display a preview of the image or just have a link to it stored in a Zapier Table? I’m assuming it’s Zapier Tables that you’re wanting to add a Photo column to as Zapier Interfaces was tagged here—is that correct?

If so, it’s not possible to have a preview of an image file displayed in a Zapier Table. I’d suggest submitting a feature request for that here.

That said, you could have a link to a file that’s uploaded by a Zapier Interfaces form if you use a File upload field on a form to capture the photo files. For example:

Then when the form is submitted a record would be added to the table with a link to view the file that was uploaded:

You could then have a Zap trigger when a new record is added to the table and pass that image file to another app if needed.

Hi, this is interesting, what if the photos URL was in Airtable, how would we be integrating the expiring url from Airtable, is that conceptually possible ? 

If you’ve got an Airtable form where folks are uploading the photos then you could have a Zap trigger when a New Record is added in Airtable (for the form submission records) then the Zap could grab the image file’s URL (or the file object—depending on how Airtable sends it over ) and send it to another app before the file link expires. See our Send files in Zaps guide for more details on how to pass files between apps.

Hope the above is helpful. If I’ve misunderstood what you’re wanting to do here or if you have any further questions just let us know! 

hmm, yes and no, i was hoping to utilize the interface in Zapier to be able ti quickly see the photo of the students before checking them in to the campus. I could just potentially use Airtable for this and offload the backend logic of pushing that data to the SQL DB using a ZAP, but it would have been nice to have it all in one. 

Hi ​@arappai,

I’m so sorry for the delayed response.

You might need to contact our Interfaces team so that they can take a closer look at your request and provide you their best suggestion. We have a dedicated team that supports Interfaces. You can contact them here: https://npsup.zapier.app/contact-us?product=Interfaces

Hopefully, this helps.