find selected value within a table and display what column (header) it is in

[Jpaulsen]

Hello, 

Wondering if someone could help me here. I am looking for a formal for my app stateing once a value is selected, then find the column or header it is in the table, then post the name of that column or header.  Thank you in advance. 

Jason

[WillowMobileSys]

Unfortunately, there is not a way to easily "grab" the column header name.

Also, it is better to try to describe what your end goal is rather than HOW you wish to solve it.  Things in AppSheet work differently and there may be a solution that is completely different than you imagined.

Depending on what you are trying to achieve there may be a much simpler solution.  For example,  AppSheet has some "Change...' type columns which can be configured based on which columns changed.  You may be able to tap into these for your goal.

For now I'll make some assumptions that:

• by "value is selected" you mean assigned/updated. 
• You want to know in some way which column(s) names were just changed?

You would have to do this by a brute force method.  For each column you wish to know has changed you would need to physically detect the value was modified and then explicitly assign the column name.  So, let's say you have a column called [Changed Column].  You could assign its App Formula to be something like this:

IFS(
    [_THISROW_BEFORE].[Column1] <> [_THISROW_AFTER].[Column1], "Column1",
    [_THISROW_BEFORE].[Column2] <> [_THISROW_AFTER].[Column2], "Column2",
    ...,
    [_THISROW_BEFORE].[ColumnN] <> [_THISROW_AFTER].[ColumnN], "ColumnN",
)

This currently will detect only that a single column has changed.  If your goal is to capture a LIST of the columns that just changed, then you would need to modify the example expression to test ALL interested columns and build out the list of column names.

I hope this helps!