# Error when opening Fulfilment Workbench from Dashboard using app-open widget

**URL:** <https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706>\
**Category:** Kinetic ERP\
**Tags:** dashboard, kinetic, customization\
**Created:** [February 21, 2022, 4:47pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706 "2022-02-21T16:47:03Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![J\_I](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@J\_I](https://www.epiusers.help/u/J_I)\
**Post date:** [February 21, 2022, 4:47pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/1 "2022-02-21T16:47:03Z")

</div>

Hi there,

I’m trying to open the Fulfilment Workbench screen from a custom Kinetic dashboard I have created.

I have created an event on button click, which calls the app-open widget.

I’ve set the “value in” parameter to be:

```auto
{
	"OrderNum": "??{%currentDataView%.OrderRel_OrderNum}"
}

```

This displays the correct order number as a string when using dialog widget. (On a side note, the console-write widget doesn’t work for me at all…).

I need this value as an Integer for the FFW screen but whenever I do this, the FFW screen opens but returns the following error:

```auto
Conversion failed when converting the varchar value '[object Object]' to data type int. 

```

I can get the app-open to work if I just enter a literal number, but I want the user to select the row in the dashboard grid and then to use the button.

The JSON editor doesn’t seem to like single quotes at all. The lack of IntelliSense doens’t help much either… ☹

@josecgomez @hmwillett Any ideas from the gurus?

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 2:46pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/2 "2022-02-22T14:46:12Z")

</div>

I would create a function that parses a string to an integer.  
Call that function in your event, pass the string value into the function, then use the converted, returned integer to be your Value In param for the form open.

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 3:35pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/3 "2022-02-22T15:35:05Z")

</div>

You could also do it inline with the row-update widget if you wanted.

 ![image](https://www.epiusers.help/uploads/default/original/3X/6/e/6e44b32cae2b21b2c8346ff180abb658db63605f.png)

---

<div class="post-metadata">

**Author:** ![J\_I](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@J\_I](https://www.epiusers.help/u/J_I)\
**Post date:** [February 22, 2022, 3:47pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/4 "2022-02-22T15:47:30Z")

</div>

Thanks for that, I still get the same conversion error, unless I’m doing something wrong?

![image](https://www.epiusers.help/uploads/default/original/3X/f/b/fbcf209dd764e51dbc5e4d49538e2fd748ccd9c2.png)

The conversion itself works though!

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 3:48pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/5 "2022-02-22T15:48:48Z")

</div>

> [@J\_I](#):
>
> The conversion itself works though!

So, when you run it and look at the DataViews in Dev Tools, it’s showing an integer value for TransView.StringToInt?

---

<div class="post-metadata">

**Author:** ![J\_I](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@J\_I](https://www.epiusers.help/u/J_I)\
**Post date:** [February 22, 2022, 3:53pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/6 "2022-02-22T15:53:37Z")

</div>

Correct!

![image](https://www.epiusers.help/uploads/default/original/3X/e/1/e19713b5126ed6814e2c7bb5d18311cd6b35a2a4.png)

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 3:57pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/7 "2022-02-22T15:57:02Z")

</div>

Remove the quotes from the JSON since it’s now an int:

```auto
{
    "valueIn": {TransView.StringToInt}
}

```

---

<div class="post-metadata">

**Author:** ![J\_I](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@J\_I](https://www.epiusers.help/u/J_I)\
**Post date:** [February 22, 2022, 4:03pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/8 "2022-02-22T16:03:22Z")

</div>

> [@hmwillett](#):
>
> `{TransView.StringToInt}`

I do that and it gets a red squiggly line and says “value must be doublequoted”.

Can you try that and see if you get the same error?

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 4:28pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/9 "2022-02-22T16:28:31Z")

</div>

So, you’re right–it needs the quotes despite the int.

> [@J\_I](#):
>
> `"??{%currentDataView%.OrderRel_OrderNum}"`

I would look into this next.  
Change it from %CurrentDataView% to the actual, bound view of the dashboard panel the user is clicking on.

For instance, if I cycle through my BAQ Panel and display these two fields:  
{NewView.Project\_ProjectID} | {%CurrentDataView%.Project\_ProjectID}

I get this:  
102 | {%CurrentDataView%.Project\_ProjectID}

---

<div class="post-metadata">

**Author:** ![J\_I](https://www.epiusers.help/letter_avatar_proxy/v4/letter/j/c37758/32.png) [@J\_I](https://www.epiusers.help/u/J_I)\
**Post date:** [February 22, 2022, 4:32pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/10 "2022-02-22T16:32:09Z")

</div>

Tried both ways and still no luck!

I actually have raised a support request and I have a Teams meeting with Epicor about this!

I may be a potential bug! I’ll keep you updated!

Thanks for your Kinetics Wizardry (and the help)!

---

<div class="post-metadata">

**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\
**Post date:** [February 22, 2022, 4:33pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/11 "2022-02-22T16:33:58Z")

</div>

If you’re willing, you could package your dashboard, baq, and Kinetic layer into a solution and PM it to me. It would be easier to work with your exact scenario.

---

<div class="post-metadata">

**Author:** ![mjrr15](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@mjrr15](https://www.epiusers.help/u/mjrr15)\
**Post date:** [August 16, 2022, 11:14pm UTC](https://www.epiusers.help/t/error-when-opening-fulfilment-workbench-from-dashboard-using-app-open-widget/87706/12 "2022-08-16T23:14:29Z")

</div>

@J_I Hi, were you able to find a solution for this? Running into the same problem.
