Please help me with this project

[vmugg]

Hi

I am new to AppSheet. I would like to ask for help with my project.

I'd like to make a blank sheet that has:

time

egg

timer

active

time remaining

it will collect data from AppSheet from this menu:

 

if the icon is tapped; it will create a data with fixed timer for 60 minutes to hatch, like:

time	egg	timer	active	time remaining
11:00 am	egg6	60	yes	46
11:14 am	egg3	60	yes	60

every egg timer remaining 10 minutes, will automatically remind the farmer that the egg will be going to hatch.

the farmer can decide to extend the hatching time for 30 minutes or 60 minutes or not to.

if the farmer chose to extend for 30 or 60 minutes, the data will be shown as:

time	egg	timer	active	time remaining
11:00 am	egg6	60+30	yes	46
11:14 am	egg3	60+60	yes	60

however, if the time runs out it will stop there.

but, when another egg came in with the same number as earlier, it will create another data with another option to extend or not.

time	egg	timer	active	time remaining
11:00 am	egg 6	60+30	no	0
11:14 am	egg 3	60+60	yes	46
12:46 pm	egg 6	60	yes	60

It would create a new blank datasheet for everyday

also, i would like to change its color to green when it is active, yellow it only has 10 minutes left, then red

 

when the farmer notice the red. The farmer can tap the red button to reset it to black.

I think this simple application will be useful for many applications that could help many people. 

[Joseph_Seddik]

Welcome to the community!

AppSheet does not have a countdown timer capability, and being-data driven, it might not be the best tool to accomplish what you want to do. But in any case, here's a smart solution that could help, please read this tip:

Countdown timer in sample app - Google Cloud Community  

And have a look at this sample app that you can copy: Timer. 

Thanks to @Kirk_Masden 

[WillowMobileSys]

As indicated by @Joseph_Seddik , AppSheet doesn't support "countdown timer" type functionality.  This would require processes that check conditions even when a user is not using the app.

AppSheet is user action based - meaning that it can only (well...mostly) check conditions only when a user is actively using an app.

There is one exception - Scheduled Automation.  These processes will run at a predetermined automatic schedule.  The minimum interval is Daily.  You can setup processes that run every hour - one for each hour you wish to check - which is a suitable workaround.   

To achieve YOUR timer goal you would need many, MANY more processes.  Moreover, the processes DO NOT always run precisely at the scheduled times depending on processing bandwidth being used.  They can be widely inaccurate. 

For these reasons, AppSheet is not a suitable tool for your requirement of being able to notify down to 10 minute intervals.