I have an calculation field in my table which has ExecuteSQL statement. It basically does an count of status field. So I want to know how many item have supported status?
The problem is, the calculation field is not auto updating. When I change product status, I expect calculation to update so number of Support status product increase.
The field in in table.
Any one know why it does that. How I can make it so field auto populates itself when I change product status.