Dynamics Community Forum Thread Details

How to Implement Boolean Field in Non-Boolean Worksheet Column - AL Development Business Central

Hi,

I'm developing a custom "Vendor Quote Comparison Worksheet" in Dynamics 365 Business Central using AL. This worksheet is to compare vendor quotes side-by-side. I have also attached the layout that we want to use. We need to include a Boolean-like "Approve Vendor" option for each vendor column, but we're facing challenges with the worksheet's column data types.

Key details:
1. The worksheet uses vendors as columns.
2. Each vendor column needs an "Approve Vendor" checkbox.
3. The checkboxes should be mutually exclusive across vendor columns.
4. Standard worksheet columns would typically be non-Boolean data types (e.g., Decimal, Integer, Text).

What's the recommended approach in AL to implement a Boolean field (checkbox) in a worksheet column that doesn't inherently support Boolean data types?
Are there any Worksheet controls in AL that could facilitate this functionality?
How can we ensure the mutual exclusivity of selections across different columns in an AL worksheet context?

We're open to solutions involving worksheet design modifications, underlying table structure changes, or custom AL controls that align with Business Central's architecture and best practices.

Categories:

Purchasing

Development

Quick Links

Leaderboard