Workflow

Workflow

Hi,

How to define a status based on element the item information?

Suppose I have a table named 'Request' with these fields:
- Date submitted
- Date validated IT
- Date validated Business

Now I need to know the status of each request by having a status field like this:
- Status=submitted
=> if 'Date submitted' is not empty
- Status='validated IT'
=> if 'Date validated IT' is not empty
- Status='validated Business'
=> if 'Date validated Business' is not empty

How can I do that with Zoho Creator?

Regards, Chris