Appsheet Store Images on table data source SQL server.

[Juan]

Hello! Can anyone please help me!? I have a table connected to a SQL server. In this table I want to capture cellphone images, but after I save the table form, in my SQL colum (image) doesnt appear the url text of the image and I dont know where all the image storing. Thanks!

[WillowMobileSys · Accepted solution]

Images will be stored in the cloud service of which you are using to connect with AppSheet.  E.g if you are logging in with a Gmail account, the images will be stored on Google Drive.  If you are using a Microsoft login, they are stored on Onedrive, etc.

While storing images directly in the db can be done, it is super inefficient.  It is best to store the URL in the db and then locate the image in a File system.  File systems are typically optimized to handle these files better than a db and its much simpler to expand the storage when needed.

[Juan]

Thank you so much! I checked and I saw the images in my google drive account. I really dont know about file systems, could you give me some example? can I send them to a dropbox? thank you!

[WillowMobileSys]

File systems are simply platforms that allow you to store files.  Your desktop computer allows you create folders and place files where you want - that part of the operating system is a File System.  Google Drive,  Onedrive, DropBox are examples of cloud based file systems.

By default, AppSheet will use the cloud system tied to your login attached to the account.  If you create an account with a Google login in, then Google Drive become the default file system.  If you create an account with Office 360 login, then Onedrive becomes the default file system.  Same for Dropbox.

I do not think you can re-direct your files to be stored on a cloud system other than the default in normal app usage.