Set Value on NewForm from another List on site

[DougMcCourt]

Hi all – is there a way to use spsj-utility to get values from another list on the site based on a key value on the current NewForm? eg the user is on the NewForm for an Event (custom list) and I would like to look up 2 fields on another list, and set the corresponding fields on the NewForm? There really isn’t a parent / child relationship between the two lists. If needed I can have a hidden list view added to the NewForm – that list would show exactly one row for the user, and would have fields MyDivision and MyMarket that Id like to use to set the values of Division and Market on the NewForm On Form Load – thanks!

[Alexander Bautz]

Hi,
I think this post might answer your question: https://spjsblog.com/forums/topic/vlookup-from-new-on-separate-list/#post-12854

Let me know if you need more guidance.

Best regards,
Alexander

[Author]

Posts