Hello Everybody,
I have a field in my data base called status and want it to be updated automatically based on the input in certain fields.
For example:
If order sent field is checked, status field should show Phase 1
If order sent field + order shipped field is checked, status should show Phase 2
If order sent field + order shipped + Installation done field is checked status should show Phase 3
and so on.
Thanks.
I have a field in my data base called status and want it to be updated automatically based on the input in certain fields.
For example:
If order sent field is checked, status field should show Phase 1
If order sent field + order shipped field is checked, status should show Phase 2
If order sent field + order shipped + Installation done field is checked status should show Phase 3
and so on.
Thanks.