In form view it is not possible to zoom an image with column Type “Image” or “Show”.
This trick uses column type “XY” to zoom an image in form view.
Please watch my video
Here is the sample App “Zoom in Form”. You can find it on my portfolio:
https://www.appsheet.com/portfolio/549987
What it does:
I’m happy to hear your ideas
Here is the Google App Script. I’m not very good in GAS, so maybe someone could advice a better solution?
function Filenames() {
var folder = DriveApp.getFolderById("1XOIlibG31TBpz44MvTzJG9CSSC8MSOyM");
var contents = folder.getFiles();
var sheet = SpreadsheetApp.getActive().getSheetByName('Filenames');
sheet.clear();
sheet.appendRow(['Filename']);
var file;
var name;
var link;
var row;
while(contents.hasNext()){
file = contents.next();
name = file.getName();
link = file.getUrl();
sheet.appendRow([name]);
}
};
So then, the link it grabs is a public URL?
Ups you are right. The expression
SUBSTITUTE(CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=ZoominForm-549987&tableName=Zoom in Form&fileName=Images/”,[Filename]), " ", “%20”)
creates a link like
https://www.appsheet.com/template/gettablefileurl?appName=ZoominForm-549987&tableName=Zoom%20in%20Form&fileName=Images/undraw_publish_article_icso.png
which is a publik URL.
Why is that so?
adding @Aleksi
@Fabian What do you mean by “Why is that so?”. Sorry I couldn’t understand your question.
@Aleksi isn’t that unsecure? I mean, I would expect, that AppSheet would ask for login to see the image.
See also: