Validate the city field on form

(0) Share

Report

Posted on by Community Member

I have one ListPage form that has field CIty (EDT is LogisticsAddressCity). Now I have to validate that field, so when putting new record that field has to be only city not some random text with no sence.

How can I do that?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Community Member on at

Like (0)

Report

RE: Validate the city field on form

Thanks, I changed the EDT to LogisticsAddressCityName and made a relation.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,959 Super User 2025 Season 2 on at

Like (0)

Report

RE: Validate the city field on form

Hi Dejana,

Have a look at the LogisticsPostalAddress table. It has to fields for managing the cities. One where you can specify text you like, the other one to check if it is a valid city based on the address setup settings.

Verify how it has been done in standard and apply similar logic.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Validate the city field on form

My colleague told my that this might be some property on the field on the table. Because when i create new record new form is opened, there I have the field city and I can save whatever I want but Im supposed to not do that, it should save only existing city because the EDT of the field is LogisticsAddressCity.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 236,275 Most Valuable Professional on at

Like (1)

Report

RE: Validate the city field on form

No, modifiedField() isn't the right place. The corresponding validation method is called validateField(). modifiedField() is called later, when the change was already validated and accepted.

Nevertheless using the standard features for maintaining database consistency sounds like a better than writing custom code, unless there are some additional requirements.

Was this reply helpful? Yes No
Basheer17 2,720 on at

Like (0)

Report

RE: Validate the city field on form

For validations you can use modifiedField of table. But how will you validate if the entered value is valid city name. Or if you have city names stored in some table you can use lookup using table relations.

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 298,959 Super User 2025 Season 2 on at

Like (0)

Report

RE: Validate the city field on form

Hi Dejana,

You haven't told us if you are using a custom or a standard form. Standard AX uses the logic which can be setup on the Address setup form. You can define cities per country and also enable City validation on the parameters tab page.

If it is a customization, try to use the same logic.

Was this reply helpful? Yes No