Update View Header to Ref Column Name

[Alex3]

Hello,

I am trying to update the name of a form to a virtual column value.

• I set the Virtual Column with a Column Type of 'Show
• I set the Virtual Column Category as ‘Page Header’
• I wrote an expression with the name that I want displayed in the Virtual Column ‘Display Name’

I watched the YouTube instructional video on Column Types and read various posts on the Show type columns

I am receiving the following error message
This formula is not evaluated in the context of a row, so column values are not available.

Any ideas?

Thanks,

Alex

[Steve]

The content you want displayed should be placed in the Show-type column’s Content setting, not in the Display name setting.

[Alex3]

Hello,

I placed the expression in the Content setting. When I try to input the value from the Show column in the ‘Display’ field of the inline form, the error message says the column name cannot be found.

Any ideas?

[Steve]

Alex:

When I try to input the value from the Show column in the ‘Display’ field of the inline form

Why in the world did you do that?

[Alex3]

Ha, ha. Well because I don’t know the steps to update a display name in situations where the form says:
“This formula is not evaluated in the context of a row, so column values are not available.”

I was trying to start from a foundation of the steps I use to update a Display Name with an expression,

Use Case
Set the display name to the specific value of the item the user is drilling down to. The result is to provide more awareness of where the user is in the app.

Perhaps I am using one of the terms incorrectly, in describing my use case

[Marc_Dillon]

You can’t use expressions for Display Name in “collection” Views (Views that show more than 1 record), that reference values that are specific to only 1 record.

It is not clear from your description what kind of View you’re working with though.

[Alex3]

I think this may be an issue of terminology. I will illustrate the use case, step by step

Use Case
View 1 - List of Cars (i.e. Car List)

Action 1 - Click on a specific car in the Car List

Required View Display Name
Name of specific car that was selected from the Car List

Car View Display Expression
[_THISROW].[CarID].[Name]

View Display Result
Name of car that was selected (e.g. Corvette)

• Success

Current View
CarDetail
(the Corvette that was selected in Action 1)

Action 2 - Click on an item in the list of Corvette parts (inline)

Required View Display Name
Corvette

• The name of car that was selected in Action 1 (above)

Car View Display Expression
I am trying to understand how to use the SHOW Column type and Content to set the inline View Display name as the car that was selected.

The expression below is not applicable
[_THISROW].[CarID].[Name]

based on the ‘This formula is not evaluated in the context of a row, so column values are not available.’ prompt above the View Expression box.

Does this clarify the use case and the problem I am trying to solve?

Thanks,

[Marc_Dillon]

Alex:

Does this clarify the use case and the problem I am trying to solve?

Not really, you should includ screenshots.

Alex:

[_THISROW].[CarID].[Name]

Definitely remove the [_THISROW]. portion from that expression.

[Steve]

In a detail view, the view’s Display name (in red, below) cannot be set with data displayed within the view itself.

What you want to do is not possible.

[Marc_Dillon]

Steve:

In a detail view, the view’s Display name (in red, below) cannot be set with data displayed within the view itself.

Sure it can.

Just, perhaps, not in all possible cases. Ex, with quick-edit:

[Steve]

WHOA!

News to me!

[Alex3]

Update

I was able to get it to work.

Steps

1. Create a virtual column in the Car folder. The virtual column is called 'CarHeader’

2. Set the CarHeader column type to SHOW

3. Write the following expression for the CarHeaer App Formula
   CONCATENATE([CarID].[Name]," - ",[CarID].[Year])

4. Set the CarHeader Type Details Category to Page Header

5. Set the CarHeader Type Details Content to the following expression
   CONCATENATE([CarID].[Name]," - ",[CarID].[Year])

6. Set the CarDetails View Display to the following expression
   [CarHeader]

Alex

[Marc_Dillon]

Great!

How about you get rid of the first 5 steps and just put your CONCATENATE() expression directly into Display Name?

[Alex3]

It doesn’t work without the preceding steps. An App expression is required in the SHOW column setup, otherwise it breaks the app

[Alex3]

Also a Virtual Column, with a Show Type, has to be created