Validation to find inbetween values

(0) Share

Report

Posted on by RSX

204

Hi,

I have two fields min, max in a grid. The validation which I require is, the min and max range should be unique, as per below example, if I'm entering any values between 1 to 200 in next row, it should throw error as The range is already selected and cannot be used. It should allow to select the values after 200 only in next row for min field.
How to check the condition for the ranges here and validate?

sl no	Min	Max
1	1	50
2	51	100
3	101	200

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Community user,

You can write x++ logic to validate the data on the validateWrite() function of the table. Then you can check using the entered values is there is an overlap with already existing records.

Was this reply helpful? Yes No
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Hi,

Here is an outline of the approach you can take:

Client-Side Validation (JavaScript):

Attach an event handler to the OnValidate or OnChange event of the Min and Max fields in your form.

In the event handler, retrieve the values of the Min and Max fields for the current row.

Iterate through the grid to check if the entered range overlaps with any existing ranges. If it does, display an error message and prevent saving the record.

Server-Side Validation:

Implement server-side validation to ensure data integrity.

Create a server-side method that checks for overlapping ranges in the data.

Call this method during the save operation, and if it detects an overlap, throw an error that prevents the record from being saved.

Best regards,

Kevin

Was this reply helpful? Yes No
RSX 204 on at

Like (0)

Report

Hi Andre,
Can you help me with the condition how we can check the entered value does not overlap the existing record in x++?

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (1)

Report
Hi RSX,

You can use the next coding on the table, like below (assuming the name of your table is "MyTable":

boolean validateWrite() { MyTable myTableCheck; boolean overlapFound; select firstonly RecId from myTableCheck where myTableCheck.Min >= this.Max && myTableCheck.Max <= this.Max && myTableCheck.RecId != this.RecId; if (myTableCheck.RecId != 0) { overlapFound = true; } select firstonly RecId from myTableCheck where myTableCheck.Min >= this.Min && myTableCheck.Max <= this.Min && myTableCheck.RecId != this.RecId; if (myTableCheck.RecId != 0) { overlapFound = true; } if (overlapFound) { return checkFailed("New values overlap with an existing range. Record can't be inserted."); } return true; }

Was this reply helpful? Yes No

Join the conversation

Community site session details

Validation to find inbetween values

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Validation to find inbetween values

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates