İptal Edildi

Front end HTML GUI with apps scripts in google sheets


I play an online game called EVE Online in my free time. We use a set of google sheets for in game payouts. We need to automate the process for payouts as well as keep a running total of what payouts are done to which players on which day. We also need to be able to report on past data.

Link to google sheet document used today:

[url removed, login to view]

I have been playing around with scripting to see if I could accomplish the task however in December Google moved to using HTML/CSS for front end GUI.


Two html UI windows that will work with the google sheet and some simple apps scripts to copy data to/from sheets

HTML window 1:

1) This window will launch based on an apps script

2) it will populate based on data from the Loot Calculation sheet.

2a) the data that populates needs to be dynamic; Some days there may be 5 lines, other days there could be 8 or 10 or 21, etc.

3) Each line of data should have two fields.

3a) the first field should be read only and display the Item Name

3b) the second field should be editable, accepting only numeric values

3b1) the second field should read data, if available, from the corresponding Item_Quantity field.

4) there should be a cancel button

4a) the cancel button should close the window

4b) none of the values entered should be saved

5) there should be a second button (name TBD)

5a) when pressed, the button should save the Item_Quanity values to the Loot Calculation sheet

5a1) the button should bring up a new UI window

2nd UI window:

6)This window will populate based on data from the Calculations sheet.

6a) The data that populates needs to be dynamic; some days there may be 2 lines, other days there might be 6, 12, etc.

7) each line of data should have 4 fields

7a) the first field should be Name and should be read only

7b) the second field should be Tier % and should be read only

7c) the third field should be Number of sites and should be read only

7d) the fourth field should be Payout and should be read only

7e) At the bottom, there should be one free form text optional entry field labeled "Payout Notes"

8)Below the freeform field should be three buttons

8a) one button should be labeled Back

8a1) when clicked, it should take the user back tot the 1st UI window

8b) the second button label is TBD

8b1) when the second button is clicked, it should display a confirmation window/warning window

8b2) the window should have yes/no or ok/cancel buttons with prompt content TBD)

8b3) When "ok" or "yes" is select, the system should write the Payout Notes data to Settings(main) B43

8b4) when Cancel/No is select, the system should return the user to UI window 2.

If you review the attached sheets, I'll outline the process flow.

1) Users will run sites in the game.

2) Once finished, the users will got to the Site Log sheet and enter a numeric value for how many sites they ran.

3) The person who is going to do payouts, gathers all the in-game loot items

4) they enter the information into Loot Calculation sheets.(this piece should be automated with HTML UI window 1

5) Once the loot is entered, they review payouts on Calculations. (this piece should be automated with HTML UI window 2.

6) Once everything looks good, they send the corresponding payments to each player in game.

7) The information will get saved to another sheet for future data reporting, values on the Site log sheet and loot Calculation sheet cleared (this piece I will work on once the UI windows are complete, supplementing as needed with your help.

All code needs to have clear comments what it does.

I would prefer it follows the best practices found here: [url removed, login to view]

Beceriler: CSS, HTML, Javascript

Daha fazlasını gör: write scripts online, write name on items online, write a report online for free, what is numeric data entry, what is an apps script, what does a data entry person do, using google apps, ui reporting, sites html 5 free, sites google com free, simple html scripts, scripts in html, script sheets, scripts for google spreadsheets, scripts for google sites, scripts for google, play html 5, online on how to write a report, notes in google apps, https sites google site

İşveren Hakkında:
( 6 değerlendirme ) Sacramento, United States

Proje NO: #7157494

Bu iş için 7 freelancer ortalamada $13/saat teklif veriyor


[login to view URL] ® Portfolio HERE, I have reviewed your project description and I am confident I can complete your website with all the customization you want to have integrated in the back-end. I am an experien Daha Fazla

$19 USD / saat
(44 Değerlendirme)

Hello Sir, First of all, we would like to tell you how we will initialize the project with you. We insist to follow these steps before you award the project to us: - We (technical team) will review the job and Daha Fazla

$11 USD / saat
(64 Değerlendirme)

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Daha Fazla

$15 USD / saat
(22 Değerlendirme)

Hello, i am a HTML5, CSS3, Bootstrap, Javascript, Jquery developer and Web & Graphics designer with more than 7 years of experience.I have done many many website and won many website designing contest and i am very muc Daha Fazla

$12 USD / saat
(1 Yorum)

Hello guys, I play eve since 2008. You need loot separation tool, right? ( I am a bit dyslexic, so I didn't read it all, sorry). Why we don't try to use the pilots API from CCP? You probably have the API of every Daha Fazla

$12 USD / saat
(4 Değerlendirme)

A proposal has not yet been provided

$13 USD / saat
(0 Değerlendirme)

Hello there. I am Mobile game developer with experience over 6 years. I am familiar with HTML5, CSS, Flash, AS3, and several JS game engine. I uploaded several html5 games to apple and play store. please review Daha Fazla

$12 USD / saat
(0 Değerlendirme)