@ghost5 wrote:
I am not going to change my user account to my Google account due to headache that I'm sure it will cause, so I'll stop going down that route.
Just in case, what you would do is create a NEW account using Google, then follow the steps to transfer ownership of an app from one account to another - it's not difficult and all paths/folder should migrate just fine. For comparison, you could create a copy and then transfer that copy so you can see if Google provides better performance than OneDrive.
@ghost5 wrote:
if I can get the default path to change to our projects SharePoint folder, through my account, and have all PDFs to save in there.
Yes, this is possible. I have worked with a client who had their app setup this way - though I do not know what steps they needed to perform to establish this setup. I personally don't work with Microsoft products any more. I do know the client had occasional issues using SharePoint.
@ghost5 wrote:
For the images I want to add them to Google Drive outside of the app and to show them in a row on a form.
This implies then you wish an Image column in the table. Once you have Sharepoint/OneDrive access, simply allow AppSheet to perform its default image storage - i.e. don't do anything extra. AppSheet will create a folder and place images for that column in that folder on the default cloud storage provider and record the proper location in the datasource sheet. When the row is viewed or edited, AppSheet will know where to find the image from that same provider.
@ghost5 wrote:
I also have no issues in uploading photos through the app and storing them in Google drive
I'm curious how you made this work if you are using a Microsoft 360 login. Theoretically, if you are able upload an image through the app then AppSheet should know how to retrieve it. But depending on how you setup the Google Drive access in that app, it may be the app is using Google to store the image but later attempts to use Microsoft to retrieve the image.
I think sometimes new App Creators attempt to manually handle image access when they don't need to. AppSheet has good default behavior. At the very least, I would recommend to start with the default behavior until you understand how it works then modify it if you do need more sophisticated image management for some reason.
LinkedIn
Twitter
