Background: customer wants more fields to be shown in their record so that the Excel download would include them. One of those fields is 'country', which the CDT saves as an integer value which is matched with a country list in the cloud database (i.e. a value of 1 would be Afghanistan). To display the country properly in the record, I use one of our rules that fetches a datasubset containing the countries and then matches the country Id with the datasubset. It returns a text containing the country name in the user language and display correctly in the Record.
However, what's odd is that when I download the Excel, for every record entry that has a value for country it will only display the name of the 1st Id that was matched. That means if the 1st entry is Germany, all subsequent entries will also be Germany although showing correctly in the online record.
Has anyone experienced this before? What's the best approach to fix this?
Thanks in advance for any help!
Discussion posts and replies are publicly visible