Using a column name as a value in my "Show If" constraint

[Victor_Medina]

Hello,

I am trying to build a planning function into an app, and have a table with columns named for each of my products. I would like to only show the column if the relevant product is selected, but don’t want to have to type a new formula in my show if contraint for every row. I’m thinking I’d like to copy and paste a standard formula a bit like:

Show if In(column name,[Planned Items])

Can this be done?

[Steve]

Victor_Medina:

and have a table with columns named for each of my products

This is generally not a good design, if simply because it makes doing what you want in this post difficult.

[Victor_Medina]

I’m aware - client is constraining this…