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).
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
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!
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. th-cam.com/video/TPqlsi34aj8/w-d-xo.html
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.
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.
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.
I have this video that does an overview of the formula system. th-cam.com/video/-fAr0cqjYiM/w-d-xo.html. Is there anything additional that would be helpful?
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.
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.
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.
Thank you for the tutorial! Been struggling for hours to find the format
Great tutorial! How can I add the images route if already have a folder with subfolders? Could I edit directly in Google sheets?
can you help with an express that yield dynamic folder with two sub folder?
Thank you Sir
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).
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
@@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.
@@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.
@@appify do you have a tutorial for how to do the image links?
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!
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.
@@appify Where do i input the formula?
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. th-cam.com/video/TPqlsi34aj8/w-d-xo.html
@@appify thank you so much!
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.
can i download the file that i uploaded on the row/form directly from appsheet?
Yes. When you view the detail of the record you will see the filename and can click on it to download the file.
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
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.
support.google.com/appsheet/answer/10106769?hl=en at the bottom you can find the instructions.
What is formula in display image? And why do I upload image, resolution's image is low? Please help me
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.
Is there a pattern or guide as to how to create the formula?
I have this video that does an overview of the formula system. th-cam.com/video/-fAr0cqjYiM/w-d-xo.html. Is there anything additional that would be helpful?
@@appify Do you have any related video about showing or generating top 10 or 20 purchases of a customer.
Can we change the image name?
When you are saving files to a file store you can remove the timestamp to have full control over the name of the file.
It is cool tutorial, can we rename the file name ? thank
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.
@@appify Can you teach me how to use a field value or virtual columns as the file name?
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.
What is {a ant} supposed to be?
@@appify the name of a subfolder or a name of one of the column in google sheet
It would look like this
"Image Storage Path Test/"&[site]&"/"&[a ant]
@@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?
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.
The whole file location thing in Appsheet is incredibly annoying.