Cannot Load Data into MDA Drop Down List via Rules Engine

  • 2
  • Problem
  • Updated 4 months ago
  • Solved
How do you suggest I automatically load data each day into the Multi Select Drop Down List within the MDA if the Rules Engine doesn't support it?

Open to suggestions other than doing it manually...each day...forever...


Photo of Johnny Burtchaell

Johnny Burtchaell, Champion

  • 2,464 Points 2k badge 2x thumb

Posted 7 months ago

  • 2
Photo of Johnny Burtchaell

Johnny Burtchaell, Champion

  • 2,464 Points 2k badge 2x thumb
and exporting the data from a Report that was built off that MDA object won't work, because you cannot import data into a formula field - the mappings won't validate - which means i need to build a duplicate MDA object with fields that aren't formulas and THEN import the data. Way too time consuming, especially when management wants to be able to view these ad-hoc, which means i'm never allowed to leave my desk in case i'm needed to generate the report. 
(Edited)
Photo of Jeffrey Coleman

Jeffrey Coleman, Champion

  • 5,856 Points 5k badge 2x thumb
Adding on to this as it seems like the most relevant post...

I'm trying to load to a single-option dropdown and can't do that either. I have a value being returned by the bionic rule of type String and I can't select the picklist as the target. Obviously I have ensured that the string values match the picklist values and I would expect any mismatch to fail.

Anyone solved for this?
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 2,862 Points 2k badge 2x thumb
Hi,

Multipicklist data type will be supported in Bionic Rules in the upcoming (Winter) release.

Regards,
Jitin
Photo of Jeffrey Coleman

Jeffrey Coleman, Champion

  • 5,856 Points 5k badge 2x thumb
What source data types will be supported/accepted for multi- and single-option dropdowns at that time?
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 2,862 Points 2k badge 2x thumb
Hi Jeff,

Multiselect picklist and picklist data types both will be available in the Rule set up part.

In the actions, following mappings are supported:
1. Picklist to String
2. Multiselect Picklist to String
3. Picklist to Picklist 
4. MultiSelectpicklist to Multiselectpicklist

Regards,
Jitin
Photo of Sai Ram Pulluri

Sai Ram Pulluri, Official Rep

  • 9,308 Points 5k badge 2x thumb
Hi All, You can find all the above enhancements in our Winter Release. Our Winter Release notes is out,please refer this article. Thanks for sharing :-)