Skip to main content
jshah-31-Visitor
1-Visitor
June 7, 2017
Question

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

  • June 7, 2017
  • 1 reply
  • 1142 views

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

supandey5-Regular Member
5-Regular Member
June 7, 2017

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

Terms & ConditionsAccessibility statement