Advanced Alerts in Google Sheets: Customizable Pop-ups

[@TyJ329]

Is there a way to make a pop up happen once a certain checkbox has been ticked?

[@practicalsheets]

Of course, we would need to have an onEdit trigger. I'll take it into account for a following video Kind Regards

[@practicalsheets]

For now, you may take a look at this video for inspiration. kzbin.info/www/bejne/iXa1p5qJmbyoncU

[@JennLui]

Is there a way to have the popup appear when you switch view to a specific sheet? I don't want it to popup right on open. Example: Show popup when user clicks Revenue sheet.

[@_TurboRider]

thank you for your videos

[@practicalsheets]

Thank you for commenting!

[@naturecalm5794]

Can you link it so that the pop-up only happens when you check a checkbox?

[@WaniTutor]

How to create a pop up of sound of video said successful, after we done scan the qr code?

[@JosePerez-qt8cf]

Excelente video, tengo una pregunta es posible deshabilitar el boton cerrar del modal para que el usuario no pueda cerrarlo, lo pregunto porque se puede poner un formulario para que se registre la informacion sin tocar sheets directamentr

[@practicalsheets]

Hola! En ese caso yo no lo haria en Sheets, sino como un webapp Saludos!

[@achmdalfy7157]

How to set a style for popup like full of colour without original template?

[@practicalsheets]

Hello! What do you mean "without original template" Kind Regards

[@achmdalfy7157]

@@practicalsheets i mean can app script make full pop up like for some ads?

[@achmdalfy7157]

@@practicalsheets or just when open the file ot will be open another webb app

[@practicalsheets]

@@achmdalfy7157 Hmmm. I don´t think it can be done, maybe have a big pop up but it will not stand over the menu and bar for example Kind Regards

[@AustinHolland-l6j]

Thanks for the great videos! How can I create a pop-up that has the user enter a specific value (like their name or a $ amount)?

[@practicalsheets]

Then we would need to create an HTML form inside the HTML file you created. I'll take note for a next tutorial Kind Regards

[@AustinHolland-l6j]

@@practicalsheets The use case is: i want a pop-up to prompt the user for a data value, which then gets recorded into the workbook. But I do not know if this is possible. I'll subscribe and look for a future video, thanks!

[@practicalsheets]

@@AustinHolland-l6j It is possible. I'll write it up for a new video Kind Regards

[@HK-qg2vr]

Great video! I have a question, are you able to create two separate pop ups with different messages on the same sheet? For example 2 alerts or 1 alert and 1 html with different messages.

[@practicalsheets]

Absolutely! The question is if you want to show them in different moments or in the same moment but one will show if a condition is met, and the other, if a different condition is met Kind Regards

[@HK-qg2vr]

​@@practicalsheets Yes I want to have two pop ups when you open up the sheet. I have the conditions written out for both but only one shows up when I open the sheet. How can I get both to show? Do I have to add "function onOpen" to both conditions?

[@practicalsheets]

@@HK-qg2vr You should one before the other, and add the code that once the user clicks OK in the first one, the second one will appear Kind Regards