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

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

Highlighted
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?

Tags (1)
1 REPLY 1

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

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