sync hybrid systems based on index changed with sql query updates
I have a table field that is used to keep track of therapist time with clients. I have already requested that they make the ability for the left most column to stay visible as they scroll across columns to the right but If the therapist doesn't have a scheduled session then they enter an alpha code for that day. To deal with this alpha code and make things as easy for myself as possible rather than looping through each row in the table and do all of the error checking to calculate total time and percentages of sessions in a workflow, I do that nightly with a powershell script that runs sql queries and updates everything with an sql query on our local system. But then I have to do an auto index on the local system to change one index to get those sql changes to sync with the cloud. It would be nice if I could just do the query and have it sync the updated records.