this is awesome! is there a way to rename the file based on some cells in an active sheet and then auto link the attachment using a smartchip in the active sheet?
Currently smartchips are not yet supported in apps script (I know, wait, what?!?), so you could rename the files based on text in the cells, but you couldn't add it as a chip, just a link for the moment.
Hello, the loading circlke for me just doesn't seem to stop and its not uploading the file either. Do you have any fixes for that? I already changed the folder ID
I just retested this to make sure it still works, and it does. So for the folder ID, you need to make sure you only use the ID part of the url. So for example, if the folder url is drive.google.com/drive/folders/1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj Then use this as the folder id: 1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj Like so: let folderId = '1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj';
Is there a way to take out all the images directly already stored in cells in google sheets, move them to gdrive, and re-link them in the same cells using image() function?
I know you couldn't before, and I don't think anything changed, but you can't access images inserted into cells using Google Apps Script so this would not be possible as far as I know.
![Free AI Code Autocomplete in Google Apps Script - Codeium AI Setup Tutorial [SheetsNinja]](http://i.ytimg.com/vi/kf9YzCby-N4/mqdefault.jpg)
![Free AI Code Autocomplete in Google Apps Script - Codeium AI Setup Tutorial [SheetsNinja]](/img/tr.png)
This is awesome! Is there any update to update many sheets data at same time with 1 script I want to update factory stock record.
this is awesome! is there a way to rename the file based on some cells in an active sheet and then auto link the attachment using a smartchip in the active sheet?
Currently smartchips are not yet supported in apps script (I know, wait, what?!?), so you could rename the files based on text in the cells, but you couldn't add it as a chip, just a link for the moment.
Hello, the loading circlke for me just doesn't seem to stop and its not uploading the file either. Do you have any fixes for that? I already changed the folder ID
I just retested this to make sure it still works, and it does.
So for the folder ID, you need to make sure you only use the ID part of the url. So for example, if the folder url is drive.google.com/drive/folders/1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj
Then use this as the folder id: 1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj
Like so:
let folderId = '1bGObY9SDASiMVR3DCQEozh-Aot3Do1hj';
Is there a way to take out all the images directly already stored in cells in google sheets, move them to gdrive, and re-link them in the same cells using image() function?
I know you couldn't before, and I don't think anything changed, but you can't access images inserted into cells using Google Apps Script so this would not be possible as far as I know.
Can you run this from the mobile version?
Unfortunately not, scripts and popups don't function on the mobile app or the mobile browser.
try running in mobile browser in desktop site mode?