James
James

Reputation: 1457

SharePoint unique values from lookup

I have a list with a lookup column that is getting "Created" dates from another list, but I only want the unique date values. Is there a way to get this data or to create a calculated column with unique values?

Upvotes: 2

Views: 2766

Answers (2)

Nat
Nat

Reputation: 14305

A lookup field actually links to a single item, the display value is more a "human readable" value for the link to the items ID value.

You may also get some mileage from a normal text or even date field and using jQuery and SPServices on the edit and new forms in order to provide changes to the form for the user. This avoids doing a code level customisation for the site that a Custom Field would require.

Upvotes: 1

Luis
Luis

Reputation: 6001

Not out of the box I dont think. My best bet is to create a Custom Field type that extends lookup with the functionality you are after.

Upvotes: 0

Related Questions