Reputation: 1457
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
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
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