Hi,
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.
Thank you!
Solved! Go to Solution.
Thanks but Iโm pretty sure, from testing, and a post from a year ago, that it only accepts a static path like โJob Images/โ
Trying to create a dynamic path so itโs different for each job like this:
โJob Images/โ & [Street] & [Suburb]
โฆdoesnโt seem to work. It just reads the first text string and from what Iโve tried and read thereโs no work around.
A lot can happen in a year. Sure seems like it works to me:
Oh man am I happy to be proven wrong! Thank you. Sorry to have bothered you about this - it turns out that the app wasnโt saving due to having a later numbered version saved in another window. Lesson learnt.
And thank you AppSheet team for getting this in place.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |