How To Get Values from Grid on Form By Click A Button

(1) Share

Report

Posted on by Community Member Microsoft Employee

Hi All..

I make a form and use CustInvoiceTrans table as the datasource of my grid.

When I open :

I'm in order to insert data from selection data on that form's grid into my new table (sjb_kompensasi_harga_table) when I click "Post".

The relation between both tables is invoiceId.

How to insert the data from the grid on form into sjb_kompensasi_harga_table?

Thank you..

*This post is locked for comments

All responses (9)

Answers (2)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

How to display current/selected grid data onclick the View Data button
Suggested answer

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Yes it is still applicable. I would say have a look on SalesQuotationUpdate class this is used for multiple scenarios. You can check the implementation from Sales and Marketing | All Quotations | Follow up | Cancel
Miguel Zuniga 270 on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Thanks Sukrut and Martin.
Martin Dráb 231,321 Most Valuable Professional on at

Like (2)

Report

RE: How To Get Values from Grid on Form By Click A Button

By the way, you can simplify the code with MultiSelectionHelper class.
Miguel Zuniga 270 on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Hi Faisal Fareed.

I am working on Dynamics A7/D365 and I need the same logic. Is this logic applicable to AX7/D365?
Community Member Microsoft Employee on at

Like (1)

Report

RE: How To Get Values from Grid on Form By Click A Button

Mr. Fareed,

Great, It worked.

Thank you a lot for the solution.

Best Regards,

Rizki
Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Go to button properties and change the multiSelect property to YES.
Community Member Microsoft Employee on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Hi Mr. Fareed.

I tried your example to my clicked void. And It worked.

But the button is disabled when i choose multiple rows selection.

How can i insert multiple rows selection?

Thank You.

Best Regards,

Rizki
Verified answer

Faisal Fareed 10,794 User Group Leader on at

Like (0)

Report

RE: How To Get Values from Grid on Form By Click A Button

Hi Rizki,

There are many possible ways to retrieve records from grid and use it for any purpose. For your requirement could you please describe it in more details.

A sample form screenshot for you to guide you how can get current record value or selected record value from grid.

On button click you can check either you are retrieving correct values or not.

void clicked()
{
CustInvoiceTrans localCustInvoiceTarns;

super();

//info(CustInvoiceTrans.InvoiceId); // this is print the selected record Invoice Id in info.

//get the first selected record of the datasource and loop through all of the selected records

// this loop will go through all selected records from your grid and you can then use these values
for(localCustInvoiceTarns = CustInvoiceTrans_DS.getFirst(true) ? CustInvoiceTrans_DS.getFirst(true) : CustInvoiceTrans_DS.cursor(); localCustInvoiceTarns; localCustInvoiceTarns = CustInvoiceTrans_DS.getNext())
{
info(localCustInvoiceTarns.InvoiceId);
}
}

You can also share your email with me I have created a small prototype for you but sorry I cannot attach .xpo file here.