Context("View") field keeps disappearing from screen

[Daisy_Ramirez]

Hello, I’m using the Context(“View”) function to determine the drop down options available based on the form the user is on. The dropdown has a Data Validity expression with a select statement that uses the virtual context field to filter the dropdown options

When I input something into the form, the context field appears on screen for a few seconds and then disappears again. The drop down box I’m hoping to filter doesn’t even appear as its filtered by the context field.

Is the field supposed to remain visible? Am I using it incorrectly?

[Steve]

What are all of the expressions involved?

[Daisy_Ramirez]

Sorry Steve, heavy meeting day.

The only expression involved is only the virtual column as I didn’t get much further after seeing the field disappear:
Created virtual column with formula CONTEXT(“View”)
Inserted virtual column into Detail View
Inserted Detail View into Dashboard

[Steve]

Please provide more details on “The dropdown has a Data Validity expression with a select statement that uses the virtual context field to filter the dropdown options”.

Please also provide a screenshot of the screen that doesn’t work as you want.

[Daisy_Ramirez]

My guess is it would be something like this:

SELECT(SubMenu[sub_menu_id],AND([Category]=“Report”,[view_name]=[_THISROW].[form])

form = the virtual column
view_name = the view of the form in the reports table

Here’s the form with the last field called “form” at the bottom but it keeps going away after a few seconds.