Select Specific Value According To Previous Dropdown List

[AbdullaNsour]

Hi all, 
In the previous project I learned how to select the value according to the previous drop down list.

However, when I try to set the initial value for the 'Sub Type' field using an expression like IFS([Main Type] = 'building', 'Building Violations'), it fails to function as intended.

[Denny774]

Hey,

you don't need that. Just use "Eng Type" as the Table Label.

😉

[AbdullaNsour]

I am already do that but I need to create an expression to automatically fill the input when the previous dropdown list with some value
like this :

[Denny774 · Accepted solution]

Hey man,

maybe use INDEX(Sub Type[Sub_ID], 1) as the inital value?

[AbdullaNsour]

It currently functions, but any changes or additions to the Sub Type might result in errors. Nonetheless, I appreciate learning about this formula. Thank you.