Adding a custom method to the 'Data Method' property of a form

(0) Share

Report

Posted on by Community Member

Hi,

I am new to the AOT world of methods etc. so apologies if the question is basic or I am going about this in a completely incorrect way..

The scenario

I have created a form extension in AOT on SalesLinesOpenOrders to add a couple of fields.

I need to create a custom field which is the result of Price * Unit.

I don't want to create a view and a calculated column I hoped I could do it quickly in the form.

I add a field to the GRID called Price * Unit Calc as a REAL (I am aware that it may not be best practice to do this on the form)

I now wanted to use the Data Method Property to call a method that calculates P * U and returns the result to the GRID

When I use the dropdown on Data Method I see methods that I can use these are prebuilt for the table, as below 'qtyActivateRemainder'

My Question;

How can I create a custom method 'PriceUnitCalc' that becomes available in that drop down?

Any help appreciated.

Regards

I have the same question (0)

All responses (6)

Answers (2)

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

Great that you were able to get this working. Please mark the helpful answer(s) as Verified.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

Thanks for your help, all works fine after a bit of tinkering around - really good thing to know for simple class method calculations directly updating back to the grid.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

All works great been able to create a nice quick calculation in the class and push it back out to the grid. Once again thank you.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

Thanks so much for your help. I am looking at this to see if I can use it to implement what I want to do. Many thanks.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

Hi D,

About Data method property, you can read this Doc: docs.microsoft.com/.../form-control-properties

As mentioned, you can create form extension and class to add a display method , then use YourClass::method in prperty.

Check this: rahulmsdax.blogspot.com/.../extension-of-classes-tables-and-forms.html

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Adding a custom method to the 'Data Method' property of a form

Hi,

You can create a new display method and can use that on the form. Please check this post for an example of how you can create the display method.

Was this reply helpful? Yes No