Prompt Dialog box Google apps script tutorials 12

Title: Prompt Dialog box Google apps script tutorials 12

Description:
A prompt dialog box is the pre-built dialog box that displays a prompt message and shows a text input field with Ok buttons and other optional buttons.

When you want to get some information from the user you can use the prompt dialog box.

It contains two methods as shown below

getResponseText - It returns the text entered by the user in the textbox
getSelectedButton -It returns the button clicked by the user.

Recommended books:

========================================================

********** Tutorial Playlists **********

****** Contact me ********

******* Books written by me ********

******* Productivity tool *********

******* Gear Used To Shoot This Video ******
_Audio & Microphone

********Learning partner********

[AlberichRheinmann]

this ( i think ) is only for bound scripts ... is there a method for unbound ? 😊

[DEEPAKVERMA-xm]

Sir how do i add on dropdown in promt response ? i want to pick from the list

[asifpaLash]

show me how to put the response to a sheet

[SuperdupernoobYTchannel]

hey thank you so much for the video, I've been watching your whole playlist and it i very clear and helpful.

I tried to play around a little with this code and attempted to create a variable that would display the input age on the first quadrant of the sheet.
I tried using the knowledge from the previous lesson (tutorial 11) and this is what I got:

function prompt_box()
{
var

var ui=SpreadsheetApp.getUi();

var prompt=ui.prompt("Age", "Enter age", ui.ButtonSet.OK_CANCEL)

var

var

if(button==ui.Button.OK) {
ui.alert("your age is"+response);

var rec=sh.getRange(1, 1).getValue(response);
}
else if(button==ui.Button.CANCEL) {
ui.alert("you have cancelled");
}

}

Should I have added " var rec=sh.getRange(1, 1).getValue(response);
" to another place? this is the error that it gives me:

Exception: The parameters (String) don't match the method signature for (line 16, file

thank you so much for your videos!! a very good help

[Cesar_EP]

I need a message like popup window, for information only with OK option nothing more :/

[EdwinKok]

Nice video! How to create a dialog box with more than 1 input? For exampe age, weight and lenght?

[tharungaushikk]

How to create prompt message to be triggered when the cell is empty by changing one status

[Amarindaz]

Check out my popular playlist

Tutorial Playlists

[multaniinvestments]

what if i wanna enter user response to a specific cell how m gonna do that