Multiple related fields

[Ryan Cornfoot]

Hi Alex,

Love this solution, very nice and clean.

I’m after some advice, I want to use this for the purpose of typing in an ID number in the first box, then pulling through all employee information into several other boxes (related to that ID Number) – Is this possible? if so how? I guess it has something to do with the Set Fields argument?

Thanks in advance
Ryan

[Ryan Cornfoot]

Or I may just use a lookup/cascading dropdown solution…

[Alexander Bautz]

Sorry for the delay – I sometimes get a pileup in my inbox…

Yes, this is basically what the solution is designed for.

Here is a basic example:

	"applyTo":"EmployeeID",
	"helpText":"Enter the Employee number...",
	"listGuid":"EmployeeInfo",
	"listBaseUrl":"/Sites/MySite",
	"showField":"EmployeeNumber",
	"rowLimit":15,
	"listOptionsOnFocus":false,
	"reValidateOnLoad":false,
	"setFields":[
		{
			"fromFIN":"Departmend",
			"toFIN":"Departmend",
			"skipIfEmpty":false
		},
		{
			"fromFIN":"Manager",
			"toFIN":"Manager",
			"skipIfEmpty":false
		}
	]					
});	

Let me know if you have any questions.

Best regards,
Alexander

[Ryan Cornfoot]

Hi Alex,

This solution works best for me, the load times are minimal and even though I am still getting “500” errors, it works for over 5000 items.

Thanks Again.

[Alexander Bautz]

Thats good. The 500 error is the first query encountering the “throttling threshold”. It then resets and uses another method for querying in chunks of 5000 items.

Alexander

[Author]

Posts