auto update records in a table

bala_1312
Tera Contributor

‎12-28-2023 12:15 AM

in a table there are few fields called "site name", "start date" and "end date", now there multiple same "site name" can be present and we need to check those same reords "start date" and "end date" and based on the "start date" and "end date" we need to make the records active true and false , for ex -(a & b) there are  2 records with same "site name" , a records  "end time" is the "start time" of b record  then when the curret date time will match with the  a records end time and b records start time then a records will be deactivated and  b records will be acivated true .

 

please suggest me any idea how i can achieve that ?

 

Thanks!

0 Helpfuls
  • 254 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎12-28-2023 12:57 AM

Hi @bala_1312 

sorry, but it's pretty confusing. Please provide some sample data to help us understand you better.

Maik

0 Helpfuls

bala_1312
Tera Contributor
In response to Maik Skoddow

‎12-28-2023 01:50 AM

hi @Maik Skoddow ,

 

need to run a job/flow on  a table  daily,  where it will check the "site_name" field has any duplicate entries or not , if there are duplicate records present with same site name then it will check the start and end date of those records and based on start date and end date the daily scheduled job or flow make  records active true and false. for ex - if two records with same "site_name"  - "xyz" present in the table and  one records start date is end date of another records then the flow/scheduled job which will run daily will make one record true and another false.

0 Helpfuls