![]() After posting this, I had an experience where a new image I added worked fine in my browser but crashed both my iOS and Android devices. Be sure to test carefully in both your browser and in a device or two. Then, in AppSheet, I can put Humpty Dumpty back together again using CONCATENATE() in an image-type virtual column. My solution is to split the code into pieces under 50,000 characters each and then paste the pieces into cells in my Google spreadsheet. If, however, you have merely converted png images to svg (as I have done), your files may be a good deal over 50,000 characters. If you begin by making an original image using a vector graphics editor, you should be OK. If you put the code in a text editor that has a character counting feature, you can check to see if the code is under Google spreadsheet's limit of 50,000 characters. This can be a bit harder than one might imagine. Put base64 svg code in Google spreadsheet However, at this writing, I haven't tested to see if it is possible to split the code for large SVG files between cells (next step, explained below) without using base64.ģ. To reduce the amount of text you put in your spreadsheet, I have come to the conclusion, thanks to comments by and others, that it is generally preferable to use the SVG Icon Tool to prepare SVG for insertion in a spreadsheet than to use base64. Note: When I wrote this tip, I was not aware of SVG Icon Tool, which Converts SVGs to AppSheet format. SkrOYC introduced us to this site, which works quite well: In Inkscape, I set the document to my preferred size (600 x 280), then import my png image, tweak if necessary, and then export as svg. I understand it is also available for Windows. I use a free program called Inkscape on my Mac. It's a bit tedious but if you don't have that many images, it's doable. SkrOYC's tip helped me see that the solution is to put SVG images in your spreadsheet because that way they don't require a URL and display instantly. I finally got the help I needed from this tip written by Icon/Background/Launch image generation with no public URL needed (SVG) I've been wondering if there might not be a workaround for this problem for quite some time now. ![]() When a user is shown the following sort of message, it might take a second or two for the image to show up - not very cool: This, however, caused a different problem. So, for these reasons, I had to turn "Store images for offline use" off. (By the way, the syncing didn't just get stuck - it caused my iPhone to get hot: ) I've reported this issue to AppSheet but it remains unresolved: In my case, I use some QuickChart graphs as images in my app but, for some reason, those images cannot be cached and, instead of being skipped on my iPhone, they cause the syncing to get stuck when I have "Store images for offline use" set to "on". If, however, you would like to have a small subset of images appear immediately, regardless of your internet connection but, for some reason, cannot or do not want to store all of the images that may be added to your app by users, this tip may help you. If you are comfortable caching ALL of the images in your app, you may not need this tip. (Please vote for these if you would like to be able to control caching by table, instead of the current all-or-nothing choice.) Store content for offline use for specific tablesįiner-grain control over local image caching The feature requests (both for basically the same thing) can be viewed here: This tip is a workaround to solve a problem for which a new feature has been requested.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |