I want write sheet link in app not in appscript .what change in appscript?

[mah_bagh]

Hi . i have an app that send information to google sheet.i want write sheet link in app not in appscript .i must what change in appscript?
thanks

function doGet(e) {
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/ukXGauEofalwwmyEZerqE5c6A/edit#gid=0");
var sheet = ss.getSheetByName("Sheet1");
addUser(e,sheet);
}
function doPost(e) {
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/ukXGauEofalwwmyEZerqE5c6A/edit#gid=0");
var sheet = ss.getSheetByName("Sheet1");
addUser(e,sheet);
}

function addUser(e,sheet) {
var id = e.parameter.id;
var name = e.parameter.name;
var email = e.parameter.email;
sheet.appendRow([id,name,email])
}

[TIMAI2]

Change this:

SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/ukXGauEofalwwmyEZerqE5c6A/edit#gid=0");

to this:

SpreadsheetApp.openByUrl(e.parameter.SheetUrl);

and in your app add the parameter SheetUrl to your GET or POST request

SheetUrl = "https://docs.google.com/spreadsheets/d/ukXGauEofalwwmyEZerqE5c6A/edit#gid=0"

[mah_bagh]

@TIMAI2

and in your app add the parameter SheetUrl to your GET or POST request

Hi thanks.i must what change in my app??

[TIMAI2]

add both blocks to the bottom of your join block in PostText

[mah_bagh]

Hi
function doGet(e) {
SpreadsheetApp.openByUrl(e.parameter.SheetUrl);
var sheet = ss.getSheetByName("Form responses 1");
addUser(e,sheet);
}
function doPost(e) {
SpreadsheetApp.openByUrl(e.parameter.SheetUrl);
var sheet = ss.getSheetByName("Form responses 1");
addUser(e,sheet);
}

function addUser(e,sheet) {

var date = e.parameter.date;
var name = e.parameter.name;
var famil = e.parameter.famil;
var father = e.parameter.father;
var point = e.parameter.point;
var SheetUrl = e.parameter.SheetUrl;
sheet.appendRow([date,name,famil,father,point,SheetUrl])
}

appscript in above correct?(ss????)(i made a var Sheeturl and add SheetUrl in sheetappendRow.correct?)

add two block.

[TIMAI2]

All looks OK, have you tested it ?

[mah_bagh]

hi yes i tested but dont work.
var sheet = ss.getSheetByName("Form responses 1");
in this line "SS"?????

[TIMAI2]

Sorry missed that....should be

var ss = SpreadsheetApp.openByUrl(e.parameter.SheetUrl);

[mah_bagh]

Hi. thanks .correct.