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?

jshah-3
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

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.