Application Studio - Value In - Help Needed

Kinetic ERP
,
1

Been following this masterpiece by @hmwillett and we have run into a small issue when trying to pass a value:

We have a button built that calls the DMR Entry screen. We have a grid that shows all DMR’s. I want to select a value in the grid and pass its DMR number to the DMR Entry screen. When trying the context shown in the example:

{"options": {
"valueIn": "{CAST(NonConf_DMRNum AS Integer)}"
}}

we get the following error:

Screenshot 2022-06-03 132637

@hmwillett You said in step one that you had bound a text box to a value. Would you mind helping me do the same but for this grid view?

2

So, I just ran through this example again and it worked the same way with a grid, so long as the grid is bound to a DataView.
Looking at example, a couple things come to mind.

  1. Why are you casting it? It should already be an integer, no?
  2. You need to reference your DataView, so it should be something like this:
{
    "options": {
         "valueIn": {SomeDataView.NonConf_DMRNum}
    }
}

I don’t believe you need quotes around the {SomeDataView.NonConf_DMRNum} since you’re trying to pass an integer.

2 Likes
3

Thanks a ton for getting back! I’ll give those changes a stab. We were attempting a cast because of the error we were receiving “Alpha compare against Numeric Column”. We thought we might be passing a non-numeric value in by accident so we were trying to force it over to a numeric.