In the transition from a Google Sheets based CRM to AppSheet there have been a lot of great strides forward but with photos I’m a bit stuck about how to proceed.
Each job has around 10-30 job photos and we currently process these on the laptop and drag them into a pre-made Drive Folder, the link for which, via a GAS script, is shared with the customer in an email.
But since there’s no way to in AppScript to create a custom folder path (i.e. for each customer), all photos from every job are going to be in the same folder. I need to figure out how to set things up so a customer gets a link for them to see their job photos only.
I don’t have any significant experience in doing online stuff that may be needed here. With random names (generated by AppSheet), I can’t filter by file name in some sort of webapp.
I’m out of my league! Any thoughts? I’m fine with some Google Apps Script like a GAS WebApp. I can learn what’s necessary, just no idea which avenue to pursue. Hopefully something simpler.