Lukket

Google Sheet Application Templates

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.

Evner: Google App Engine, Javascript, node.js, Python

Se mere: google map application software, use google maps application, use google map application, create google map application, turning excel sheet application, google base application, vba application templates, add google ads wordpress templates, php google base application, google calendar application, free flow sheet application, google maps application, add google maps application, visual basic 2008 application templates, google doc email templates

Om arbejdsgiveren:
( 0 bedømmelser ) Mahomet, United States

Projekt ID: #16196210

16 freelancere byder i gennemsnit $7801 på dette 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 Flere

$8247 USD in 30 dage
(182 bedømmelser)
8.1
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 Flere

$10000 USD in 30 dage
(11 bedømmelser)
7.0
TheInnoVibes

Hello, We are a hard-working web-development company working on core PHP And Wordpress , Magento , Shopify projects. Relevant Skills and Experience [login to view URL] https://shop.redbullrecords. Flere

$10000 USD in 30 dage
(54 bedømmelser)
6.4
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 Flere

$10000 USD in 15 dage
(36 bedømmelser)
6.4
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 Flere

$5000 USD in 30 dage
(12 bedømmelser)
6.0
abhilashtv

Hi, ➲ 7+ years of full-time experience in Python / Django with 50,000+ Upwork hours billed and 50+ successful Python projects ➲ Upwork Top 10 Certification for Python and Django ➲ Guaranteed Results Policy: Pay only Flere

$8333 USD in 30 dage
(14 bedømmelser)
5.8
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 Flere

$7000 USD in 40 dage
(10 bedømmelser)
5.5
spiretech

Hello, I have gone through the post and yes; I will help you for sure to design and develop a Google Sheet Application Templates with clean design and clear responsiveness to all devices [login to view URL] Flere

$8500 USD in 30 dage
(12 bedømmelser)
5.3
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 Flere

$5555 USD in 60 dage
(23 bedømmelser)
5.0
WebsplinesCanada

hello , i have read your specs carefully , i am quite optimistic we can deliver the scope . we have excellent expertise in google app engine, plenty of work is done in firebase , we have been working in collaborati Flere

$9628 USD in 40 dage
(3 bedømmelser)
5.0
$8333 USD in 30 dage
(10 bedømmelser)
4.6
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 Flere

$8333 USD in 30 dage
(29 bedømmelser)
4.9
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 dage
(3 bedømmelser)
3.2
BEAS24X7

Hi, This is from BEAS Consultancy and Services Pvt Ltd ( [login to view URL] ). We are an India based CMMI level 3 and ISO Certified  Organization. We produce quality and Cost effective solution to our int Flere

$7000 USD in 30 dage
(2 bedømmelser)
2.7
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 dage
(0 bedømmelser)
0.0
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 Flere

$5555 USD in 30 dage
(0 bedømmelser)
0.0