We have different branches in cities. 

We want user to add certain data in different columns. 

Next I want to be able to do mathematical calculations on those fields. 

Based on the result of the above calculation using ( > or < or = ) if then else I want it to another database and add 1 or subract 1 from another database and also trigger and email and SMS alert. 

Essentially what we are doing is we have broken a persons salary into daily w tasks with different weightage. Based on this we have created a daily report sheet which needs to be updated daily.

So if a work is not done then the application will access the second database which contains data of the persons salary and weightage for the task and will accordingly "add" salary for thr work done or "deduct" salary for that particular day. 

Is this possible. ?

Regards 

Bhavesh Shah