I have a requirement in which I need to set only if the status value is Active,expired or inactive in DB without the use of validate rule/Edit-validate rule. So, How can I Restrict values to be store.
Hi @SANDBIT: Can you provide more details on the request? What are the possible values for the specific field?
You can add a prompt list / field value in the property table type which will implicitly help you to do the validations.
Thanks.
Hi @ArulDevan,
For example - In DB I need to store value for status field that only store value as Active,Inactive,Expired or Revoked. That DB maybe delegated to the authorized user which can change status as required in future so in that case it should not accept other inputs apart from them(I think of using picklist as field type but my TL said no).
@SANDBIT Use local list in property and give the mentioned status, when you map data into that property it will implicitly throw error if you try to put other values in DB.
@ArulDevan . In property : Table type - field value.Thanks… It worked for me