web

You’re offline. This is a read only version of the page.

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

260

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

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

MuthukumaranAX 2,903 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Giorgio Bonacorsi 694

#2

André Arnaud de Cal... 646 Super User 2026 Season 1

#3

CP04-islander 337

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans