News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Index for checkbox wit...

Finance | Project Operations, Human Resources, ...

Answered

Index for checkbox with empty value

(0) Share

Report

Report

Posted on by bois0155

250

Hi guys,

I have a table which allows multiple Items, but only one record can be primary.

I created an index which consist in Item and PrimaryItem field. However, the PrimaryItem field is a checkbox, and even when the value is No

it will trigger preventing the user to create a new record. Only one Primary Item field can exist.

How can I accomplish this? Is it validatedWrite() the only way?

Example:

Table

ItemId | Info1 | Info2 | PrimaryItem (Checkbox No::Yes)
Item1 | info | info | Yes

Item 1 | info | info | No

Item 1 | info | info | No

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

MuthukumaranAX 2,901 on at

Like (1)

Report

RE: Index for checkbox with empty value

Hi - adding field to index which has default value (in your scenario No) is not suggested, but it is requirements then you can achieve this through validatewrite method

Thanks
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report

RE: Index for checkbox with empty value

Hi bois0155,

Yes. Modifying validateWrite looks like the only way out here. You can't create an index using any of the fields to achieve this requirement.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,307 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans