Trying to implement and use connect Gsheet.
I'm a noob in the Dart coding language, and have a hard time debugging code I don't understand. I created a calendar that should save data in a google sheet. If you click on a date, a sliding_up_panel will appear, in that window you can enter your worked hours directly, or use time-picker which calculates your worked hours for you and insert them in the number fields, in the Dropdown menu you select the type of working hours you have worked, if they are regular working hours with your standard salary, or if you have worked overtime that gives you more pay, etc. clicking "SPARA"'save' button, it should send the hours you enter to the right column in the google sheet from the dropdown menu. The google sheet will automatically calculate your hours, deduct tax and give you your salary specification the moment your worked hours reach the sheet. You can then use the hamburger menu on the top left, ore swipe from the left and a new side bar will appear and show you your salary and total hours worked.
The dropdown will send the input hours to the respective column in the sheet. 'Normal working time' to "D9:D39", 'Overtime hours' to E9:E39, 'Holiday pay' to F9:F39.
I have been trying for months now, in every way possible, to create these functions, without success. and I understand that it can be difficult for you to explain in detail all the steps that need to be done to achieve this. So my question is instead! Can someone please reproduce this script with these functions and post a copy of my app, with a working code, so we all noobs can learn how to do this in the future projects?.
Top comments (0)