Google Sheet intimate

Entering and modification of data in cells.
Formatting of cells, columns and lines.
Use of predefined styles and customization of formats.

Standalone Script – Open A Google Sheet File

I wrote a standalone script deployed as a web application. The point of the script is that by clicking on a button a google sheet file is copied to a specific directory, then I want the new file to open. My code is blocking to open the new file. Parts 1 and 2 in Codetest.Gs Work Perfectly (Roughly from the Value Associated With the Clicked Button, The Script Will Look in a Google Sheet File for the Name to Give To The Form As Well As the Location where it must be copied). In my code you will notice that I am am Talking about a form, but it is indeed a google sheet file (in Practice the Google Sheet File is a Document to be girl in which is similar to a form). Codetest.GS

Function Doget (E) < return HtmlService.createHtmlOutputFromFile('page'); >FCTOPENFORM FUNCTION (IDFORM)"; Return htmlservice.CREATEHTMLOUTPUT (HTMLSTRING); > 

  
Form choice
 
Click on the desired form
 Making appointments Refund - Initial online payment Refund - Initial payment at the counter FCTGETVALUE FUNCTION (Element) 

I’m not Joining the Called Functions Becaus They Work Fine. Indeed, if i do a logger.LOG (URL) to check the value of the variable defined on line 34 of codetest.GS, it does contain the url of the new file created. I WONDER WHY THE LAST PART DESN’T WORK:

 // 3 - Open the new file created var url = newform.Geturl; Var htmlstring = ""; Return htmlservice.CREATEHTMLOUTPUT (HTMLSTRING); 

This piece of code works fine if i use it on my own elsewhere, but not here. Is it because in the same script you can’t use htmlservice twice? I COULDN’T FIND ANYTHING ABOUT THIS Limitation, But I DON’T See Any Other Reasons. Unfortunately i cannot share the documents mentioned in my code with you, i am in a company with a domain not shareable with account other than bears. I am sorry for my English.

Google Sheet intimate

Why choose this formation ?

The conditions

Goals :

Understand the bases of Google Sheets and its user interface.
Create, modify and format spreadsheets for different types of data.
Master the functions and formulas commonly used to carry out calculations.
Use data organization tools such as filters, sorts and groupings.
Collaborate effectively with other users by sharing and working simultaneously on spreadsheets.
View and present data in the form of graphics and tables for better understanding.

Prerequisites :

None.

For who :

This training is intended for anyone wishing to develop their business.

Assessment :

Assessment of skills acquired during training via a questionnaire and situation.

The training program

Introduction to Google Sheets

Discovery of the Google Sheets user interface.
Creation of a new document and navigation in the various options.
Management of spreadsheets and tabs.

Creation and formatting of data

Entering and modification of data in cells.
Formatting of cells, columns and lines.
Use of predefined styles and customization of formats.

Use of formulas and functions

Introduction to basic formulas for simple calculations.
Use of integrated functions.
Creation of personalized formulas to meet specific needs.

Organization and manipulation of data

Use of filters to sort and filter data.
Grouping of data using columns or lines.
Use of dynamic cross -tables for data analysis.

Collaboration and sharing

Sharing spreading sheets with other users.
Simultaneous work on a spreadsheet with employees.
Using comments and editing authorizations.

Visualization of data

Creation of graphics to visually represent the data.
Personalization of graphics with formatting options.
Use of tables to synthesize and present the data.

Detailed program on request with satisfaction rate