Managing Files and Images in AppSheet

[@eltabros]

Thank you for the tutorial! Been struggling for hours to find the format

[@njelu2020]

Great tutorial🎉 simple but useful

[@hasansiam2838]

How to upload images with filenames matching the ID name?

[@GusVegaFantasma]

Great tutorial! How can I add the images route if already have a folder with subfolders? Could I edit directly in Google sheets?

[@appify]

Yes. You just need to make sure the path is below the default folder. The limitation with using Google drive path in AppSheet is that all paths must start from the default folder path. This is based on the location of the spreadsheet in "My Drive"

[@jmssistemas6422]

My friend, can I insert the imagem directly on the cell? I need to attach the image uploaded on a spreadsheet, but the appsheet puts only the folder addres (not the url).

[@appify]

Yes you can. This article describes it well. You basically need to construct a deep link to the image. Then in your spreadsheet add a column with the image() formula directly in sheets. When you regenerate the table in your app AppSheet will automatically create this formula in the sheet for new records too. support.google.com/appsheet/answer/10107317

[@New-ZteoR]

@@appify Please make a tutorial on this. I am having no luck on getting photos taken from the app to show as an image inside an xlsx document.

[@appify]

@@New-ZteoR xlsx does not support image() formulas. AppSheet can only put images in Google sheets. For xlsx you need to settle for image links.

[@scottbeisel7598]

@@appify do you have a tutorial for how to do the image links?

[@puripuriprisoner9732]

Can we change the image name?

[@appify]

When you are saving files to a file store you can remove the timestamp to have full control over the name of the file.

[@vvdd903]

can you help with an express that yield dynamic folder with two sub folder?

[@ririnhakim8075]

What is formula in display image? And why do I upload image, resolution's image is low? Please help me

[@appify]

The formula is "if([type]=file, "file icon image path", [image])". This makes an image show for all records even if the user uploads a file. You just pic a static file icon from the internet and put the path in the formula. There is a setting under UX options called image resolution. You can set this to full to retain the original image resolution.

[@softwareengineer8260]

Hi My question, I want to store images in dedicated server, instead of Google Default folder path, is it possible if possible what is the process

[@appify]

Under My Account-> Integrations you can add a GCS, SEE or Database as a File store. Then for each table in your app you can change your default file store for the table to your new source.

[@appify]

support.google.com/appsheet/answer/10106769?hl=en at the bottom you can find the instructions.

[@gianemosquera1313]

can i download the file that i uploaded on the row/form directly from appsheet?

[@appify]

Yes. When you view the detail of the record you will see the filename and can click on it to download the file.

[@graedojo9347]

Is there a pattern or guide as to how to create the formula?

[@appify]

I have this video that does an overview of the formula system. kzbin.info/www/bejne/Y5eko2OZps-Mn68. Is there anything additional that would be helpful?

[@graedojo9347]

@@appify Do you have any related video about showing or generating top 10 or 20 purchases of a customer.

[@aresfebrian]

Thank you Sir

[@Otisawide]

Hi! Thanks for the tutorial. Basically, it uses for clustering the file by the folder, for this case the folder name is divine by the month. Is it possible if making the files name due to the uploaded date? Thank you!

[@appify]

Yes you can do that as well. You just need to create a column to capture when the file is submitted. Then use that field in your folder formula.

[@Otisawide]

@@appify Where do i input the formula?

[@appify]

This part shows you where you can modify your folder path. So after you create a new column to capture the date, just add that column to be part of the path. kzbin.info/www/bejne/ioHUnaafaJmUoJo

[@Otisawide]

@@appify thank you so much!

[@softwareengineer8260]

Hi My question, I want to store images in dedicated server, instead of Google Default folder path, is it possible if possible what is the process do you have knowledge on this.

[@vvdd903]

Can you check my formula?? "Image Storage Path Test/"&"[site]/"&{a ant}/ . Trying to get the site column folder name to change with site value of site column. for example, that column will have site 1, site 2.

[@appify]

What is {a ant} supposed to be?

[@vvdd903]

@@appify the name of a subfolder or a name of one of the column in google sheet

[@appify]

It would look like this "Image Storage Path Test/"&[site]&"/"&[a ant]

[@vvdd903]

@@appify thank you so much. it works. I can also make a third sub folder by replicating the last path. any way you can explain why this works?

[@appify]

The formula is building a folder path where each / is creating a sub folder. The & are concatenating strings or column values together. Anything inside " " is a string of text. Anything inside [ ] is a column value. So AppSheet computes the formula then stores the file to the resulting path.

[@hermawanyulianto2645]

It is cool tutorial, can we rename the file name ? thank

[@appify]

Not directly. However AppSheet uses the key to derive the file name plus a timestamp. So you could get close by creating a virtual column that concatenates certain fields you would want to use as the file name.

[@dennismanalo6904]

@@appify Can you teach me how to use a field value or virtual columns as the file name?

[@jamesbottomley2596]

The whole file location thing in Appsheet is incredibly annoying.