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.
LOOKUP(โconcernโ,โtaxonomyโ,โconcernโ,โescalation levelโ)
โ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.
Please post a screenshot of the configuration screen for the escalation column of the incidents table.
Thanks. Which part of the configuration screen? I attached the part where I put in the formula.
As shown in the screenshot:
"concern"
is not โthe incident type the person selectsโ; instead, itโs a fixed literal value. Does the Incidents table have a column named concern? If so, you probably want this expression instead:
LOOKUP([_THISROW].[concern],โtaxonomyโ,โconcernโ,โescalation levelโ)
See also:
Thank you Steve! Youโre right. But fixing this still isnโt making the value appear on my form
Nevermind! Did some more fiddling and now it is showing! Thanks again Steve.
Well done!
hello Andrew how did you get the value to appear i am currently experiencing this same issue
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
18 |