​​​​​​​​​​​​​ SPARK Community Home > Videos
​​​​ ​​

Videos library

Product Type:
Filter By Category:

How To work with SQL Procedures using SPARK Forms Builder

This video will show you how you can execute SQL procedures in SharePoint using SPARK Forms Builder. You can use the SQL connector control to do that easily using the control configuration wizard dialog. you will be able to execute "Post" method for the procedure in order to add, update or delete database records and the "Get" method to retrieve records from database. the SQL Connector allows to creating a dynamic call by connecting the procedure parameters with form's controls and variables.


Creating Fabulous Forms for SharePoint External lists using SPARK Forms Builder

This video will show you how you can create fabulous Forms for SharePoint External lists. You can create a complete professional UI, representation and logics for your external databases using only SharePoint and SPARK Forms in a matter of hours, the external list form accepts all types of controls the same as a regular custom list, which means that you can add a complex and an advanced controls to your form which will reflects their data to the external database, for example you can create forms containing cascading Lookup fields, Richtext, Dropdown, People & Groups Picker, External data picker, SQL/XMl/Web services connectors, Repeaters, Tabs, Checkbox, Toggle Switch, Radio button, D-Signatures, Barcodes, Advanced Lookup …etc. This magnificent capability will enable the designer to create mixed-data forms in which part of its controls are dealing with external databases while the other part is consuming data from the SharePoint lists which means you can do amazing combinations of functionalities in a single form. You can connect with an external HR Database while you are using a cascading for the countries\states\cities from custom lists reside in the SharePoint Farm. The form performance will be high and responsive. One of SPARK Forms great features you need to know about when using them with external lists is enabling the attachments for the external lists which is not an OOTB feature in the SharePoint.


How to get items data from other lists and displaying them in SPARK Forms using List Grid View Control

This video will show you how to add and configure List Grid view control in SPARK Forms Builder for SharePoint. This new control can be configured to consume data from any list within the local site collection or on other site collections in the web application, the user will be able to search for any data in the source list and will allow him to make selections based on items from other lists in the SharePoint farm without the need to write any code or script to do that. The List Grid View control displays the values of a list in a table. The List Grid View control returns the lists items and their columns values based on the selected fields names in the control’s Settings. You can also consume all the selected items’ columns values returned from the search dialog using rules; also you can include a dynamic CAML query to refine the returned data based on the query. The user will be able to group the Grid View rows by simply dragging the "group by column" and dropping it in the group area on the fly.


SQL Connector Advanced Features - Representing Data in different Control Types Using SPARK Forms

This video will show you how you can work with the SQL Connector control advanced features, by binding the query data into 4 types of controls, the SQL connector control will render its UI according to your selection and configuration, the designer can choose to render the control to a searchable dialog, drop down list, checkbox list or even a radio buttons list control. the designer can fill the query parameters dynamically from other controls values in the form. The beauty about this is that you can do this in less than a minute! and create a beautiful, responsive and integrated form in your SharePoint environment.


How to Create a Cascading Lookups Using XML Connector Control in SPARK Forms

This video will show you how to create a cascading XML connector controls based on parent-child XML data source structure using SPARK Forms. You will see how easy it is to do so in just configuring the controls to read the XML data source and filter the returned data based on the selected value of the other control without adding any line of code. This technique will help you connecting with InfoPath XML data source or any XML\API data sources and consuming the data in a user friendly and rapidly way.


How to Add, Update and Delete List Items in Other Lists Using SPARK Forms

This video will show you how to add, update and delete items in other SharePoint lists using SPARK Forms Builder's internal functions. Using these great functions will enable the designers to easily operate on other lists items from within the form itself, the user will be able to store and update the form's data in other lists than the form's list itself or even distribute its data depending on a specific criteria or rules. Also this video will show you how to display a certain panel in a popup dialog easily in order to create a multi-functions integrate forms effortlessly.


How To Create a Dynamic SQL Query Using SQL Connector

This video will show you how you can create a dynamic SQL Query using SQL connector control in your form using SPARK Forms Builder for SharePoint and Office 365, and how you can combine your query with dynamic objects such as form's controls and form's variables and even with static values instantly in order to integrate the data selected from this query with the form’s controls and list columns. In this video you will see how you can load your SQL query data in the search results dialog without the need to use the search box for that, this feature is very important for small size query data in which there is no use for being filtered or searched. The most amazing thing of it is that you can do this in less than two minutes! Professionally and efficiently!


Populating data to your form using the Web Services Connector control

This video will show you how to retrieve data from external data sources and LoB such as HR, Financial, CRM or any external line of business your organization may need to connect with using only the “Web Connector” control and SPARK Forms Builder internal functions. Using this method will enable you to create a centralized, integrated, high performance and reliable forms. Integrating your list or library with other external line of business applications data sources and populating their data to your form has become a very easy task using this technique, you just need to drag/drop the control, configure it to connect with the designated web service using SOAP or REST methods and then build a simple rule to populate the retrieved data to your form’s controls. This control is very helpful for SharePoint environments that require a powerful integration with external line of businesses through their web services and APIs.


Populating external or internal data inside your form using XML Connector control

This video will show you how to retrieve data from external or internal XML data sources such as InfoPath files, stored XML strings in lists columns or from XML files stored anywhere in the web using only the “XML Connector” control and SPARK Forms Builder internal functions. Using this method will enable you to create a centralized, integrated, high performance and reliable forms. Integrating your list or library with other external or internal XML data sources and populating their data to your form has become a very easy task using this technique, you just need to drag the control, configure it and build a simple rule to populate the retrieved data to your form’s controls. This control is very helpful for SharePoint environments that heavily depending on InfoPath forms and need a way to retrieve the important information reside inside these XML data source files.


Populating external data inside your form using Advanced Lookup Control

This video will show you how to retrieve data from another SharePoint list using the “Advanced Lookup” control and SPARK Forms Builder internal functions. Using this method will enable you to create a centralized, integrated, high performance and reliable forms. Integrating your list or library with other external lists inside or outside your current site collection and populating their data to your form has become very easy using this technique, you just need to drag the control, configure it and build a simple rule to populate the retrieved data to your form’s controls.


Populating external data inside your form using External Data Dialog Control

This video will show you how to retrieve data from external data sources such as databases using the “External Data Dialog” control, BCS and SPARK Forms Builder internal functions. Using this method will enable you to create a centralized, integrated, high performance and reliable forms. Integrating your list or library with other external data sources and populating their data to your form has become very easy using this technique, you just need to drag the control, configure it and build a simple rule to populate the retrieved data to your form’s controls.


How to use SQL Connector in SPARK Forms Builder

This video will show you how you can add SQL connector control to your SPARK form and integrate it with external databases directly without the need to use SharePoint BCS, this video will also show you how to configure the control to retrieve data from external databases and mapping the returned selected data to multiple controls in your form at runtime in less than 5 minutes easily, professionally and efficiently.


How to Generate Repeater Rows from external list or DB

This video shows you how you can retrieve external lists or external databases data (items) and represents (generate) them in a repeater (grid view) control at runtime. You can create a repeater control that contains several types of sub-controls and represents the data (rows) easily, professionally and efficiently.


How to use Advanced Lookup Field Control in SPARK Forms Builder

This video shows how the designer can add and configure the new advanced lookup field in SPARK Forms Builder for SharePoint, and consuming data from any list, the user will be able to search for any data in the source list and sort the results ascending and descending as well by clicking on any column header.


How to use Searchable lookup Field Control in SPARK Forms Builder

This video shows the new searchable lookup control in SPARK and how you can use it in large data lists to searching and filtering the data by simply typing in the control and how you can create a searchable data consisting of a combination between two or more columns in the target list.


How to integrate your form with other lists Using SARK Forms Builder

This video shows you how to build and do integration between different lists within one form, dynamically using SPARK Forms Builder for SharePoint 2013/2016 and office 365.


How to Get User Profile Data in SPARK Forms Builder

This educational video,shows you how to retrieve, query and present the user profile data in your forms dynamically in a couple of minutes , using SPARK Forms Builder for SharePoint 2013/2016.


​​