News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Create field with func...

Dynamics 365 general forum

Create field with functionality

(0) Share

Report

Report

Posted on by Kahspot

159

Hello,

I would like create a new numerical field called “Odometer Reading”.

If function so that mileage cannot be less than or the same as previously recorded odometer value.

What would be the best way to implement this requirement ?

Thanks.

All responses Img

All responses (2)

Answers Img

Answers (0)

Kahspot 159 on at

Like (0)

Report

RE: Create field with functionality

Thanks.
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (0)

Report
RE: Create field with functionality

Hi Kahspot,

This is one method of implementing this functionality.

Create a Whole Number field called "Odometer Reading", and a Whole Number field called "Previous Odometer Value" with a default value of 0.

Place the "Odometer Reading" field on a form.

Create a JavaScript file that runs On Change of the "Odometer Reading" field. If the new value for the "Odometer Reading" field is less than or equal to the value in the "Previous Odometer Value" field, then throw an error. If the new value for the "Odometer Reading" field is greater than the value in the "Previous Odometer Value" field, set the "Previous Odometer Value" field to the same value as the new value for the "Odometer Reading" field.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans