I have a custom object that has "Group Events." These are events our org runs that have one or more partner accounts (i.e. someone who hosted the event or helped pay for the event space), featured speaker contacts, etc.
After events happen we're having the event organizers upload photos as attachments to the "Group Event" alongside things like PDFs of flyers and agendas for the event. Most events will have photos of the event, but not all of them.
I want to allow our designer to login to Salesforce and be able to find the latest photos of events, as well as list events that have photos attached.
What would be the best way to expose this data to him inside Salesforce? For example, is there a way to list inside Salesforce all photos for a custom object type, or list all custom objects that have attachments that are JPEGs?
We're using lightning.