Advanced Alerts in Google Sheets: Customizable Pop-ups
Vložit
- čas přidán 28. 08. 2024
- Today we'll learn how to create customizable pop-ups in Google Sheets to show information and alerts to your users. Using HTML, you can modify colors, include links, adjust sizes, and more, taking your spreadsheets to the next level.
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below
thank you for your videos
Thank you for commenting!
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.
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
@@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?
@@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
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)?
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
@@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!
@@AustinHolland-l6j It is possible. I'll write it up for a new video
Kind Regards
Is there a way to make a pop up happen once a certain checkbox has been ticked?
Of course, we would need to have an onEdit trigger. I'll take it into account for a following video
Kind Regards
For now, you may take a look at this video for inspiration. czcams.com/video/SERvgSdWugc/video.html
How to set a style for popup like full of colour without original template?
Hello!
What do you mean "without original template"
Kind Regards
@@practicalsheets i mean can app script make full pop up like for some ads?
@@practicalsheets or just when open the file ot will be open another webb app
@@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