I found some similar posts but I don't think I found the answer.
I have an automation that takes a photo sent via Google Form to the drive and generates a link. As this link cannot be read by the appsheet, I created an automation to transform the link into something readable by the appsheet.
CONCATENATE("https://drive.google.com/uc?export=view&id=", MID([Photo3], FIND("id=", [Photo3]) + 3, LEN([Photo3])))
Now Google said it will no longer accept this formula. what should I do ??? need help
Are you able to read the file name itself and then use it instead of the URL?
User | Count |
---|---|
17 | |
14 | |
8 | |
7 | |
4 |