Need to get changed according to the status...

Need to get changed according to the status...

Hello Friends,

I am using Zoho Creator for my database solution purpose... I have different columns in the applications... I want something in my application which can fulfill my requirement..

1. Created Date Column (This is the column where my employee select the date)
2. Modified Time Column (This is the column which record the time, when it was last modified.)

3. Status Column (This is the column where we give status to that particular lead)

Now i want something like where if i change the Status of the lead than only Modified time should be changed... Like if i change anything else should not change the modified time... But the moment i change the status column than modified time should also get changed with that.

Hope you understood my problem & requirement....

Looking forward for your kind suggestion ASAP.

Thank You