[Rad]

thank you

[Rad]

thank you, this helps.

diff q – is there a way to hide the recycle bin and edit links from the left nav of a List view? I know it can be done for the web pages using the script editor in web part. But couldn’t find any help for a List View.

[Rad]

i tried using spjs.ac.setFieldValue but doesn’t seen to to work

[Rad]

AI is giving below suggestion and says this can’t be achieved only entering where condition. CAML’s <Where> does row-level filtering; it doesn’t support grouping or aggregation (e.g., “the max Date per Name”). That requires
<GroupBy> + <OrderBy> with Collapse=”TRUE”

<View>
<Query>
<OrderBy>
<!– Sort by Name ascending, then Date descending –>
<FieldRef Name=”Name” Ascending=”TRUE” />
<FieldRef Name=”Date” Ascending=”FALSE” />
</OrderBy>
</Query>

<!– Collapse=TRUE returns only the first row per Name group –>
<GroupBy Collapse=”TRUE” GroupLimit=”1000″>
<FieldRef Name=”Name” />
</GroupBy>

<!– Return only the columns you need –>
<ViewFields>
<FieldRef Name=”ID” />
<FieldRef Name=”Name” />
<FieldRef Name=”Date” />
</ViewFields>

<!– Adjust as needed –>
<RowLimit Paged=”TRUE”>5000</RowLimit>
</View>

[Rad]

Hello again, is there a way to add filter to the vLookup? For example, I want to only display the most recent records based on a date field. Below is an example of how data is laid out. I want to pull the most recent record based on name/date and display it in the vLookup. Any help is greatly appreciated. Thank you

ID Name Date
1 John 1/1/2026
1 John 1/20/2026
1 John 1/22/2026
1 Sam 1/4/2026
1 Sam 2/23/2026
1 Peter 1/5/2026

so, final result should yield:
1 John 1/22/2026
1 Doe 2/23/2026
1 Peter 1/5/2026

[Rad]

thank you, that resolved it

[Rad]

Hi, the vLookup grid was working fine until today when i users are seeing the threshold error. What’s causing this and how can I resolve it?

Attachments:

1. 

   2026-01-21_07-43-01.png
   

[Rad]

got it working now. thank you!

[Rad]

ah, its not. it’s in the refresh mode

[Rad]

I am in debug mode and stepping through the code so it’s connected

[Rad]

custom js

[Rad]

for some reason, the logic const row = document.querySelector… returns a null although the element id does exist. See attaced screenshot.

Attachments:

1. 

   2025-11-12_07-34-36.png
   

2. 

   2025-11-12_07-33-17.png
   

[Rad]

Hi again, how do I reference an item in fld1 in a vLookup, corresponding to the item being edited in fld3?

vlookup
fld1 fld2 fld3

[Rad]

hi, is there a limit for vLookup, like how many records can be associated to the parent and or how many can display?

[Rad]

q regarding vLookupIds – if I bulk loading recs, do the LookupIds need to be in the DFFS format or can it be a GUID?

[Author]

Posts