Populate Combo box with User Codes in Kinetic Form

Kinetic ERP
,
1

Hi Group,

I am trying to populate combo box through user codes in Kinetic forms. I did successfully achieved this in classic forms but could not accomplish in Kinetic form.

Can someone point me to the right direction.

Thanks

2

Once you have added the combo and bound it in the application studio.
image
Set the Resuable Combo type to ‘UserCodes.UserCodesCombo’ ad the SUb Type to Default.
Then scroll down to the Filter Parameters
image
Set the Filter Params to 'CodeTypeParam =UDCODETYPE

This screen is in slightly different layouts in different versions of Kinetic

5 Likes
3

I’ve done this and it works great. However, I’ve got User Codes marked as Inactive via User Defined Codes Maintenance. These inactive codes are showing up in the drop down. I’m not sure if they did this in 2022.2, don’t remember seeing the inactive codes. But they’re definitely there in 2023.1.

I would think this is a “bug”? If we’re using the UserCodes.UserCodesCombo as the reusable combo, I would think that should show only the Active Codes? Am I wrong?

Does anyone know how to add a filter “Active = True” to this? There’s a filter there but it’s grayed out since I picked a standard combo?

Thanks!
Kevin Simon

1 Like
4

Expand the Combo box section and add this…
image
Then in the Advanced section add a Row Filter
image

3 Likes
5

Worked like a charm! Thanks much!

1 Like
6

While it’s more flexible this way, I would still consider this a bug for the built in controls.

You would expect the built in retriever to take that into consideration.

7

Agreed Kevin - I would consider it a bug. Unfortunately, I just don’t seem to have the patience to work through Tech Support and attempt to get this identified as a bug. Takes too long to first get them to understand the issue, then have to fight them wanting to direct me to their Custom Solutions Group. Getting “fixes” to the tool-sets is always one of those battles you have to pick carefully. Off my soapbox now before it turns into a full blown rant.

8

There is a way to make Row Filter dynamic? like: MyHiddenColumn=Part.MyUDColumn_c

1 Like