Re: How to get a table in a form to be populated with data on form load
Thanks that fixed the problem. - Original Message - From: Anandsagar Sah Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Monday, July 01, 2013 7:36 AM Subject: Re: How to get a table in a form to be populated with data on form load ** Hello Angus, I am not sure If I understand you problem correctly. Do you simply want to refresh the table ? Use Change Field Action in Active link to refresh the table OR Use PERFORM-ACTION-TABLE-REFRESH process. It should be PERFORM-ACTION-TABLE-REFRESH fieldId Note that it is not the same as PERFORM-ACTION-TABLE_REFRESH, which you were using. Thanks Regards, Anandsagar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber Sent: Monday, July 01, 2013 2:41 AM To: arslist@ARSLIST.ORG Subject: How to get a table in a form to be populated with data on form load ** Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to get a table in a form to be populated with data on form load
Hi Angus, Generally the right event to be firing your table refresh on would be Display this runs after the data is loaded into an existing request form prior to it being displayed. The window loaded event is only applicable to new submits or to search windows and also to dialog windows. Rod Harris On 1 July 2013 05:11, Angus Comber arsl...@iteloffice.com wrote: ** ** Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to get a table in a form to be populated with data on form load
Hello Angus, I am not sure If I understand you problem correctly. Do you simply want to refresh the table ? Use Change Field Action in Active link to refresh the table OR Use PERFORM-ACTION-TABLE-REFRESH process. It should be PERFORM-ACTION-TABLE-REFRESH fieldId Note that it is not the same as PERFORM-ACTION-TABLE_REFRESH, which you were using. Thanks Regards, Anandsagar From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber Sent: Monday, July 01, 2013 2:41 AM To: arslist@ARSLIST.ORG Subject: How to get a table in a form to be populated with data on form load ** Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to get a table in a form to be populated with data on form load
Hi, You can achieve this by following two ways. 1. Use 'Change Field' Action in Active Link on Window Load , select 'table name' and 'Check Refresh Tree/Table' option. 2. In Active Link on Window load option, Use run Process 'PERFORM-ACTION-TABLE-REFRESH' followed by 'table field ID' HTH -- Regards, Nilesh Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=nodenode=7583733i=0 [hidden email] || Web Site: http://www.vyomlabs.com www.vyomlabs.com Follow Vyom Labs http://twitter.com/#%21/vyomlabs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Angus Comber Sent: Monday, July 01, 2013 2:41 AM To: arslist@ARSLIST.ORG Subject: How to get a table in a form to be populated with data on form load ** Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
How to get a table in a form to be populated with data on form load
Hi I have a Table on a Form and I have set the columns to be fields in another form - a contacts form with eg name, age, address, etc. When the form is loaded it does not display any of the records. But if I click on one of the column headers it then displays the daya in the table. I tried an active link run process - PERFORM-ACTION-TABLE_REFRESH, execute on Window loaded. I tried an active link with a set fields, field the table Value Default, execute on Window loaded. But neither of those work. What should I be doing to display the data in the table on window loaded? Angus ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years