How to save an input field from form into database table named PurchParmTable.

(0) Share

Report

Posted on by Community Member

Hi AX Intels,

Can someone help me with this one. I added a field String on Product Receipt named ActualReceiver. Now I want to save the input of that inputfield by the time the user will Click OK. How can I save it to the table? Thankyou in advance.

Regards,

6433.5.png

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Agha SirajulDola 555 on at

Like (1)

Report

Hey there

override the closeOk method of the form, and run update query with new value on table if U want to change based on some condition.

Regards,

Agha

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Agha,

Thanks for the answer but can you also please provide a screenshot or a procedure on how to do that?

Regards,

WH

Was this reply helpful? Yes No
Agha SirajulDola 555 on at

Like (0)

Report

its a default behavior of ax form, any data is input in fields will be saved automatically, unless u wanna change it on run time.

Was this reply helpful? Yes No
Satish kakileti 185 on at

Like (0)

Report

Hello Welyelf,

Do you want Actual receiver value to be saved to PurchParmTable or VendPackingSlipJournal (which will be created after clicking OK) ? Please Clarify..

Thanks,

Satish K.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Welyelf Hisula,

AX is very kind it does the magic of saving data to table itself.

Let me write the steps if you haven't followed these already:

Add a field in table (That's what you have already done.)

Go to your form in AOT, go to datasource node and right click your datasource, click restore.

Now drag Actual Receiver Field and drop on form design.

This is how AX will save the data in table itself. It doesn't save the data if you add any control manually and don't refer it to some Data source field.

In your case it seems it is referring to Data source field and it should work.

What is the problem you are facing?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Satish,

In Class/VendPackingJourCreate i will get the value of ActualReceiver from PurchParmTable and save it to VendPackingSlipJournal.

Thankyou.

Regards,

WH

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi guys,

I will just verified and solved this problem.

Thankyou.

Regards,

Sci

Was this reply helpful? Yes No