Add and Edit dialogs compute

[mcanavar]

Hi,
How can we easy calculate within the Add and Edit dialogs .
three fields , quantity , unitprice and total .
input in quantity and unit price should update total field ..
Have the normal Forms :
some how I cant get a live update on what is calculated shown in the total field .

Any tips ?

[korchev]

You can check the following thread:

Default calculated value on Add form

Posted this in the wrong thread Decided to describe the process. Create a page property which will contain the form state (current field values). This is needed to perform the calculations easily. [33] Set the Data and UpdateDataOnChange properties of the Form component. We want the page property to be up-to-date with the current form value. [49] Handle the Change event of the form and update the calculated field accordingly. We need Execute JavaScript code actions tha…

Are these achievable?

A few questions before I commit into Radzen Be it achievable in Radzen or out of radzen How to replicate fields in a form? I would like a 2nd field to replicate the first. I.e Mother name and billing name would replicate Mother name unless different then user change to a different name Calculation of 2 field. I.e field A is number of student and field b is ratio which has a formula of total student/number of student from field A In a form with 2 column and 5rows but in row 4th there ar…

[mcanavar]

are hidden form fields updated with submit ?

retrieving data on pageload with getbyId , and using it in the form to give the default value .. does not work yet ? what am I doing wrong ?

[korchev]

What are hidden form fields?

The default generated edit pages use getById and populate the default values. Not sure why this isn't working for you. Did you check for any JS errors?

[mcanavar]

apparently only solution to get it work is , you asking why it is not working .
wrong parameter used .. to initialize the data
Hidden .. == not visible

Thank you

[korchev]

I am sorry but I don't understand your reply. What exactly are you trying to achieve? What have you tried so far and what doesn't work? And did you check the forum threads I have linked in my initial response?

[mcanavar]

I ment, asking the question gave me the solution .. so I'm happy.

[mcanavar]

Turns out updating the form fields was working but wehn subiming it does give me an error:

[korchev]

This error means that OData cannot parse a valid model instance from the request payload. Check for any missing required (non-nullable) properties or wrong type (string instead of number or vice versa).

[mcanavar]

it is the standard add form by using this method of a new formdata does not include all the data ? all fields except for the id ( its a new record ) are nullable .

[mcanavar]

I am pasing the ${event} in the submit
pasing the formData , has same effect

[korchev]

Did you modify the form in any way? Was it working before the modification?

[mcanavar]

if I take away all the modifications mentioned in your suggested post : calculated fields , the form works

[mcanavar]

Default calculated value on Add form

Posted this in the wrong thread Decided to describe the process. Create a page property which will contain the form state (current field values). This is needed to perform the calculations easily. [33] Set the Data and UpdateDataOnChange properties of the Form component. We want the page property to be up-to-date with the current form value. [49] Handle the Change event of the form and update the calculated field accordingly. We need Execute JavaScript code actions tha…

[mcanavar]

formData contains only the to be calculated fields :
{aantal:1.0,eenheidprijs:0.0,bedrag:0.0,totaalregel:0.0}
But the form has more fields

[korchev]

Are you trying to post more fields than the C# model has? This won't work.

[mcanavar]

no , that is not the case:
there is one thing might be it : I have changed a string field to lookup

and ddEenheid has value : ${[{text: 'Korting',value:'korting'},{text:'Bonus',value:'bonus'},{text:'Jaar',value:'jaar'},{text:'Hectare',value:'ha'},{text: 'Meter',value: 'm'},{text: 'Stuks',value: 'stuk'}]}

[mcanavar]

Post: data with 400 code:

[korchev]

I don't know what eeheid is but the default value seems incorrect. Shouldn't it be lowercase "korting"? That's how it is declared in the ddEenheid: [{text: 'Korting',value:'korting'},

[mcanavar]

@korchev

korting

Eenheid: unity
it is a string field in de database accepting varchar(30) , but if the default value is incorrect .. it should display nothing ?