Updating form text fields programmatically

(0) Share

Report

Posted on by Community Member

I need to add some custom validation to some existing AX forms based on some business rules. If the data on the field meets a certain criteria, I need to update the value of the text field programmatically. Since this customization will be applied across many forms, i've created a class which implements the logic and have added a menu button to the forms that invokes the method in my class. The class uses the FormRun.form().design() method to recursively discover all the FormStringControl objects on the form and calls its text() object to retrieve the current value of the control. The issue is that calling the myFormStringControlObject.text([str]) and providing a new value does not change the value of the field. I don't want to update the database directly because I want the user to cancel out without saving. My question is, how do i go about updating a field on a form dynamically without committing it to database first? is there any other method to call after calling the text([str]) method in order for the change to take effect?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Bilal Issa 4,370 on at

Like (0)

Report

Hi,

I suggest you use dataSource, dataField properties on string control , and then update the field not the control, example

formDataSource = myFormStringControlObject.DataSource();

formDataSource.object(fieldId).setValue('Value');

Was this reply helpful? Yes No
KyleLeBarre 747 on at

Like (1)

Report

Yup...I don't think you can change the text on a string control if its bound to a datasource field. Going this route would probably be the best. After setting the value, you'd need to refresh the DS.

You'd probably also want to comment out the super() in the datasource's write() method and then take care of committing to the DB when you close the form(or whatever event should trigger the commit)

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Instead of playing on forms control, I would suggest you to create temporary table containing all your fields required on form and apply the logic on temporary table. This will surely reduce your effort.

Hope this helps you

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

yes, you can update the control if it is bounded field and use Ds.refresh method in your code.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

As I can understand your requirement

you are basically need where you have controls on the form

you enter or populate date in it but it should not update the table automatically

For this purpose controls (Text box) on the form should not be database bound

To have this you should not assign datasource and data field property for the control

now if you use myFormStringControlObject.text([str]) method it will work as per you requirement and will not update the database automatically

now if you implement such kind of feature then you need to have a save button on the form which will basically update the database when it is clicked.

Please verify and update us if this helps you

Was this reply helpful? Yes No