how to refresh form on clicked method in actionpane

(0) Share

Report

Posted on by vidhya_v

I have a form where I insert data into temp table from form methods (insert in a method on form and calling it in init).

when a button on actionpane is clicked, data updates on few fields of main table.

1.datasource on form is temp table

2.data update on clicked method is on main table

help me how and where to refresh the form ?

currently update is working, but I have to refresh the browser always to get the updated temp table data.

I have the same question (0)

All responses (7)

Answers (0)

GirishS 27,827 Moderator on at

Like (0)

Report

In which method you have added code for inserting data in to temp table?

Thanks,

Girish S.

Was this reply helpful? Yes No
vidhya_v 15 on at

Like (0)

Report

a new method on form and called the method as linkphysicaltableinstance in form init().

Was this reply helpful? Yes No
AhmedRazaAttari 55 on at

Like (1)

Report

Hi Vidhya.

I recently worked on similar task. in my case custom sales order confirmation and sales order invoice buttons and these are the menu item buttons and on click on these button functionality working as expected but the issue we are facing that is we need to refresh the page to change the status of sales order. and then I tried multiple solutions here are two solutions I tried and its working perfectly.

1 - we have a property on form button / menu item button control

"Auto Refresh Data"

2 - Research Form Datasource

formDataSourceName.research(true);

don't forget to pass true parameter to research because research will run form query again and if you not pass true parameter it will display first created record. and if you pass true then it will run query again and back to current selected record

don't forget to mark answer as verified, this will be helpful for other technicals

Thanks,

Ahmed Raza

Was this reply helpful? Yes No
vidhya_v 15 on at

Like (0)

Report

hi Ahmed,

thank you but

I have tried them already.they aren't working in this case.

note: am using temp table and data insertion is on form methods.

not on datasource methods.

Was this reply helpful? Yes No
Arunraj Rajasekar 1,743 on at

Like (0)

Report

Hi,

I'm not sure what your entire business requirement is, but have you considered using an inmemory table instead of Temptable?

is main table the root data source in the form?

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

Have you tried the suggestion given in the below thread?

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/225869/refresh-temp-table-in-form/880928

Thanks,

Girish S.

Was this reply helpful? Yes No
vidhya_v 15 on at

Like (0)

Report

that approach I can't apply here.

this is completely customized requirement.

i resolved it myself.

i actually need to run the form init to get the refreshed data.

Was this reply helpful? Yes No