workspace manager - final year project

Danial's college final year project

This application helps you manage your working time and task by auto-filling your timesheet and letting you import issues from Jira only by their issue key, also the front end app is written in flutter so you can run it on multiple platforms without any problem.

Work Manager
https://miro.com/app/board/o9J_loWms0s=/?invite_link_id=643367372584

other links

A Notes App For MacOS
A Notes App For MacOS
https://iosexample.com/a-notes-app-for-macos/
GitHub - myvsparth/flutter_rest_api: How to integrate REST API in Flutter
How to integrate REST API in Flutter In this article we will learn how to integrate REST API in flutter app. As we know that now a days almost all the app uses remote data using APIs. This article will be the crucial part for any developer who wants to make their future in flutter.
https://github.com/myvsparth/flutter_rest_api
Charts | Sheets API | Google Developers
The Sheets API lets you create and update charts within spreadsheets as needed. The examples on this page illustrate how you can achieve some common charts operations with the API. In these examples, the placeholders spreadsheetId and sheetId are used to indicate where you would provide those IDs.
https://developers.google.com/sheets/api/samples/charts

https://docs.google.com/spreadsheets/d/1txtgLUf7TQwZkc_kYcWqbuBuVKLAKNmNydpIQH-6nNE/edit#gid=134926531

Google Sheets API | Google Developers
Reads and writes Google Sheets. To call this service, we recommend that you use the Google-provided client libraries. If your application needs to use your own libraries to call this service, use the following information when you make the API requests. A Discovery Document is a machine-readable specification for describing and consuming REST APIs.
https://developers.google.com/sheets/api/reference/rest
Pulling JSON data into Google Sheets from an API
I recently setup a website for a client who needed a newsletter sign-up process (e.g., subscribe, verify, unsubscribe). To collect the e-mail addresses from the website I am using AWS API Gateway along with a Lambda and DynamoDB for storage. This solution works well; however, it is difficult for a client to retrieve data stored in DynamoDB without headache.
https://josh-weston.medium.com/pulling-json-data-into-google-sheets-from-an-api-963012482933
Connect Google Sheets with 3rd Party API Using Apps Script
Apps Script, as defined by Google is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. Basically it allows you to write codes for Google's services like Gmail, Google Drive, Sheets, Calendar, etc to automate your workflow or interact with external services.
https://medium.com/@sagunshrestha/connect-google-sheets-with-3rd-party-api-using-apps-script-121da46969bd
How to consume any JSON API using Google Sheets, and keep it up-to-date automagically
Google Sheets are very powerful when you know how to use them. You can do so much with those, and at Unly, we rely on them to automate many things, without relying on developers to build custom tools. #productivity Most of today's online services provide ways of extracting data into a spreadsheet, whether it's CSV, Google Sheets, Excel, etc.
https://medium.com/unly-org/how-to-consume-any-json-api-using-google-sheets-and-keep-it-up-to-date-automagically-fb6e94521abd

call your api from google sheet

API Tutorial For Beginners with Google Sheets and Apps Script
In this API tutorial for beginners, you'll learn how to connect to APIs using Google Apps Script, to retrieve data from a third-party and display it in your Google Sheet.
https://www.benlcollins.com/apps-script/api-tutorial-for-beginners/

Sign in - Google Accounts
https://script.google.com/macros/s/AKfycbww2rF4px-icb_yV5rfqUdCof_3HgCljpKsnWTGVoGVbFUUZXn5SSQUUSnzaF9NGcC4/exec
Google Apps Script as a Backend Part II: Time to REST
In Part I of the tutorial, we handled very basic data retrieval from our "database", i.e., spreadsheet. Today, we will build a basic "REST-ish" API to access it. It will not adhere to all the rules of REST because of some Google-Apps-Script limitations, but it will be intuitive enough for anyone who has ever worked with REST.
https://x-team.com/blog/google-apps-script-rest/
https://github.com/PatilShreyas/Flutter2GoogleSheets-Demo
Work with long lists
The standard constructor works well for small lists. To work with lists that contain a large number of items, it's best to use the ListView.builder constructor. In contrast to the default ListView constructor, which requires creating all items at once, the ListView.builder() constructor creates items as they're scrolled onto the screen.
https://flutter.dev/docs/cookbook/lists/long-lists
Meet Google Drive - One place for all your files
Google Drive is a free way to keep your files backed up and easy to reach from any phone, tablet, or computer. Start with 15GB of Google storage - free.
https://script.googleusercontent.com/macros/echo?user_content_key=tTPXAcDd90tCHirV0PJVz9r8dspRT0icIt2J9OoG6yN521wyTKPsDmDzMFCacFtbV1OAk1_p0XEEc_QuWCMPxB9eTPM2FxrDOJmA1Yb3SEsKFZqtv3DaNYcMrmhZHmUMWojr9NvTBuBLhyHCd5hHa2XQ3ykW6mt2gMDH3pencLc-7R-Wycs_cQAb0cPVg2wrDp8-OM8t2xKRwGG08h-zlLl4vi6K6tFZtgHBbkro2B3Uceafi3r9j6zcCLCqhZJsMHK4KKDMuH3iHRL19jcFW55gW-0ZzPy1fTAK3vGy6kBDSQ2Y1fR-h2xo4xcwd8dJ6kRRFDZoHJ5faBdX-npXDA&lib=MM18CwpaCZpm4CurhNx5UjKKUO1juqm10
Google Sheets - create and edit spreadsheets online, for free.
Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.
https://docs.google.com/spreadsheets/d/1txtgLUf7TQwZkc_kYcWqbuBuVKLAKNmNydpIQH-6nNE/edit#gid=1274396138
Write your first Flutter app, part 1
Tip: This codelab walks you through writing your first Flutter app. You might prefer to try writing your first Flutter app on the web. If you prefer an instructor-led version of this codelab, check out the following workshop: This is a guide to creating your first Flutter app.
https://flutter.dev/docs/get-started/codelab
Flutter: Apps Script with Google Sheet
Flutter has been able to grab the attention of the development community by introducing a style that allows for expressive liberty making it a joy to build UIs for mobile apps. It incorporates certain concepts familiar to modern development experiences like reactive programming and widget composition while using the Dart platform as its main base of operations.
https://medium.com/flutter-community/flutter-apps-script-with-google-sheet-938d95a9a33f
Apps Script
Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. Start Scripting Build with Google Feature-rich APIs let you extend Google services and build your own web applications. Code on the Web A web browser is all you need to build with Google Apps Script.
https://script.google.com/home/projects/1omDN1rU51Kgpa0r22-1K32rN17MgywMgxTgy0GzLYQSIZRpWY0T_6lOY/edit
https://github.com/PatilShreyas/Flutter2GoogleSheets-Demo
Google Apps Script as a Backend Part II: Time to REST
In Part I of the tutorial, we handled very basic data retrieval from our "database", i.e., spreadsheet. Today, we will build a basic "REST-ish" API to access it. It will not adhere to all the rules of REST because of some Google-Apps-Script limitations, but it will be intuitive enough for anyone who has ever worked with REST.
https://x-team.com/blog/google-apps-script-rest/
API Post request in Google App Script not working - Pretag
I managed to do the API POST request through Postman but once modified for Google App Script it doesn't work. I think it might be related to the body format, I can't replicate the new URLSearchParams() object in GAS (I'm sending a JSON I believe)., Are people with a PhD least likely to be vaccinated in the US?
https://pretagteam.com/question/api-post-request-in-google-app-script-not-working