Discussions List

Reply

Jim Hidson

Updated User Manual for SPARK Forms Builder

you can download the updated final edition of SPARK Forms Builder user manual form the following link: SPARK User Manual 1.6.11.17

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 download the updated final edition of SPARK Forms Builder user manual form the following link: SPARK User Manual 1.6.11.17

9/20/2018 7:54 AM

6.78718195205129

9/19/2018 7:49 AM

Jim Hidson

Nancy Castelo

Started: 9/20/2018 7:55 AM

Reply

Jim Hidson

SPARK New Release ver. 1.6.11.17

Today a new release of SPARK Forms Builder has been released, the new version is 1.6.11.17.
To view all the enhancemnts and fixes you can visit the following link: SPARK Version KB1.6.11.17

Jim Hidson

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

Jim Hidson

Today a new release of SPARK Forms Builder has been released, the new version is 1.6.11.17.
To view all the enhancemnts and fixes you can visit the following link: SPARK Version KB1.6.11.17

9/20/2018 7:55 AM

6.787229405755

9/19/2018 7:49 AM

Jim Hidson

Nancy Castelo

Started: 9/20/2018 7:56 AM

Reply

Jim Hidson

Installation Guide

You can download the installation guide from this address: SPARK Installation Guide

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 download the installation guide from this address: SPARK Installation Guide

9/20/2018 7:56 AM

Setup & Installation

6.24319087529361

9/19/2018 7:49 AM

Nancy Castelo

Jim Hidson

Started: 9/20/2018 7:58 AM

Reply

Nancy Castelo

SPARK Editions

SPARK Forms Bjuilder has a three editions:

WorkGroup Edition
Standard Edition
Enterprise Edition

for more information about each edition, features and comparison; visit this link: SPARK Edition

Nancy Castelo

http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/nancy_MThumb.jpg?t=63623639746" alt="Picture: Nancy Castelo" />

Nancy Castelo

SPARK Forms Bjuilder has a three editions:

WorkGroup Edition
Standard Edition
Enterprise Edition

for more information about each edition, features and comparison; visit this link: SPARK Edition

9/20/2018 7:58 AM

7.02141272752911

9/20/2018 7:58 AM

Jim Hidson

Started: 9/20/2018 8:00 AM

Reply

Rafeef Sabri

How to open in View mode versus Edit

From SharePoint list view, whether you choose "View Item" or "Edit Item", the form opens in what can be described as Edit Mode. Is there a way to behave like the regular SharePoint form whereby there is a difference between Editing and Viewing? Like in View mode the form opens and all controls are disabled unless Edit is clicked in Ribbon?

Rafeef Sabri

http://dmas:80/my/User%2520Photos/Profile%2520Pictures/ceo_MThumb.jpg?t=63603072055" alt="Picture: Rafeef Sabri" />

Rafeef Sabri

9/20/2018 8:00 AM

6.89654112055044

9/20/2018 8:00 AM

Jim Hidson

Nancy Castelo

Started: 9/20/2018 8:04 AM

Reply

Jim Hidson

How To Hide Form Ribbon?

To show ribbon or hide ribbon you can add this parameter to the url:

showribbon=0 [to hide it]

showribbon=1 [to show it]

Jim Hidson

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

Jim Hidson

To show ribbon or hide ribbon you can add this parameter to the url:

showribbon=0 [to hide it]

showribbon=1 [to show it]

9/20/2018 8:04 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:05 AM

Reply

Jim Hidson

How Get a User Profile Data?

to get a user profile data, you can add a rule of type action on the control you want to query data throgh it (TextBox1), and select the event to be (onChange), then add the following script in the actiob area:

var array=getUserProfileData(TextBox1,['AccountName', 'DisplayName','FirstName','LastName','CellPhone']);
setValue(TextBox1,array[0]);
setValue(TextBox2,array[1]);
setValue(TextBox3,array[2]);
setValue(TextBox4,array[3]);
setValue(TextBox5,array[4]);

preview the form and type in the textbox Domain\Username you want to get its data and see how SPARK populates the data in the textboxes mentioned in the code.

Note: if you want to get the data for the current user use the following code:

var array=getCurrentUserProfileData(['AccountName', 'DisplayName','FirstName','LastName','CellPhone']);

setValue(TextBox1,array[0]);

setValue(TextBox2,array[1]);

setValue(TextBox3,array[2]);

setValue(TextBox4,array[3]);

setValue(TextBox5,array[4]);

Jim Hidson

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

Jim Hidson

preview the form and type in the textbox Domain\Username you want to get its data and see how SPARK populates the data in the textboxes mentioned in the code.

Note: if you want to get the data for the current user use the following code:

var array=getCurrentUserProfileData(['AccountName', 'DisplayName','FirstName','LastName','CellPhone']);

setValue(TextBox1,array[0]);

setValue(TextBox2,array[1]);

setValue(TextBox3,array[2]);

setValue(TextBox4,array[3]);

setValue(TextBox5,array[4]);

9/20/2018 8:05 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:09 AM

Reply

Jim Hidson

How To GET Data From Other Lists?

to get data from other lists within your site or from other site collection, you can add a rule of type action on the control you want to query data throgh it (TextBox1), and select the event to be (onChange), then add the following script in the actiob area:

var array = getListItemData('/SiteUrl/','ListName','<Query><Where><Eq><FieldRef Name=\'EmpNo\'/><Value Type=\'Text\'>'+getValue(TextBox1)+'</Value></Eq></Where></Query>',['EmpName','Title','Jobtitle','UserName','Country']);

setValue(TextBox2,array[0]);

setValue(TextBox3,array[1]);

setValue(TextBox4,array[2]);

setValue(TextBox5,array[3]);

setValue(TextBox6,array[4]);

preview the form and type in the textbox the value you want to query the data by and see how SPARK populates the data in the textboxes mentioned in the code.

Jim Hidson

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

Jim Hidson

setValue(TextBox2,array[0]);

setValue(TextBox3,array[1]);

setValue(TextBox4,array[2]);

setValue(TextBox5,array[3]);

setValue(TextBox6,array[4]);

preview the form and type in the textbox the value you want to query the data by and see how SPARK populates the data in the textboxes mentioned in the code.

9/20/2018 8:09 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:09 AM

Reply

Jim Hidson

Display The row number of repeater

To display The row number of repeater: you can add the following code inside a rule of type actions in the repeater control:

setValue(Label1,getRepeaterRow());//Label1 must be inside the repeater.

Output:

Label1(first row): 0

Label1(Second row): 1 … etc.

//When remove any row all the order will be updated.

Jim Hidson

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

Jim Hidson

To display The row number of repeater: you can add the following code inside a rule of type actions in the repeater control:

setValue(Label1,getRepeaterRow());//Label1 must be inside the repeater.

Output:

Label1(first row): 0

Label1(Second row): 1 … etc.

//When remove any row all the order will be updated.

9/20/2018 8:09 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:10 AM

Reply

Jim Hidson

Coding With Dates

1. Set Current DateTime:

var date = new Date();

var time = date.toLocaleTimeString();

setValue(TextBox1,time)

output: 2/13/2017 4:09:52 PM

2. Change DateTime Format:

var d = new Date();

setValue(TextBox1,d.toLocaleDateString())

output: 2/13/2017

Jim Hidson

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

Jim Hidson

1. Set Current DateTime:

var date = new Date();

var time = date.toLocaleTimeString();

setValue(TextBox1,time)

output: 2/13/2017 4:09:52 PM

2. Change DateTime Format:

var d = new Date();

setValue(TextBox1,d.toLocaleDateString())

output: 2/13/2017

9/20/2018 8:10 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:12 AM

Reply

Rafeef Sabri

Please describe how to enable AutoPopulate and Form Variables in Designer ?

Please describe how to enable AutoPopulate and Form Variables in Designer?

Rafeef Sabri

http://dmas:80/my/User%2520Photos/Profile%2520Pictures/ceo_MThumb.jpg?t=63603072055" alt="Picture: Rafeef Sabri" />

Rafeef Sabri

Please describe how to enable AutoPopulate and Form Variables in Designer?

9/20/2018 8:12 AM

6.72085495408735

9/20/2018 8:00 AM

Jim Hidson

Edited: 9/20/2018 8:14 AM

Reply

Jim Hidson

How to Hide Ribbon buttons?

If you need to hide buttons in the runtime mode of the form, you can do that using the following code:

$(document.getElementById('Ribbon_ID')).hide();

and placing this code in an action rule on any control, selecting the event (onLoad).

Ribbon_ID List:

Attachments Button: Ribbon.FTTab.OpeartionsGrp.AttachmentsBtn-Large

Close Button: Ribbon.FTTab.OpeartionsGrp.CloseBtn-Large

Reload Button: Ribbon.FTTab.OpeartionsGrp.ReloadBtn-Large

Submit Button: Ribbon.FTTab.OpeartionsGrp.SaveFlyoutAnchor-Large

New Form Button: Ribbon.FTTab.OpeartionsGrp.NewFormBtn-Large

Send Message Button: Ribbon.FTTab.OpeartionsGrp.MessageBtn-Large

Print Preview Button: Ribbon.FTTab.RevAndPrintGrp.PrintPreviewBtn-Large

Also you can set the condition in the rule to hide these button depending on the form state (View, New, Edit) using the following condition code:

getFormQueryString('type') == 'Disp'

getFormQueryString('type') == 'New'

getFormQueryString('type') == 'Edit'

Jim Hidson

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

Jim Hidson

If you need to hide buttons in the runtime mode of the form, you can do that using the following code:

$(document.getElementById('Ribbon_ID')).hide();

and placing this code in an action rule on any control, selecting the event (onLoad).

Ribbon_ID List:

Attachments Button: Ribbon.FTTab.OpeartionsGrp.AttachmentsBtn-Large

Close Button: Ribbon.FTTab.OpeartionsGrp.CloseBtn-Large

Reload Button: Ribbon.FTTab.OpeartionsGrp.ReloadBtn-Large

Submit Button: Ribbon.FTTab.OpeartionsGrp.SaveFlyoutAnchor-Large

New Form Button: Ribbon.FTTab.OpeartionsGrp.NewFormBtn-Large

Send Message Button: Ribbon.FTTab.OpeartionsGrp.MessageBtn-Large

Print Preview Button: Ribbon.FTTab.RevAndPrintGrp.PrintPreviewBtn-Large

Also you can set the condition in the rule to hide these button depending on the form state (View, New, Edit) using the following condition code:

getFormQueryString('type') == 'Disp'

getFormQueryString('type') == 'New'

getFormQueryString('type') == 'Edit'

9/20/2018 8:13 AM

9/20/2018 8:14 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:15 AM

Reply

Jim Hidson

How to Add Custom Save button in the from?

In order to add a custom save button to your form do the follwoing:

1- add a button control to your form.

2- add a rule to the button with type action with onLoad event.

3- If you want to hide the top ribbon Submit button when you open the form in the run mode: Select the View or Views that you want to hide the Submit button by clicking on an empty space insdie the form or by clicking on + sign in the Form Property pane and Under Show Ribbon Button, switch Submit to OFF.

4- add the folowing code to the rule: onClick(Button1,saveForm());

where is Button1 is your button ID.

Jim Hidson

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

Jim Hidson

In order to add a custom save button to your form do the follwoing:

1- add a button control to your form.

2- add a rule to the button with type action with onLoad event.

4- add the folowing code to the rule: onClick(Button1,saveForm());

where is Button1 is your button ID.

9/20/2018 8:15 AM

9/19/2018 7:49 AM

Started: 9/20/2018 8:22 AM

Reply

Jim Hidson

Displaying a Popup Dialog

The designer can display pages in popup dialogs using the Button Control by adding new Rule and then add the following script in an Action area in the Rule Manager.

Example:

function openDilaog() {

var options = { url: _spPageContextInfo.webServerRelativeUrl + '/SiteCollection/Site/List/', title: 'Dialog Title', allowMaximize: true, showClose: true, width: 1000, height: 600 };

SP.SOD.execute('sp.ui.dialog.js', 'SP.UI.ModalDialog.showModalDialog', options);

}

onClick(Button1,openDilaog());

Jim Hidson

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

Jim Hidson

The designer can display pages in popup dialogs using the Button Control by adding new Rule and then add the following script in an Action area in the Rule Manager.

Example:

function openDilaog() {

var options = { url: _spPageContextInfo.webServerRelativeUrl + '/SiteCollection/Site/List/', title: 'Dialog Title', allowMaximize: true, showClose: true, width: 1000, height: 600 };

SP.SOD.execute('sp.ui.dialog.js', 'SP.UI.ModalDialog.showModalDialog', options);

}

onClick(Button1,openDilaog());

9/20/2018 8:22 AM

5.94305034722222

9/19/2018 7:49 AM

Nancy Castelo

Started: 9/20/2018 8:27 AM

Reply

Nancy Castelo

Sometimes your browser warns you when downloading SPARK's setup.exe file

This behavior is because browsers doesn't link compressed files having setup executable files within. and the setup.exe file is a self executable compressed package and this is a normal behaviour.

Try to set www.itlaq.com in your trusted zone before downloading the file and try again.

(The Installation Package contains no viruses or malwares, and was produced in a safe environment and secure network).

Nancy Castelo

http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/nancy_MThumb.jpg?t=63623639746" alt="Picture: Nancy Castelo" />

Nancy Castelo

This behavior is because browsers doesn't link compressed files having setup executable files within. and the setup.exe file is a self executable compressed package and this is a normal behaviour.

Try to set www.itlaq.com in your trusted zone before downloading the file and try again.

(The Installation Package contains no viruses or malwares, and was produced in a safe environment and secure network).

9/20/2018 8:27 AM

Setup & Installation

5.94323958333333

9/20/2018 7:58 AM

Mike Odeh

Edited: 9/23/2018 4:44 AM

Reply

System Account

Does SPARK add any special third party codes or extra layer on my sharepoint environment?

Does SPARK add any special third party codes or extra layer on my sharepoint environment? and does this affect the immigration from SharePoint on premise to office 365?

Jim Hidson

/_layouts/15/images/person.gif" alt="Picture Placeholder: System Account" />

System Account

Does SPARK add any special third party codes or extra layer on my sharepoint environment? and does this affect the immigration from SharePoint on premise to office 365?

9/20/2018 8:29 AM

9/23/2018 4:44 AM

6.78839144279203

9/20/2018 8:29 AM

Jim Hidson

Edited: 9/23/2018 5:19 AM

Reply

System Account

What if I purchased SPARK for on premise and decided to immigrate to office 365?

(no text)

Jim Hidson

/_layouts/15/images/person.gif" alt="Picture Placeholder: System Account" />

System Account

9/20/2018 8:30 AM

9/23/2018 5:19 AM

6.78844063260685

9/20/2018 8:29 AM

Nancy Castelo

Started: 9/20/2018 8:38 AM

Reply

Jim Hidson

A new version of SPARK has been released (2.0.26.45)

We are pleased to inform you that a new version of SPARK forms builder (2.0.26.45) has been released, which contains many improvements and hotfixes such as:

Major enhancements on the rules manager.
Major enhancements on the design workspace tools.
Major enhancements on current built-in functions.
Forms templates to choose from.
Major enhancements on the rule manager.
Performance enhancements.
Enhancements on controls and controls mapping.
Fixing reported issues and bugs.

And more …

Please make sure you have downloaded the latest version of SPARK forms builder (2.0.26.45), by clicking on the "About" button on the top ribbon of the workspace editor, also you can read about these improvements and fixes we have applied on the current version by clicking on the following link: SPARK Versions

If you already have the older version of SPARK then we advise you to run the old setup and remove SPARK from your environment entirely before running the new setup again, this is to avoid any issue or file duplication may occur while deploying the new release.

We also advise you to download the updated user manual for this release which contains all the information about all the new features from the following link as well: SPARK Forms Builder User Manual

Enjoy SPARK New Features!!!

Jim Hidson

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

Jim Hidson

We are pleased to inform you that a new version of SPARK forms builder (2.0.26.45) has been released, which contains many improvements and hotfixes such as:

Major enhancements on the rules manager.
Major enhancements on the design workspace tools.
Major enhancements on current built-in functions.
Forms templates to choose from.
Major enhancements on the rule manager.
Performance enhancements.
Enhancements on controls and controls mapping.
Fixing reported issues and bugs.

And more …

We also advise you to download the updated user manual for this release which contains all the information about all the new features from the following link as well: SPARK Forms Builder User Manual

Enjoy SPARK New Features!!!

9/20/2018 8:38 AM

6.7217536809392

9/19/2018 7:49 AM

Mike Odeh

Edited: 9/23/2018 4:48 AM

Reply

System Account

How can I repsond to an approval task within the form through SPARK?

is there is any way that i can repsond to an approval task of a workflow designed by sharepoint designer therough SPARK forms, i want the user to open a section within this form and aprrove or reject the request.

Mike Odeh

/_layouts/15/images/person.gif" alt="Picture Placeholder: System Account" />

System Account

9/20/2018 8:47 AM

9/23/2018 4:48 AM

7.30565376194352

9/20/2018 8:47 AM

Jim Hidson

Started: 9/20/2018 8:48 AM

Reply

Mike Odeh

“Relative” option for control panels and show\hide panels

When I select that option any fields inside panel jump around and it's not easy getting back where I want them to be.

I tested with one of your templates and it does the same thing.
how i can acheive a relative panels that can shift automatically up and down when show\hide panels in the form?

Mike Odeh

http://www.itlaq.com:80/my/User%2520Photos/Profile%2520Pictures/mike_MThumb.jpg?t=63624568071" alt="Picture: Mike Odeh" />

Mike Odeh

When I select that option any fields inside panel jump around and it's not easy getting back where I want them to be.

I tested with one of your templates and it does the same thing.
how i can acheive a relative panels that can shift automatically up and down when show\hide panels in the form?

9/20/2018 8:48 AM