Custom Form to store and read data with Google Sheet -
$30-250 CAD
Cancelled
Posted almost 8 years ago
$30-250 CAD
Paid on delivery
The function of this simple form and script would be to do the following:
Allow a person to record the project ID, priority, supplier details and item details.
The current google form and script extracts the "username" email address of the google user because we are using Google Apps.
Not sure if this can be done with a custom form... If not just a field to for the requesting person to enter their email would be ok.
A formatted approval request email would be sent to an email address associated with a project ID
If there is a 2nd approval person associated with the Project ID, an escalation button is included in the approval request email as an option.
When Approved/Escalated/Rejected Google sheet is updated with status label & email address of the person how actioned.
Emails also sent to the original persons email address who submitted request updating the status of order.
Some of the script has already been written, this may or may not be of help.
( [login to view URL] )
Attached is a concept for the form based on a 2 step entry, If the form can be a single step and the data stored into the google sheet that would be even better.
Please include the keyword: Apple in your 1st message, as dummy bids will be ignored.
Open to better concepts based on your experience, those who can not provide examples of similar work will be ignored.
Apple :)
Hello,
I have good experience doing similar projects and can show you several examples of similar projects,
But I can't give you the most similar example until you give me access to the current spreadsheet.
Hello, i can offer application written on Nodejs (JavaScript) or Java (Spring Framework).
Application features direct connection to Google Sheets for managing data (requires API key configured in google console). Front-end interface will be done using SPA (Single Page Application) written in AngularJs So page functions without reloads. From design standpoint application will use semantic-ui framework for styling.
Full source code with comments and documentation will be provided via Git repository.
Contact me for more information.