My idea was to use apps script to generate a barcode and write it to my database in base64 (this way it would not be computed all the time in a virtual column).
I thought that the most viable option was to do it in base64 since creating a folder on the drive, giving a unique name to each image, having to store the images and write the path to be able to view the image in appsheet seemed undoubtedly more complicated.
First create a test script that does not involve appsheet, the script took a cell of the sheets that contains a text, sent it to an api to transform it to a barcode then transformed it into base64 and wrote it in another cell of the sheets (worked as expected)
I adapted the script to integrate it with appsheets and the result was what I thought would be more difficult to do. A folder had been created on my drive where the png images of the barcodes were saved, and in the cell where the Base64 image should appear there was the path to the corresponding png image. This is not the behavior I expected, although it works well, the images display well in appsheet (it is almost like the native behavior of appsheet when uploading an image from the interface)
Here the question arose: what is best ? Have the images in Base64 inside the sheets or save the png images in a folder on the drive?
I think this could be used to upload many images at once to appsheet, instead of using the appsheet interface that only allows you to upload one by one (it’s just a hunch). Maybe there is already a way and I’m not aware of it haha