I need to create an app that will allow me to save photos in a specific tree structure in a dropbox folder. The structure is Customer\Suburb\Street\StreetNum.
The data (a spreadsheet) has a field named ImageTaken and I have set the Image/File folder path to a virtual variable I created called [PhotoPath] which has an App formula = [Customer]&“”&[Suburb]&“”&[Street]&“”&[StreetNum] but instead of saving the photo in the designated folder, it replaces the “” character in the PhotoPath variable with a “-”, then creates a single folder with that full string as file path and saves the photo in there. E.g. if the PhotoPath is Downer\Canning Vale\Carlton Loop\22 the photo is saved in Downer-Canning Vale-Carlton Loop-22
Is there any way I can modify the app to achieve the goal I am after, or is this beyond the scope of AppSheet?