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

Videos library

Product Type:
Filter By Category:

How to create a dynamic Repeater and DataTable controls in your form in 2 minutes

In this video, you will see how you can create a dynamic Repeater and DataTable controls in your form, and how you can use their internal functions to build a dynamic CAML query and push it to the controls to generate related data. The entire process will only take a couple of minutes and you can generate the dynamic CAML query using the visual CAML Query Builder without the need to write it from scratch. You will see how it’s easy now to build your own dynamic integration data tools and provide a new feature to your users in few minutes.


Using SPARK Workflow Tasks Dashboard Web Part for Office 365

In this video you will see how you can add SPARK Workflow tasks dashboard in your O365 classic and modern design pages, to show to provide your users with informative section about their tasks and a centralized location to access and manage them easily and effectively.


Using DataTable Control To Integrate With Other Lists Using SPARK Forms Builder

In this video you will see how you can utilize the DataTable control’s features to integrate the form with other list, design the table the way you want and configure its menu and style. In this video you will see how you can have a fully integrated control with another list to save and edit its data from within your from in less than 5 minutes and how to control the data presentation using its paging feature. You will also see how you can use its main menu to add, clone, clear, delete print and export its rows’ data and how to use the row’s quick launch menu to do quick operation on a selected row. You will be able to see how you can use the column’s filter to filter a column or multiple columns data and be able to sort these data on the fly at runtime. You can print the control’s data, or export the data to a PDF, Excel, Word and CSV file format.


How To Create a Dynamic DataTable control query

In this video you will see how you can create and design a dynamic DataTable control that retrieves data based on other control value and how you can build a master-child lists integration using this control, design and configure it in less than a minute.


Creating a Tabular Form Using SPARK Forms Builder

SPARK Forms tabular designer is another way to design your forms using table-based form structure where each control can be dragged from the controls’ toolbox and dropped into a cell. The control’s size cannot exceed the cell’s size; you can merge/split cells to control its width size using the cell actions menu at the right to of each cell presented by three dots […] or you can control all table rows sizes by clicking on the View Style [Edit] button in the form’s properties. The main benefit of having a tabular form is that you can hide/show entire rows and sections and having that area shifted up or down to fill the gap in the form without the need to write any line of code or to create a special design in the form to do that.


How To Create Anonymous Forms in SharePoint on premise using SPARK Forms Builder

In this video, you will see how you can create public forms to be accessed by anonymous users outside your SharePoint farm and intranet environment and integrate them with your SharePoint on premise’s lists and libraries using SPARK Forms Builder. You can design forms, enable them to be accessed by external anonymous users without the need to create any guest users or setup special environments to able to do that. You will be able to publish these forms links on your public web site or embed them in its public pages and have all data submitted by the anonymous users stored and managed in your farm without the need to write a single line of code. You will be able to view stored data for anonymous users as well. Build a complete hybrid intranet-internet environment for your customers and users in a couple of minutes.


Using SPARK Forms Viewer Web Part for Office 365

This video will show you how to embed SPARK forms into your SharePoint pages easily using SPARK Forms Web Part, in order to have a fully functioning forms inside it and provide a multiple functionalities to your users from a single page. Also this video will show you how to send emails through your forms by designing an email templates and using the internal sendEmail() function to send them to users and external emails as well. The email templates are fully dynamic and can be configured to get data from the forms controls and variables. By using this functionality you will not need to create workflows to send emails anymore and consume unnecessary resources in your environment.


Using Field Versions Values Activity in SPARK Workflow

In this video you will see how you can retrieve all appended texts in a version enabled column using SPARK Workflow Field Versions Values Activity. You can retrieve all appended values, or a specified number of values, specify how the values would be presented as plan text or HTML, show editor name and date ..etc.


Using the Forms Manager Feature in SPARK Forms Builder

In this video you will see how to use SPARK Forms Manager. SPARK Forms Manager is a central secured section provided by SPARK Forms Builder solution in which the site administrator can manage all site’s forms from a single page. You can access it by clicking on “SPARK Forms Manager” site’s menu item. SPARK Forms Manager enables you to perform the following operations: Delete Forms permanently from your sites, publish/unpublish forms, lock forms for being edited by other users/designers, bulk backup, edit forms, search for forms, clear forms versions history and export forms


How to Apply Paging to Large Data Repeaters Using SPARK Forms Builder

In this video you will see how you can configure and design an Advanced Repeater control to handle large data from other lists using paging feature in less than two minutes on SPARK Reports Builder. You will see how you can configure this control internal properties to handle large data through paging, which reduce loading time significantly and provide a neat user friendly interface for users to navigate through repeater pages fast without the need to load the entire form page.


How to build formulas in your report using the Formula control in SPARK Reports Builder

In this video you will see how you can create, configure and design a Formula expression control and have it ready in your report in less than two minutes, using SPARK Reports Builder. You will see how you can concatenate text, execute mathematical operations, and include dynamic functions and controls to be reflected in the report using this amazing control.


How to use Expression controls in your report using SPARK Reports Builder

In this video you will see how you can create, configure and design Sum, A vg, Min, Max and Count expression controls and have them ready in your report in less than two minutes, using SPARK Reports Builder.


How to use Radial and Linear Gauges in your report using SPARK Reports Builder

In this video you will see how you can create, configure and design Radial and Linear gauges to reflect your query data visually in two minutes.


How to work with Line and Bar Charts in SPARK Reports Builder

In this video you will see how you can create, configure and design Line and Bar charts to reflect your query data visually. Also, you will see how you can reflect aggregated data “Grouped By” on these types of charts easily in two minutes.


How to work with Pie and Doughnut Charts in SPARK Reports Builder

In this video you will see how you can create, configure and design Pie and Doughnut charts to reflect your query data visually. Also, you will see how you can reflect aggregated data “Grouped By” on these types of charts easily in two minutes.


How to dynamically highlight cells, hide or show columns and rows in SAPRK Reports Builder

In this video you will see how you can dynamically highlight reports cells, hide/show entire columns and hide/show entire data rows using SPARK Reports Builder rules.


How to create a dynamic report table footer using SPARK Reports Builder

In this video you will see how you can create and manage report’s table footers and add dynamic formulas to its cells using SPARK Reports Builder for SharePoint. You will see how you can calculate entire column’s total and the sub totals of aggregated “Grouped By” query reports, easily in few minutes without the need to write an line of code.


Working with Calculated Columns using SPARK Reports Builder

In this video, you will see how you can create calculated columns to generate results based on formula from other columns on the same data row using SAPRK Reports Builder. You will see how you can do an arithmetic operations using data from other columns on the same data row and how to create a dynamic hyperlinks to open the display items page dynamically based on the item column ID. In addition, you will see how you can create a sub report and link it to the parent data rows using dynamic hyperlink calculated column. There are no limits to what you can do using this fantastic type of column and how you can harness it to provide great solutions for your users.


Create Ad-Hoc query reports using SPARK Reports Builder

In this video you will see how to create Ad-Hoc query reports using SPARK Reports Builder. The Ad-Hoc Query feature allow designers to create a rich, dynamic and interactive form to allow passing dynamic query values to the reports based on users interactions. Ad-Hoc Form designer has many great controls to design an outstanding interface for users to retrieve list values for domestic and external resources, and to specify reports queries’ parameters. In addition, you will see how to bind the form with a dynamic “Query Filter. The Query Builder has a Filter Manager feature which is a visual user interface feature that helps reports designers building simple/complex and static/dynamic filters for the query. The report’s designer will be able to filter the query based on static value, Available controls in the Ad-Hoc Query Form, or columns from selected designed query entities. The filter will retrieve the filter values on the report loads or the user clicks the “Run Report” button at the report’s top ribbon at runtime.


Embed reports and dashboards into your SharePoint pages using SPARK Reports Builder

In this video you will see how you can create dashboard reports, charts and embed them into a SharePoint page using SPARK Reports Builder and SPARK Reports Viewer web part.


123456
​​