In my app people must enter rows into an ‘incidents’ table. There is a predefined array of incident types that I store in a ‘taxonomy’ table. The taxonomy table lists each incident and their severity level (1-4).
When people select the incident concern from a drop down, I want the form to automatically show the escalation level. I wrote the below formula for the escalation field in my incidents table.
“concern” is the incident type the person selects
“taxonomy” is the lookup table
“concern” is the field name in the look up table
“escalation level” is the field name in the look up table that I want it to return.
The problem is, when I use this code the escalation field in dissapears from my form. Show is checked but it just goes away. If I remove this formula, it returns.