One field value depends on other field value

[Andrii]

Hi All,

I've used to solve this task with Data Lookup Rules previously, but this mechanism seems to be not very comfortble with Duration fields.

So, I have two fields and one of them - choice list. I'm looking for solution how to change second field value on a form when 1st changes.

Values for second field should be stored somewhere separately(Lookup Table).

The problem is - when I change Duration type field (2nd field) it gets into 1970-01-xx format and gets back to normal only after saving changes.

Is it possible to omit 1970-xx... display format while changing field value with Data Lookup Rules?

[Andrii · Accepted solution]

I've solved the issue using Integer field instead of Duration.

[The SN Nerd]

I wish they would get rid of or hide the 'mandatory' and 'read only' check boxes on data dictionary. It is, in my opinion, bad practice to use them, and the same functionality can be achieved with ACL's and Data/UI Policy.