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

Videos library

Product Type:
Filter By Category:

Creating Fabulous Forms for SharePoint External lists using SPARK Forms Builder

This video will show you how you can forms for SharePoint External lists. You can create a complete professional UI, representation and logic for your external databases using only SharePoint and SPARK Forms in a matter of minutes, 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 create a master-details form in 1 minute using SPARK Forms Builder

This video will show you how you can create master-details Forms in SharePoint using SPARK Forms Builder. You can create a complicated (master-details) relational form between two or more lists using just the repeater control and a single rule, easily in 1 minute, and have a fully functioning form in which you can retrieve, add, update and delete the details records without having to write a single line of code. You will be able to do all that using a wizard dialog which will make creating such forms a very easy job to do.


How to use Repeater Control in SPARK Forms Builder

In this video we will learn How to create and design a repeater control in your SharePoint/Office 365 forms to store data and integrated lists together, we will learn how to apply calculations dynamically for these data by adding mathematical formulas on rows, and how to create dynamic rows counter. We will see how you can use the repeater also to retrieve and filter large data and apply the paging feature for it using SPARK Forms Builder.


How to upload Images and files in a form using SharePoint files explorer dialog

In this video you will learn how to allow your form users to select and upload files to your SharePoint farm and link them to your form through the files explorer dialog. This can be done quickly using SPARK Forms Builder, which gives you a great technique to work with files and images and integrate them with your different form's controls such as image and hyperlink controls. in less than 5 minutes without the need to do any manual operation like what you have to do when using InfoPath forms


How to use Web Services Connector control in SPARK Forms Builder

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 use the “Web Connector” control and SPARK Forms internal functions. Integrating your list or library with other external lines of business applications data sources and populating their data to your form has become a very easy task, 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 beneficial for SharePoint environments that require robust integration with external lines of businesses through their web services and APIs.


How to create and use Form Views Using SPARK Forms Builder

This video will show you how to create and work with the form views by using SPARK Forms Builder. Through this feature you will be able to easily create multi-views for your forms, they can use them to create form paging, build wizard forms, providing more data and information and splitting large complex forms and simplifying them for both the user and you as well. you will be able to create a default view for each state of the form [New, Edit, Display] and will be able to customize the top ribbon buttons of the form for each view by hiding or showing the buttons as desired or even remove the entire top ribbon if the designer needs to focus on controlling the form through the custom buttons in the form itself. you will also be able to show the form views in a popup dialog from within another form; this is very efficient for cases in which you want to keep all the information and details in one page. The performance of the form and its views is magnificent, as the data are distributed in the different locations and there is no much consuming for the client/server machines resources. This feature will also allow you to combine multiple lists/forms in one single form and act as a centralized actions page for the site’s users.


How to use XML Connector Control in SPARK Forms Builder

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, you can also create a cascading XML connector controls based on parent-child XML data source structure and filter the returned data based on the selected value of the other control without adding any line of code. 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.


Creating Multilingual Forms Using SPARK Forms Builder

This video will show how SPARK forms support multilingual features for all SharePoint languages with RTL-LTR directions. Just design the form in the primary language, select the other languages you desire, update controls properties, translate the form labels and custom messages accordingly, and you will have multilingual forms up and running in a matter of minutes


SQL Connector control Features and Capabilities

This video will show you how you can add SQL connector control in your form using SPARK Forms Builder for SharePoint and Office 365 and integrate it with external databases directly without the need to use SharePoint external connectivity services, and how to configure the control to retrieve data from external databases and mapping the retrieved data to multiple controls in your form at runtime. You will See how to create a dynamic SQL Query using SQL connector control, 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. 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 GUI according to your selection and configuration, the designer can choose to render the control to be a searchable dialog, drop down list, checkbox list or even a radio buttons list control.


How to use CAML Query Builder in SPARK Forms Builder

This video shows you will learn how to use the CAML Query Builder provided by SPARK Forms Builder. The CAML Query Builder is an intuitive user interface that helps you create CAML Query to retrieve data from SharePoint lists easily and quickly. It includes features to create queries, export queries, copy queries and test the query results on the spot. You can use the CAML Query to retrieve and filter data for special controls like List Grid View, Advanced Repeater, Data Table, Advanced Lookup, and much more. And you can use the CAML Query for rules with special functions like populate Repeater From List, get List item Data, update List Items, delete List Items, etc...


How to use Advanced Lookup Field Control in SPARK Forms Builder

This video shows how you can add and configure the advanced lookup field in SPARK Forms Builder for SharePoint. The Advanced Lookup control is designed to consume data from any list within the local site collection or from other site collections in the web application. This control is the most suitable to display data from large lists because these data will not load during form load so no more delays in opening the forms. The users will be able to search for any data in the source list using a popup search form, and it is worth mentioning that these results are sortable. Also, the selection will be presented in the form as a link to redirect the user to the selected item's view (display) page when clicking on that link.


How to use Searchable lookup Field Control in SPARK Forms Builder

In this video you will learn how to use the lookup control from SPARK Forms in your SharePoint forms, and how you can use it in large data lists to search and filter 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 SPARK Forms Builder

This video shows you how to integrate between different lists within one form by using lookup control and by using one of SPARK Forms Builder's internal functions “get List item Data” Builder for SharePoint 2013/20162/2019/SE and office 365.


How to use Rich Text Editor Control in SPARK Forms Builder

In this video you will learn how to use the Rich Text Editor control in your forms, using SPARK Forms Builder for SharePoint and Office365. The Rich Text Editor control allows users to display formatted text, pictures, and tables on a SharePoint form


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, and 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 specific criteria or rules. The designer will be able to update multiple sets of items or delete them as well based on a CAML query generated results. Also, this video will show you how to display items from other SharePoint lists in a popup dialog easily in order to create multi-functions integrated forms effortlessly.


How to use BarCode Control in SPARK Forms Builder

This video shows you how to create and use the Barcode control in your forms dynamically, using SPARK Forms Builder for SharePoint 2013/2016/2019/SE and office 365. With SPARK Forms you can quickly and easily add standard barcode to SharePoint. The Barcode control is designed to be easy to use and really light. It renders Scalable Vector Graphics (SVG) directly into the form HTML page by specifying encoding barcode standard and text to be encoded. The code can be retrieved from or saved to SharePoint text column or can be generated from the default value property or even can be generated randomly by selecting the random option from within the control’s settings.


How to Working With Button Control in SPARK Forms Builder

In this video you will learn how to work with button controls in SPARK Forms Builder for SharePoint and office 365. We will explain how to create a submit button to save a form, How to create an alert button, and how to create a redirect button. SPARK Forms builder provides a special function for the submit form, this function is ready-to-use to save the form in a list or library without the need to do anything else or to write any code.


How to create a popup dialog in SPARK Forms Builder

This video you will learn how to create a popup dialog in your forms dynamically, using SPARK Forms Builder for SharePoint 2013/2016/2019/SE and office 365 SPARK forms builder has great features and advanced functions that allow you to open a SharePoint list or library within your form by a popup dialog or you can embed a popup dialog form within your form to display specific or informative data.


Building rules without needing to write any code using Script Manager in SPARK Forms

This video will show you how you can create complex rules in SharePoint using SPARK Forms Builder without you need to write any line of code. You can do that using Script Manager feature in SPARK Forms Builder, which uses a wizard dialog to guide you through a step by step method to create your query, filters and map returned data to your form's controls. This great feature will allow designers to build a very complex rules in a matter of a minute instead of spending long hours trying to write and test script codes manually.


SPARK Publishing and Auto Populate features

This video is about the publishing and the auto populate features of SPARK Forms Builder. SPARK works with the SharePoint API's and integrates with them through the best practice techniques provided by Microsoft, so SPARK Forms builder won't affect the SharePoint core.


123456
​​