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:
- Table “Filenames” is read only. A Google App Script runs once a day and pulls in the filenames of images I have in the folder “Images”.
- In the App I can add a row to table “Zoom in Form”. I can choose a file name and it shows the image with:
- XY
- Image
- Show
- Zoom is possible only in column type XY
- This trick is possible only with images that are already uploaded.
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]);
}
};