google-apps-script | Google Apps Script

I saw this post about Google Apps Script - Copy row from table if value in table meets condition. Is there any way to do the same with gsheet formula and not apps script?

• I want to create PDF files per each slide of a Google slide file (a normal slide with words and graphs).
• I reviewed past questions and I found a solution that generates PDF files but taking the slides as images (I need to be able to search for words in those pdf).
• Another solution was applied to convert the spreadsheet -> PDF but also it didn't work for my case.

This was my reference

My Google Application Script creates PDF file. The I want to let user to download it. I wanted to make it easier for every one so I thought web application would be great choice. So I started to google for solution but I was not able to find anything userful.

Ideally I want to have form where web user enters a code that triggers PDF file creation (that part is ready - the PDF sits in Google Drive) and then the file is downloaded to end user computer via web browser.

Is that possible via web created in Google Application Script?

From this answer I found that what I am looking for is not possible https://stackoverflow.com/a/36701196/250422

The closest solution I found is google-web-app-script-to-auto-download-from-google-drive

I have taken the script from this post Which works perfectly when exporting to a folder in "My Drive" but if I try exporting it to folder in a "Shared drive" I get this error:

GoogleJsonResponseException: API call to drive.files.insert failed with error: File not found: 1ENj9R......

Is there any way around this?

In my Apps Script add-on, I need to use an external library JSSoup for managing some HTML text. I followed this answer to figure out how to add/import an external library in Apps Script. Then I added eval(UrlFetchApp.fetch('https://github.com/chishui/JSSoup/blob/master/lib/jssoup.js').getContentText(); in my script but it is throwing this error:

I'm looking for a way to trigger a GAS (google app script) when I upload a file to google drive. I was pointed to the push notification API. I can't get it to work with GAS. There are a lot of questions about this on StackOverflow, but they were all 5+ years ago. Any change since then? Can I do this without using cloud functions?

Questions I've looked through:

• Can I trigger a Google Script when a file is saved to Google Drive? (No Real Solution)
• Creating a Google Apps Script which Automatically Executes on Upload (No Answer)
• Drive API Push Notifications for a Google Apps Script Web App (Possible Solution?)
• Use a GAS published web app as a handler for Drive push notifications (Not Helpful)
• Unable to create subscription with a push end point on App Script (script.google.com) (Outdated)
• Use Google Script's Web App as Webhook to receive Push Notification directly (Outdated & Not Helpful)

And much more I've not mentioned here.

I am also aware you can do this with a timer, but waiting 15 minutes for the change to take effect would hurt my use by quite a bit. One mentions a solution I like, but I don't know how to make it work :

UPDATE: Gmail leverages Cloud Pubsub for push notifications and this service has recently been updated to remove the need for domain verification for push endpoints. So, going forward its now possible to use GAS Web App URLs in this scenario.

If I could make it work it would solve my issue. Question about the above: Google Push Notifications API Without domain Using App Script

Follow up to Sending duplicate data to array, then checking if said array is empty or not to decide what code to run next, if statement not working correctly.

I'm pretty much trying to copy the conditional formatting that I put to notify users of "bad" data, but with script to prevent sending bad data and giving unique error messages. With the answer from my last question, the checks and preventing sending no data or data with duplicates works, but I'm now stuck on preventing sending of data that does not match the format of a four digit number.

My conditional formatting was to set the background color to orange on anything that was not equal to or in between 1000 and 9999, but I'm having trouble getting the scripting to work--I'm trying to use negation of anything in between those two values as the "false" that will prompt an error message, and the "true" to let the rest of the script run that will send the data and notification emails out. However, this makes it say that there are bad values even if I do have the correct data in. Removing the negation lets anything go through, like it's not actually checking it. Any ideas?

The section I'm asking about is the last else if statement:

I'm trying to include a duplicate check in a script that uses a Google Sheet as an input form for data that sends it to another spreadsheet. I'm trying to set up the check to prevent sending if there are duplicates present or no data, but I keep getting the message saying that there are duplicates even if there are not, or even if there are no values. Any idea on what is going wrong?

Sources of some of my script: https://techyesplease.com/code/google-apps-script-find-duplicates-sheets/

https://www.freecodecamp.org/news/check-if-javascript-array-is-empty-or-not-with-length/

https://amarindaz.com/google-apps-script-if-else-statements/

I have been trying to make a Google Sheet for some purpose which shall have details of various movies. Here is the link: https://docs.google.com/spreadsheets/d/10-4BWaK-zmTxmqr2ov7AvjQW-wAFR8NKXkICuCK1dTY/edit?usp=sharing

Now I have different sheets for different years as visible in the sheet. Now in the column Platform I want to expand the drop down. Obviously it will be time consuming if I edit every sheet individually. I also have another sheet with name Platforms which lists all option required in drop down of all sheets. So I there anyway that the drop down list is dependent on the data in sheet Platforms. google-apps-script