Google Sheet Application Templates

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

NOTE: Do not reply to this opportunity unless you have published Apps through the Google Store.

Objective--

The successful bidder will create a set of components to build business-process applications based on a database masquerading as a multi-tabbed Google Sheet with reports created using Google Docs. I will use these templates to create client-specific customization providing the required application for individual construction projects.

Approach--

1) The Contractor will prepare a Google App Script that can be used to create, read, update, or delete individual rows in an a single Google Sheet with one Tab, a single Google Sheet with multiple Tabs, or multiple Google Sheets each with one or more Tabs. It can be assumed that the referenced Google Sheets will be contained in either one Google Drive Folder or in Folders below the principal Google Drive Folder.

2) The Contractor will create HTML forms in Google Sheet App Script to perform Create, Update, and Delete actions on individual data rows within specified Google Sheet Tabs. The Contractor will require as input to these forms, the Google Sheet Name, Tab Name, Row number (for Update and Delete), and Tab Column Number.

2.a) The Form Field label will be set to the Table Column Number Header (in row one of the identified Sheet/Tab/Column). The second (hidden) row can be assumed to contain the data type specification for this data. The third (hidden) row of the tab can be assumed to contain the definition of the data to be provided in this column. Form fields having non-read only values will add informational icons for the data type and definition based on the hidden 2nd and 3rd rows of the selected column.

2.b) Create and Update form field formats are required so support text(100), text area, numeric, a specialized NULL character ("n/a"), date (specialized to store only in ISO Date or ISO Date/Time format '2018-01-30T09:00:00 (and be escaped so that the date time formatting is not converted in EXCEL to seconds past 1900), or a lookup list (which will be specified by separate sheet/tab/column), all forms come with hidden of the user's Gmail account. All saved data will be checked to ensure only printable, non-XML ASCII characters are provided and trim(clean) data is added or updated.

3) The Contractor will create a set of Google Doc App Scripts to perform Read actions on sets of data rows within specified Google Sheet Tabs. The Contractor will require as input to these forms, the Google Sheet Name, Tab Name, Column Name, Column Search Criteria, Column Search Value, and Report Heading Name.

4) The Contractor will create one specialized Create Form that allows users to upload PDF and JPG/GIF files and log these files in a Google Sheet Name, Tab Name, and Column number.

5) The Contractor will create one specialized set of Google Doc reports that identify the percentage of Google Sheet Name, Tab Name, Row counts that have, or do not have, specifically provided values. As before, the Contractor's template will be customized, and the values stored, to create individual reports.

6) The Contractor will allow the specification of individual forms, as noted above, to be saved in a master Google Sheet and used to populate custom Google Sheet Menus that are presented when the working Google Sheet is opened.

6.a) The master Google Sheet will be organized to set the Top Level Menu Headings, Sub Menu Headings and Separators.

6.b) As part of this specification, the property of a given form field as hidden, read-only, optional, required will be set and used to provide feedback directly in the HTML form prior to posting.

7) All work will be consistent with Google App practices to allow me (once completing creating a complete set of form templates for different clients) to create a Google apps.

8) An NDA will be required, unless we develop a partnership to jointly sell the underlying technology.

Google App Engine JavaScript Node.js Python

Project ID: #16196210

About the project

15 proposals Remote project Active 6 years ago

15 freelancers are bidding on average $7679 for this job

Yknox

Dear,I am Gang Lee . I'm interested in the project you recently posted. I'm a certificated freelancer with over 900 good reviews from clients. I have experienced knowledge in every part of Web development. I never More

$8247 USD in 30 days
(367 Reviews)
8.8
UnitedWebSpace

How are you ? My name is Bryan Valencia. I am full stack developer and have great experience for 5+ years. Also, I have a passion for working on project and I am faithful. I am fully committed to producing quality More

$10000 USD in 30 days
(16 Reviews)
7.6
stefkev

Hi, I will state in first sentence that I haven't published a google app, but I have done this kind of projects for others. If you are not interested in reading further, disregard this bid. I have read all your req More

$10000 USD in 15 days
(54 Reviews)
6.9
micheal4299

You can also check my portfolio: https://www.freelancer.com/u/micheal4299 I also have experience in working on similar projects. I have some questions regarding the project. Are you available? Let me know if you ar More

$5000 USD in 30 days
(12 Reviews)
6.1
laxaar

Hello, Thank you very much for sharing your requirement to create a set of components to build business-process applications. I am very well familiar and experienced in publishing apps on Google store. I have More

$7000 USD in 40 days
(10 Reviews)
5.7
ioanaprof

Dear Sir or Ms. I am John, pleased to meet you. I'm well experienced in Google Apps Script and G Suite. Please, take a look at my portfolio in my profile. All your requirements are achievable. Thank you fo More

$5555 USD in 60 days
(33 Reviews)
5.2
GeorgeKazi

Hi! I have not published my own app, but I have developed apps for people who've then published these on the Google Store. I have a record of 18 similar projects here on freelancer and I'd love the opportunity to wo More

$8333 USD in 30 days
(29 Reviews)
5.1
king18yat

I can create designs, website , Online shops , Android , IOS and desktop applications or any custom software for you . I shall also provide 1 year support for any bugs . Source will commented.

$5000 USD in 44 days
(6 Reviews)
3.6
writinginvaderz

Writing Invaders is a group of independent professional writers and website developer and scholars from everywhere throughout the world. Together, we give best quality aid to secondary school, undergraduate, Masters More

$5555 USD in 30 days
(2 Reviews)
3.2
zdesign77

Hey, how’s it going? My name is Mike, I’m a Web Designer & Developer based in Boston area. I feel that my skills match your project needs. I recently did a very similar project which I can share with you.

$8333 USD in 30 days
(0 Reviews)
0.0