Picture Placeholder: Dynecia Amos
  • Dynecia Amos
07/2/2018 7:43 AM

How do I properly submit a form and show an alert? I was able to submit the form and show an alert, but I had to click the button twice.  Also, will you please give an example that shows how to set field values and switch to a different form view? 

7/2/2018 7:43 AMNoCodes & Scripts
0
6/28/2018 7:13 AM
  
Picture Placeholder: Nathan Burgess
  • Nathan Burgess
16/27/2018 5:49 AM

​Hi,

Building a new Approval Workflow where the user must enter their Approver on the form via a field of type "People".

I am using the field via $WFItemFields(Approver) in the "Assign To" field of a standard request approval.

However, when the workflow runs the user is not assigned. It remains blank.

Any help appreciated.

Nate

Nathan Burgess6/27/2018 6:10 AMNoSPARK Workflow
25.2189919950768
6/27/2018 2:36 AM
  
Picture Placeholder: Graham Charlton
  • Graham Charlton
05/28/2018 10:44 AM

​Hi All. Has anyone found a solution for exporting to PDF, whilst maintain the resolution of the form? Whenever I export to PDF, the resolution is poor (if the width of the view is set to say 1000 pixels). The only way I seem to have at this point, is to make the form size 2480 x 3508 pixels (which is the resolution for A4). This makes the view size of the form huge. Any help would be appreciated

5/28/2018 10:44 AMNoGeneral
0
11/26/2017 10:55 AM
  
Picture Placeholder: Alvina Reed
  • Alvina Reed
05/22/2018 7:24 PM

I have a form with about 14 items in a CheckBoxList Control, I have created a form view for each item, the form view is named the same as the checkbox item. I want to do the following:

Each form except the main form has three buttons (BACK, NEXT, SUBMIT)

I want the Next button on the main form to go to the first selected form associated with the checkbox item. On the next form I want the Next button to go to the next form and the back button to go to the first form and so on.

For Example if a user selects checkbox A,B,E,H

Main Form Next Button -- > A Form
A Form Next Button -- > B Form
A Form Back Button --> Main Form
A Form Submit Button --> Hidden
B Form Next Button --> E Form
B Form Back Button --> A Form
B Form Submit Button --> Hidden
E Form Next Button -->H Form
E Form Back Button -->B Form
E Form Submit Button --> Hidden
H Form Next Button --> NONE
H Form Submit Button --> Submit
H Form Back Button -- E Form

5/22/2018 7:24 PMNoCodes & Scripts
0
8/14/2017 9:30 PM
  
Picture Placeholder: Greg Reno
  • Greg Reno
14/19/2018 4:28 PM

​I am using a textbox as a date field. I do this to be able to allow the users to select a date or if the date is unknown use UNK.

e.g.

03/22/2017

03/UNK/2017

03/22/20UNK

In the past I would just add something like this to my global jQuery and set my field CSS to DATEFIELD.

$('.DATEFIELD').attr("placeholder", "mm/dd/yyyy").datepicker({ constrainInput: false

 });


I have set the CCS to Datepicker and I know I can get this to work but how can I apply constrainInput: false to the current jQuery?


ref: https://api.jqueryui.com/datepicker/#option-constrainInput


Thanks.

Greg Reno4/19/2018 5:32 PMNoCodes & Scripts
21.7911806524842
4/19/2018 10:12 AM
  
Picture: Jim Hidson
  • Jim Hidson
03/26/2018 8:12 PM

A new version of SPARK Forms Builder for SharePoint 2013 / 2016  has been released [Version 5.6.100.175].

 

This new release has great new features, enhancements, hotfixes and important security updates such as:

 

  • Major enhancements on Web Connector control and the way to integrate forms through web services.
  • Major enhancements on forms performance.
  • Major enhancements on Advanced Lookup control.
  • Enhancements and improvements on Repeater control.
  • Enhancements on Master-Details lists integration feature.
  • Ability to upload, browse and select files and items through SharePoint Explorer dialogue.
  • Major enhancements on the form designer functionalities and performance.
  • New important and very useful functions.
  • Important hotfixes.

 

And many more great new enhancements and features…

 

3/26/2018 8:12 PMNoGeneral
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
03/13/2018 7:44 PM

​This video will show you how you can allow your form's users to select and upload files to your SharePoint farm and link them in your form through the files explorer dialog and without the need to do any manual operation like what users have to do when using InfoPath forms. This can be done easily using SPARK Forms Builder by creating a simple rule on a button. In less than 5 minutes you will be able to provide your users with a great technique to work with files, images ..etc and manage to integrate them with your different form's controls such as image and hyperlink controls.

​​​

3/13/2018 7:44 PMNoCodes & Scripts
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
111/10/2017 11:34 PM

​I have received the following questions regarding dealing with SPARK forms URL parameters and how to deal with them:

1. How do I test whether or not the parameter is even present in the URL? I have tried isEmpty()/isNotEmpty() and length() functions but get "Unable to get property 'character' of undefined or null reference" error when I try to save. If I use =='' or !='' then the rule doesn't seem to work either.

2. How can I set the value of a field on the form to what is entered in for the parameter? The setValue() function does not allow getFormQueryString() to be used as the value. I get the same error as in #1.

The Answer:

1-      getFormQueryString('The Parameter')!=null

2-      you have Two ways to do that:
a)

setValue(TextBox5,getFormQueryString('source')!=null?getFormQueryString('source'):'')

b)

try{

setValue(TextBox5,getFormQueryString('source'))

}catch(ev){}

Dennis Mingeroet2/28/2018 12:39 PMNoCodes & Scripts
13.8872351624207
12/25/2017 5:38 PM1
Julie Batista
  
Picture: Sergio Schinoff
  • Sergio Schinoff
311/6/2017 10:53 AM

​How could I save the repeater's rows in a different list using a custom button?

Jim Hidson2/22/2018 7:08 PM75NoCodes & Scripts
14.0867872280263
12/25/2017 7:28 PM
  
Picture Placeholder: Julie Batista
  • Julie Batista
22/15/2018 7:58 PM

​I really like the List Grid View control, especially being able to select the specific fields and adding a query to limit what is returned. I have a List Grid View control that I have set the width to 500 and am only returning 1 field (single line of text, up to 255 characters). When I view the data, the field is being truncated, even though there is plenty of space displaying. I can move the bar over so it will all display, but I would like the display to show all it can for the width provided. All of the data also displays if I hover over. It's frustrating to only see the beginning part of the field when there is space available in the control.

Julie Batista2/20/2018 3:52 PMNoGeneral
19.0307420099365
29/15/2017 1:58 PM1
Jim Hidson
  
Picture: Jim Hidson
  • Jim Hidson
112/19/2017 7:17 PM

​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.​​​

​​​​​​​​
 

Torey Kirby2/6/2018 11:51 PMNoSPARK Forms
15.7491303052619
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
01/29/2018 5:56 PM

​This video will show you how you can create a 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.


1/29/2018 5:56 PMNoSPARK Forms
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
01/25/2018 3:20 AM

This new release has great new features, enhancements, hotfixes and important security updates such as:

 

  • Creating advanced forms for External Lists.
  • SPARK Forms Web Part.
  • Creating and Sending Email templates and messages.
  • Script Manager.
  • Major enhancements and improvements on Repeater control.
  • Master-Details lists integration.
  • Currency Control.
  • Item Linker Control.
  • Major enhancements on the form designer functionalities and performance.
  • Enhancements on CAML Query Builder and building dynamic queries.
  • Rules Dependency.
  • Major enhancements on SQL and XML Connectors controls.
  • Major enhancements on Lookup and Advanced lookup controls.
  • Executing SQL Procedures from within the form.
  • New important and very useful functions.
  • Important hotfixes.

 

And many more great new enhancements and features which you can have more details on them at this link: SPARK Versions

1/25/2018 3:20 AMNoGeneral
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
01/23/2018 8:21 PM

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.


1/23/2018 8:21 PMNoCodes & Scripts
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
01/22/2018 12:05 AM

​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 15 seconds, 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.


1/22/2018 12:05 AMNoCodes & Scripts
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
011/13/2017 1:35 PM

​This video will show you how you can create fabulous 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 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.

11/13/2017 1:35 PMNoSPARK Forms
0
2/25/2017 5:38 PM
  
Picture: Jim Hidson
  • Jim Hidson
011/10/2017 11:21 PM

In order to calculate the number of working days between two dates in SPARK you can use the following script which substitutes the weekend days from the total number of days between these two dates.

Controls: Date1, Date2 , TextBox1

Script:

function getWeekendDays(d1,d2){
    var start = new Date(d1),
    finish = new Date(d2),
    dayMilliseconds = 1000*60*60*24;
    var weekendDays = 0;
    while (start <= finish) {
      var day = start.getDay()
      if (day == 0 || day == 6) {
         weekendDays++;
        }
      start = new Date(+start + dayMilliseconds);
    }

    return weekendDays
}

var weekendday= getWeekendDays(getValue(Date1),getValue(Date2))

var differnceDay=calculateDays(Date1,Date2)+1

var numberOfFinalDays=differnceDay-weekendday
 
setValue(TextBox1,numberOfFinalDays)

 

11/10/2017 11:21 PMNoCodes & Scripts
0
2/25/2017 5:38 PM
  
Picture Placeholder: Julie Batista
  • Julie Batista
011/8/2017 10:49 PM

​The getFormQueryString() function appears to only be usable in the Condition section of the Rule and not in the Action section, as long as you can test for a specific value. The parameter could be a string of numbers, or not even present.

1. How do I test whether or not the parameter is even present in the URL? I have tried isEmpty()/isNotEmpty() and length() functions but get "Unable to  get property 'character' of undefined or null reference" error when I try to save. If I use =='' or !='' then the rule doesn't seem to work either.

2. How can I set the value of a field on the form to what is entered in for the parameter? The setValue() function does not allow getFormQueryString() to be used as the value. I get the same error as in #1.

11/8/2017 10:49 PMNoCodes & Scripts
0
9/15/2017 1:58 PM
  
Picture: Nancy Castelo
  • Nancy Castelo
110/27/2017 12:06 PM

​Hi,

how would i manage to collect all the peoplepicker values in several rows of a repeater and save the collected accounts into the list's "Person or Group" column?

Mike Odeh10/27/2017 12:16 PMNoCodes & Scripts
13.163334120754
12/25/2017 7:07 PM1
Mike Odeh
  
Picture: Jim Hidson
  • Jim Hidson
010/27/2017 11:59 AM

The following characters are recognized in the Format property of the DateTime control. The format specified in the Format property should be a correct date/time format (please sees below example).

 

FormatDescription
Day
FA full textual representation of a month, such as January or March
mNumeric representation of a month, with leading zeros
MA short textual representation of a month, three letters
nNumeric representation of a month, without leading zeros
Year
YA full numeric representation of a year, 4 digits
yA two digit representation of a year
Time
aLowercase Ante meridiem and Post meridiem
AUppercase Ante meridiem and Post meridiem
BSwatch Internet time
g12-hour format of an hour without leading zeros
G24-hour format of an hour without leading zeros
h12-hour format of an hour with leading zeros
H24-hour format of an hour with leading zeros
iMinutes with leading zeros
sSeconds, with leading zeros
uMicroseconds. Will always generate 000000.

 

Examples: You can represent date 10/10/2017 in the following formats:

FormatResult
m/d/Y H:i:s a10/10/2017 11:52:25 am
F d, YOctober 10, 2017
M d, YOct 10, 2017
M d, yOct 10, 17
M d, y g:iOct 10, 17 12:03
M d, y g:i:sOct 10, 17 12:04:23
m/d/Y H:i:s a10/10/2017 12:13:09 pm

 


10/27/2017 11:59 AMNoCodes & Scripts
0
2/25/2017 5:38 PM
1 - 20Next

 SPARK Case Study

  
  
  
  
  
  
  
  
  
Picture: Jim Hidson
  • Jim Hidson
12/25/2017 5:38 PM
31
18
6
1,290
Picture: Nancy Castelo
  • Nancy Castelo
12/25/2017 7:07 PM
3
1
1
190
Picture: Sergio Schinoff
  • Sergio Schinoff
12/25/2017 7:28 PM
6
3
0
140
Picture: Mike Odeh
  • Mike Odeh
13/8/2017 1:04 PM
6
4
0
120
Picture: Rafeef Sabri
  • Rafeef Sabri
12/25/2017 7:52 PM
2
0
0
70