Crow Canyon Software Forum

Crow Canyon User Community ForumNITRO Studio: Other NITRO QuestionsAccessing an additional lookup co …

Please or Register to create posts and topics.

Accessing an additional lookup column with in Customize list view JavaScript Code.

#1 · July 21, 2025, 7:16 pm

The list that I am displaying has a lookup column to another list. This lookup column, I have identified a couple of other columns that I display in the list. I want to modify one of the additional columns. I was using scriptManager.UpdateListItemsValues but have not figured out the correct syntax to access these columns.

var oListItemsEnum = listItems.getEnumerator();
while (oListItemsEnum.moveNext())
{
var oListItem = oListItemsEnum.get_current();
var Id = oListItem.get_id();
var Region = oListItem.get_item("StaffName:Region");

if(Region == "SB Region"){
oListItem.set_item("StaffName:Region", "Southern");
}

StaffName is the lookup column name to the other list, Region is the additional column that is being displayed on the list. If the Region is "SB Region", I want to replace it with "Southern Region"

#2 · July 22, 2025, 1:01 pm

Hi Archie,

Could you please check whether the 'Is Large List' option is enabled in your NITRO List view settings?

To do this:

Open the NITRO List View Settings
Edit each of the configured views (as shown in the attachment)
Check if the 'Is Large List' option is enabled for any of the views

We’ll need to configure a different script depending on whether the 'Is Large List' option is enabled.

Uploaded files:

#3 · July 22, 2025, 4:17 pm

No the large list is not selected. Thanks

#4 · July 23, 2025, 11:34 am

Hi Archie,

We have prepared a script to be used in the NITRO List View settings to modify the display value of the additional lookup column ‘StaffName:Region’, replacing the value “SB Region” with “Southern Region”

Please follow the steps below to configure the script:

Get the internal name of the additional lookup column ‘StaffName:Region’, we will need this when configuring the script
1. Navigate to the list settings
2. Choose the column ‘StaffName:Region’ and click on it
3. Copy the Internal name of the column from the URL as shown in image 1
Go to the NITRO List view settings -> Advanced settings tab -> Customize List View JavaScript Code
Replace and paste the entire script into the ‘Customize List View JavaScript Code’ section from the pdf file
Update the script as shown in image 2, then save the settings.
Refresh the page to see the changes.

Uploaded files:

ScriptA.pdf

#5 · July 24, 2025, 11:04 am

Works like a charm. !!!! Thank you.