I’d like a way to change the Display Name of a Form depending on whether it’s opened to Edit existing record or opened to Add a new record
I thought I could do this by checking the value of a field. If data exists then Edit else New
The screenshot shows the Display Name, the field I’d like to check and the Form’s title I’d like to change
I thought a formula in the Display Name field would be easy using and IFS statement but there are no Column Names allowed…
You can’t calculate the Form view’s name from the record that is opened. That’s why you are seeing the alert “This formula is not evaluated in the context of a row, so column values are not available.”.
Thanks for the reply
You’re welcome
What I have been able to do is set a Page_Header that changes depending on Add or New with
this code in the Content field
IF([Level 04 Name]=“” , “New Information”, “Edit Information”)
Good choice!
IF(IN([KeyCol], MyTable[KeyCol]), "Edit", "New")
Hi Steve,
I am modifying the Construction Daily Reports App to suit my use. I am trying to change the display name of the foreman dailies form view to something based on a formula but it says “This formula is not evaluated in the context of a row, so column values are not available.”
How can I have the diaplay name of this view to be the Job name?
Change a Form’s Display Name (Edit or Add) Questions
You can’t calculate the Form view’s name from the record that is opened. That’s why you are seeing the alert “This formula is not evaluated in the context of a row, so column values are not available.”.
Do you think this will work in my case?
[What is the error here? LOOKUP([_THISROW].[A...](https://community.appsheet.com/t/what-is-the-error-here-lookup-thisrow-a/1214/8) Questions
+Steve Coile Sorry Steve. I failed on my attempt. LOOKUP([_THISROW].[AccountHeadId], AccountHeads, AccountHeadId, AccountHeadName) This expression is not working in usersettings.
No solution that involves [_THISROW] will modify the form’s display name. I would encourage you to consider adding a Show column of category Page_Header or Section_Header to the beginning of your form and using it to display what you want. A Show column can make use of the current row’s column values.
Thanks Steve. I ll do that!