cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

update second datatable value when the system time matches the row value of first datatable?

jshah-3
1-Newbie

update second datatable value when the system time matches the row value of first datatable?

I have 2 datatable

first data table have 3 fields

start time ,Name and Stop Time

Second datatable have 2 datafields

Name and value(0/1)

now i require that when the system time (actual time) becomes equal to start time of first datatable the value becomes 1 for that name in the second datatable

and when the  system time (actual time) becomes equal to stop time of first datatable the value becomes 0 for that name in the second datatable

is it possible to achieve?

1 REPLY 1
supandey
19-Tanzanite
(To:jshah-3)

Hi Jugal it should be doable with a Timer thing which checks for actual time=start and you can subscribe to that event to execute service in the background to set the value = 1. And this same logic can be used for your 2nd question.

You can check for the Timer Thing Template for more detail

Top Tags