What is the error here?
LOOKUP([_THISROW].[AccountHeadId], โAccountHeadsโ, โAccountHeadIdโ, โAccountHeadNameโ)
getting error message as below "error in expression โ[_THISROW].[AccountHeadId]โ : Unable to find column โ_THISROWโ
Any advise pl.
Go to Data > User Settings.
Enable an option row by unchecking the box in its HIDDEN column.
Change the OPTION column value to Account Head.
Edit the option row and configure it to describe a Ref to the AccountHeads table.
Go to UX > Views to the view you want to configure.
For the viewโs display name, use:
=LOOKUP(USERSETTINGS(โAccount Headโ). AccountHeads, AccountHeadId, AccountHeadName)
SAVE the changes.
In your app, go to the โhamburger menuโ in the upper left corner of most views.
Tap Settings.
Change Account Head as desired.
Save the change.
Go to the view you configured Display name for and observe the name displayed.
Youโre probably trying to use the formula in a context in which _THISROW isnโt defined, such as a view Display name.
+Steve Coile You are really great. Exactlyโฆ so how do I achieve this please?
The viewโs display name is not and cannot be aware of the viewโs specific content, unfortunately. What are you trying to display in the view?
+Steve Coile I just want to display the Account name as view nameโฆ If i click an Account it will take me to the entries page/view, which will be named as โAccount Nameโ.
The problem is that the new view isnโt aware of the old view. You need some way to note which account is currently being viewed by the user. The easiest way would be to use the User Settings feature. The user would select an account and save it there, then everything else could refer to the setting using the USERSETTINGS() function.
Thanks lot Mr. Steve for your kind help.
+Steve Coile Sorry Steve. I failed on my attempt.
LOOKUP([_THISROW].[AccountHeadId], AccountHeads, AccountHeadId, AccountHeadName) This expression is not working in usersettings.
Youโre probably trying to use the formula in a context in which _THISROW isnโt defined, such as a view Display name.
+Steve Coile You are really great. Exactlyโฆ so how do I achieve this please?
The viewโs display name is not and cannot be aware of the viewโs specific content, unfortunately. What are you trying to display in the view?
+Steve Coile I just want to display the Account name as view nameโฆ If i click an Account it will take me to the entries page/view, which will be named as โAccount Nameโ.
The problem is that the new view isnโt aware of the old view. You need some way to note which account is currently being viewed by the user. The easiest way would be to use the User Settings feature. The user would select an account and save it there, then everything else could refer to the setting using the USERSETTINGS() function.
Thanks lot Mr. Steve for your kind help.
+Steve Coile Sorry Steve. I failed on my attempt.
LOOKUP([_THISROW].[AccountHeadId], AccountHeads, AccountHeadId, AccountHeadName) This expression is not working in usersettings.
Go to Data > User Settings.
Enable an option row by unchecking the box in its HIDDEN column.
Change the OPTION column value to Account Head.
Edit the option row and configure it to describe a Ref to the AccountHeads table.
Go to UX > Views to the view you want to configure.
For the viewโs display name, use:
=LOOKUP(USERSETTINGS(โAccount Headโ). AccountHeads, AccountHeadId, AccountHeadName)
SAVE the changes.
In your app, go to the โhamburger menuโ in the upper left corner of most views.
Tap Settings.
Change Account Head as desired.
Save the change.
Go to the view you configured Display name for and observe the name displayed.
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |