Home‎ > ‎AppsScript‎ > ‎

Apps Script / Payslip


EGD Package Manager > Payslip


Description:


This tool is a generic format filler that replaces %PARAMETERS% from a Google Docs file, getting the information from different sources

  • Form fields: Each Google Forms field is represented by the word ‘%fieldNUMBER%’ where NUMBER is the field order. Example:

    • First field in form will be represented as %field1%

  • Spreasheet row:  The first column contains the user email to be located. The first row that matches will be returned and field will be represented with this notation %columnNUMBER% where NUMBER is the column order. Example:

    • First column in spreasheet will be represented as %column1%

  • Web service: [NOT_IMPLEMENTED_YET] This takes as input an URL and sends to it the userEmail, the service must return a JSON encoded array. The tag used is %dataNUMBER%.where NUMBER is the array position number.


The parameters can be configured inside the Google Forms embedded code or in the configuration area on Google Forms format.


The information of the staff member is taken from login.


Links & Demo:


Form


Script


Demo Template


Demo Data


Form View


Web App


Demo (FormView or WebApp) :

Demo user: egd--employee-01@gfunze.com

Demo password: egdpassword


Screenshots:


Data:


Template:


Form Configuration:

Form:

Result:

Generated file:


The file is sent to user:


FormView:


Comments