How To: Kinetic - Updateable UBAQ in a Grid

Experts' Corner
42

Yea i found log. But I dont understand why it finds as an issue since this field isnt updatable. This happens only if I send all rows. Took this line and updated as single and it worked. Even in classic there is no complains.

![CDATA[System.ArgumentException: The input string ‘4500.708’ was not in a correct format.Couldn’t store <4500.708> in Calculated_SumOnhand Column. Expected type is Decimal.

Payload passes these values as decimals 4500.708 not as string ‘4500.708’

1 Like
43

What happens if you go into Data > Grid > Columns, find that column, and then explicitly set the type to be a number?

44

The same (if you mean editor type). I tried to remove all rows from baq and leave 3, server still complains, but about another field which allso says incorect string format, expected decimal :confused: It seams somehow send all rows passes all decimals as a string I guess, but in payload object are passed as decimals without quotes

45

This worked great! Thank you.

I’ve noticed that when I convert an updatable dashboard it adds an update option but when I build one from scratch it does not so I found this post and now have a ghost icon that lets me update :slight_smile:

46

I have followed the instructions and I am able to update my date but when the refresh on the last trigger it brings in the complete baq instead of just the line that matches the sales order I am in. I tried to put information in the properties of the kinetic-baq get widget but then my data doesn’t update. Any suggestions?