I am building a scheduling system for volunteers and want to create a field that combines a volunteer’s name (Volunteer) with their photo which is stored in attachment field (Photo).
When trying the obvious Photo&" "&Volunteer airtable returns the photo’s filename followed by its url. I found in this forum a formula that will strip out just the url. But it still doesn’t actually display the image at that url… just displays the url string itself.
The idea is that we have a very large volunteer base and not everyone knows names. So we would like to display a photo of each person in the schedule beside their name.
Some possibilities that come up…
You could do a lookup of the Photo based on the Volunteer Field as a way of having the picture visible.
You could create a gallery view based on all people that have a shift “today”
Page designer could also be used if you’re trying to make printouts or a PDF.
Is there a specific reason you want to change the URL of the filename?