Add option to save one value in an AC field, but show another in the drop-down list.
Right now I have showField set to a calculated field (full street including prefix and street type), but need to save only part of it to the AC field (street name only). This is so I can set enforceUniqueValues to true and still show all prefix/name/type combinations. But setting showField to the calculated field creates duplicated values in the new calculated string.
Tried using setFields setting to force a different value on the AC field, but it won’t accept.
I’m about to release the new production release of DFFS and plugins and this is supported in the latest version of SPJS-AC. You can have one “showField” and multiple “optionDetailFields” to show in the dropdown. Keep an eye out for it on Monday.
Ah, I see. Unfortunately this isn’t supported as it is the actual value in this field thats used when searching for matches. Could I suggest that you set up a new field for the AC used for the actual search, and then set the “primary” field using the “setFields” array?