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:
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:
