Started: 9/20/2018 8:53 AM
Picture: Jim Hidson
Jim Hidson
Multiple external SQL records to be populated into a form

​Hi, I was wondering how could I allows multiple external SQL records to be populated into a form. For instance, can I populate a check box list with multiple journal names from a SQL query?
Is there a way to accomplish this?

Picture: Jim Hidson
  • Jim Hidson
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/jim_MThumb.jpg?t=63627189186" alt="Picture: Jim Hidson" />
Jim Hidson

​Hi, I was wondering how could I allows multiple external SQL records to be populated into a form. For instance, can I populate a check box list with multiple journal names from a SQL query?
Is there a way to accomplish this?

19/20/2018 8:53 AM9/20/2018 8:53 AMNoCodes & Scripts
6.72227682908735
19/20/2018 8:29 AM1
Jim Hidson
Posted: 9/23/2018 5:44 AM
Picture: Jim Hidson
Jim Hidson

You can create and external list connected to that SQL table, and use the function getListItemData() to retrieve the data and bind them to the control ie. (checkbox).

Or you can set the control (checkbox) in a repeater and use the function generateRepeaterRowValues() to get the records from the external list and populate them in the repeater control.

 

​

Picture: Jim Hidson
  • Jim Hidson
http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/jim_MThumb.jpg?t=63627189186" alt="Picture: Jim Hidson" />
Jim Hidson

You can create and external list connected to that SQL table, and use the function getListItemData() to retrieve the data and bind them to the control ie. (checkbox).

Or you can set the control (checkbox) in a repeater and use the function generateRepeaterRowValues() to get the records from the external list and populate them in the repeater control.

 

​

Jim Hidson3609/23/2018 5:44 AM9/23/2018 5:44 AM
9/19/2018 7:49 AM