Excel Add-In - Quickly find the desired value for domain based attribute


  • Excel Add-In for MDS 2012

    To select a value for the attribute, based on domain - search does not work?
    Users must scroll the combobox or exactly know and full enter the code of this attribute?

    For example, to select a value for the domain based attribute "Legal person"
    user cannot quickly find the desired record from the 1000 records ??!!

    from Moscow with Love

    Monday, January 13, 2014 11:36 AM


  • Yes it does not work.

    Yes you are correct.

    In general life is not fair. In the above case the Web UI is a better alternative.

    Unless you could cut and paste from another Excel Row to the one you are setting (ie correct code) or if you are setting a bunch of rows to the same Domain Based code.

    So say for All green pens the buyer is Joe. (Joe is a domain based entity byer). I would filter the pens for green pens all the way at the start and then set all buyers to Joe...

    Also maybe you can set it with a Business Rule and avoid the headache that way.

    Ok this is a big Excel limitation you are 100% correct.

    • Marked as answer by superbluesman Tuesday, January 21, 2014 5:01 AM
    Monday, January 20, 2014 9:39 PM