Converting Account's Address1:Country/Region column to lookup

(0) Share

Report

Posted on by psreek

323

Hi,

We are using Address 1 composite column from the Account table in our multi-step form as shown below. We noted that any address entry in this column also automatically creates a row in the dataverse Address table as well. Now, we have created another custom dataverse table called Countries List and we would like to use the Country Name column as the drop-down on the Country/Region attribute in the composite pop-up. Please let me know how this can be achieved as I am unable to convert the Address 1:Country/Region column to lookup.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Saud Ali 812 Super User 2024 Season 1 on at

Like (0)

Report

Hi @prathyoo ,

The Address entity is limited in that one cannot link other entities to it. In other words, there cannot be any relationships created other than what there is OOB. The Address entity is there for creation of addresses on Accounts and Contacts only.

Thanks,
Saud

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
psreek 323 on at

Like (0)

Report

@saudali_25 Thanks. But what is the alternative I have in such a case. The vanilla OOB address entity does not seem to be handy if it cannot be customized.

Was this reply helpful? Yes No
psreek 323 on at

Like (0)

Report

We have found a solution that uses liquid code and custom java script to add a drop down to the standard Address1:Country/Region field -

We added custom javascript to the step in the multistep form -

This retrieves the country list from another dataverse table and then creates a "Select" html element which is then used to replace the original input element. Here is the script -

{% fetchxml get_countries %}
<fetch version="1.0" mapping="logical" returntotalrecordcount="true" distinct="false">
  <entity name="cr9f3_countrieslist">
    <attribute name="cr9f3_countryname" />
<filter type="and">
<condition attribute="statecode" operator="eq" value="0" />
</filter>
  </entity>
</fetch>
{% endfetchxml %}
{% assign country_options = '<select name="ctl00$ContentContainer$WebFormControl_6ac70e3d0e0a4dcd9f4b75e894355b76$EntityFormView$address1_country" id="address1_country" class="form-control picklist " onchange="setIsDirty(this.id);"><option selected="selected" value="" label=" " aria-label="Blank"> </option>' %}
{% for res in get_countries.results.entities %}
{% assign countryname = res.cr9f3_countryname | escape %}
{% assign country_options = country_options | append: '<option value="' | append: countryname | append: '">' |  append: countryname | append: '</option>' %}
{% endfor %}
{% assign country_options = country_options | append: '</select>' %}

$(document).ready(function() {

$('#address1_country').replaceWith('{{country_options}}');

});

Was this reply helpful? Yes No