Need Help! prevent users from requesting a duration that exceeds their remaining time quota

[ABG]

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…

Your data format on the sheet should be for the benefit of the app, which is the only user interface.

You are tracking remaining minutes.

The Clock component from the Sensors Drawer has time conversion blocks.

Faq Section: Clock

Tutorials: Guide - How to Use the Clock - Alaqmar Bohori datetime formats Samples: Countdown timers How to get UTC with datetime format Z Multi-day timer display - Ergin UTC ISO 8061 to standard time - Michael_Barbone Advanced: How to keep app running after screen goes off - Taifun An Instant is not a Duration is not a milliseconds - ABG, TimAI2, Anke You can't store Instants in TinyDB - @Taifun Advanced DayLight Savings Time Time Zone Investigations How does AI2 know my Time Zo…