Forms

Locating the Forms feature

Anyone in a Role with the Edit Forms privilege can navigate to the Form Editor by opening the PROGRAM DESIGN menu and clicking on Forms.

How to create and edit Forms

To create a new Form, click the “New Form” button on the Forms screen:

Within the Form editor, name your new Form in the Description field as “Example Application”. PowerClerk will reference your new Form by this name. By clicking the top area of this new Form, please also enter “Example Application” as the title header for your new Form on the right-hand side:

Adding Data Fields to the Form

Add Data Fields to the Form by clicking and dragging any Field type item from the right-hand side menu tab Add a Field and drop the element onto your Form:

How does a program designer decide what fields should be added to this application Form? The best way to start configuring an application in your program is to take an existing paper or fillable PDF application and translate it into PowerClerk using the list of Data Field types available in the Add a Field section.

After you have set up this direct translation of a current Form, you can iterate on the Form in PowerClerk to make the application more efficient. PowerClerk Data Field properties such as making a field Required and setting up Conditional Visibility can be leveraged to make this new online Form much more powerful than what was used previously.

For example, one PowerClerk customer was able to combine 8 different interconnection applications into 1 Form in PowerClerk. What once took 8 different documents to administrate can now be collected in 1 Form, in 1 Workflow, in PowerClerk.
 
Field types (like “Single Line Text” and “Static Text” as shown in Figure 4) have importance to the kind of data that you’re looking to collect from your applicant.  Data Fields that require further calculations in the Formulas editor, for instance, will likely be set as “Integer” or “Decimal” fields.  PowerClerk will recognize the entries into these fields as data types that can be used in calculations.  In certain cases where you want the applicant to enter text (as in “Single Line Text”), you may also want to consider using Drop-down Lists or Multiple Choice field types so that you can present the applicant with a set number of options and avoid variations in data entry (like “Residential Service” versus “Residential” versus “Resi Service”).
 

Configuring Basic Data Field Properties

All Data Fields on Forms in PowerClerk have a small list of settings in common. You can configure these settings by clicking on that Data Field in the Form Editor and using the Field Properties menu.

(1) Label –what is displayed above the Data Field when a user is filling out the Form
(2) Required Field Checkbox –will prevent a Form from being submitted if this field is not filled out correctly
(3) Help Text –will display your specified text in a blue “?” bubble near the Label of the Data Field:
(4) Field Name –this is the database’s name for this Data Field. Note that the Label (what the applicant sees) and the Field Name (the name the database uses to store the data) can be different.

After you are done adding fields to the Form, click Save at the bottom of the Form Editor to save any changes.
 

Configuring the Form in the Workflow

Back on the Forms screen, please expand the new Form by clicking the “+” sign, and click the Configure Form button:

The Configure Form screen has several useful settings that will control which Roles can access the Form in which statuses, how this Form can trigger status changes, and how it can be integrated into administrative process:

 

Figure 7: Configure Form

(1) Selecting the Use for New Project Button checkbox for this Form will allow users to use this Form to enter the Workflow (and create a new, unique record). Note that multiple Forms can be configured to create a new project, allowing for programs with multiple, parallel Workflow paths. Every project in PowerClerk can have multiple Forms submitted throughout the Workflow, but only one of those Forms can be used to create the project in the first place.
(2) The Change status when submitting this form checkbox is used to cause a project to automatically change Status when the Form is submitted for a project. In this common example,when an applicant submits a brand new application, the project automatically changes to the Submitted Status. Another example would be if we created a Technical Review Form, and upon submission of that Form the project automatically moved to a Technical Review Completed Status. Note – this may be handled differently for programs that have been upgraded to Automations instead of Actions.
(3) The “In specific statuses” configuration option allows to define the statuses in which this Form is available, and which roles have access to the Form in those specific statuses. For example, when the project enters the Application Changes Needed Status, we could make this Form available to the Applicant so that they can come back to their application and make the appropriate edits. If we did not configure this Form to be available to the applicant in that Status, they would have read-only access to their application, and wouldn’t be able to make any changes to data that had already been submitted. Any Form submitted by a user assigned to a Role that does not have at least one Admin privilege, will always be visible in the view panel of the Project Landing Page (see below) after that Form has been submitted.
 

 

Figure 8: View panel of the Project Landing Page

 

PLEASE NOTE: it is considered a best practice to give Administrators and Program Designers access to any Form in any status that another role has been given access. This follows the general theme that Administrators and Program Designers have global access to data in the program.
 
 

VersaForms™

VersaForms allows administrators to use PowerClerk forms on any website—no PowerClerk account registration required. With VersaForms, utilities can simplify enrollment, increase conversion and better manage workflows—all from a single platform.
 

• Information submitted on a VersaForm is fed directly into PowerClerk workflows without requiring API configuration or other integration.
• VersaForms are easily adapted to the look/feel of the landing page they are hosted on.
• Forms can be created and modified in minutes by PowerClerk administrators, and easily embedded into utility-managed websites/landing pages.

Please note: The submission of a VersaForm™ creates a project. These projects count toward your utility’s (or agency’s) total application volume.
 
To enable VersaForms for your PowerClerk program, please file a new request in the Ticket System and choose the following option:
 

Figure 9: Request Embed ID

 
Once enabled you will be able to denote any of your Forms as a VersaForm by navigating to Program Design >> Forms >> expand the respective form and click the Configure Form button to enter the VersaForm configuration dialog as shown below:
 

Figure 10: Enable VersaForm option

 
VersaForms can be used in two distinct ways:

1. Embed the VersaForm in your own website by copying two lines of code (e.g. for Energy Efficiency Rebate programs).
2. Link to your VersaForm from a Communication Template send as an E-Mail.

Figure 11: VersaForm code snippet and direct link

 
See above samples for the code snippets, and respectively the direct link, which you can use in the context of your VersaForm scenario to embed your forms or direct your users with a link to your VersaForm.
 
 

Existing projects and VersaForms

Existing project VersaForm, the counterpart to new project VersaForm, allow for a form to be accessed and updated via an authenticated link, without requiring the user to log-in. Once you have requested an EmbedID for your program via PowerClerk’s Ticket System to enable VersaForms, the configuration option can be found under Program Design >> Forms >> expanding the respective Form and clicking the Configure Form button:
 

Figure 12: Existing projects and VersaForms

 
As shown in above screenshot, the Template Tag for this specific Form {form_link: <Form name>} can be embedded in a Communication Template. The recipient (e.g. a homeowner who interacts with PowerClerk only via their solar installer) is then able to click the authenticated link which allows them to submit this particular VersaForm for the existing project:
 

Figure 13: Communication Template example

 
Notably, the authenticated link can be defined to expire, and upon expiration, show a customizable expiration message. The availability (or access) may also be mapped to specific statuses in your program’s Workflow. Similarly, the Communication Template may be mapped to certain statuses so that Administrators cannot manually send the message if the link is configured to be unavailable.
 
By using a combination of a new project VersaForms and existing project VersaForm, a user’s email address can be confirmed allowing further information to be obtained from this “qualified” email address.
 
The below screenshot shows an example existing project VersaForm, only accessible through the authenticated link:
 

Figure 14: Authenticated Link VersaForm Example

VersaForms: custom font-size and font-family parameters

Two optional customization parameters allow you to set the font-size and font-family for embedded VersaForms: data-font-size-px and data-font-family. These parameters need to be added to the script tag used to embed a VersaForm:

• data-font-size-px: the value of this parameter should be a number that represents the font size you wish to use. It should not include the px part.
• data-font-family: the value of this parameter should be the name of the font family you with to use. It is the responsibility of the hosting page to make sure the actual font files are loaded as well.

Example:
<script type="text/javascript"
     data-font-size-px="17"
     data-font-family="sans-serif"
     src="<-- VersaForm script link -->" >
</script>

 

VersaForms: reCAPTCHA option

reCAPTCHA for Versa Forms allows to secure anonymous form submissions. This option can be configured under Program Design >> Forms >> by expanding the respective VersaForm and clicking the Configure Form button >> option “Enable reCAPTCHA” as shown below:
 

Figure 15: reCAPTCHA option

 
This will enable the reCAPTCHA protection during submission of a VersaForm to prevent spam submissions of your VersaForm:
 

Figure 16: reCAPTCHA option

Form Field Elements

PowerClerk’s From editor allows you to create rich forms using a variety of Form Field Elements to capture the information and data relevant to your Workflow processes.
 

Integer- and Decimal form elements

Integer form elements allow you to capture whole numbers in comparison to Decimal form elements with a decimal point in it, like these: 1.5, 0.6, or 3.14. You can set a Default Value for these fields and also define the allowed number value range with the lower (Min Value) an upper (Max Value) value limit.
 
Field properties:

• Label: A classifying phrase or name displayed above the integer form element
• Default Value: The initial value of this form element, set by PowerClerk without user input.
• Min Value: The lower value limit for this form element.
• Max Value: The upper value limit for this form element.
• Required Field: Enforces a value for this field. If none is set the form cannot be submitted.
• Read Only: The value of this form element cannot be edited in the context of the current form.
• Help Text: Guiding information on how to process or fill out this form element.
• Help Link: Additional information retrievable from an external web source.
• Conditional Visibility: This element will only be visible on the Form, if the condition for its visibility is met.
• Field Name: The internal data field name, corresponding to the list of data fields presented under Program Design >> Data Fields.

 
As shown in Figure 15 the thousands comma separator for Integer- and Decimal form elements provides an option in the Form Editor and in Data Fields to enforce comma separators for large numbers to ease the display of numerical digits:
 

 

Figure 17: Thousands separator for Integer- and Decimal form elements

 
You also have the option to set the thousands separator for Integer- or Decimal form elements under Data Fields as shown below:
 

 

Figure 18: Thousands separator for Integer- and Decimal form elements under Data Fields

 
Please note: Editing this setting under the Data Fields functionality will affect all references to that field in any form where the field exists to enforce display with commas. This editing functionality under Data Fields only becomes available after at least one Form draft referencing the respective data field has been saved.
 

Sensitive Data Fields

PowerClerk allows you to add Sensitive Data Fields to capture sensitive user information, such as Social Security Numbers, which you want to protect against unwarranted disclosure. Administrators of your program working with Sensitive Data Fields are required to setup Multi-Factor Authentication (MFA) for their account access in PowerClerk. To setup your administrative PowerClerk account accordingly, please navigate to Settings >> My Account >> Set up Multi-Factor Authentication and visit our Support Center article for further information.

As shown in Figure 17, you can drag a Sensitive Data Field to your Form editor as any other data field:

 

Figure 19: Adding a Sensitive Data Field

When one of your program administrators with the permission to access Sensitive Data Fields navigates to a Form containing this kind of data field, they will be able to click the Show button to disclose the obfuscated information:
 

 

Figure 20: Show / Hide Sensitive Data Field

Handling PII and sensitive information

Personal identifiable information, or PII, is any information that permits the identity of an individual to be directly or indirectly inferred. PII can include contact information, account information, etc. of an individual or entity. Some types of PII are considered sensitive and has additional requirements to manage appropriately. Sensitive PII may include the government identifying numbers, financial accounts, etc. of an individual or entity.
 

 
PowerClerk has three functions designed to appropriately manage sensitive PII: Sensitive Data Field, Sensitive Attachment, and Multi-Factor Authentication (MFA) for users. Identifying attachments and fields as sensitive enforces a higher level of role-permission for administrator user accounts to access the items and implements a higher level of data encryption for the underlying data. Follow each link to learn how to configure your program to include these functions when handling sensitive data.
 

 
PowerClerk has been designed to act as the system of record for such information when these functionalities are utilized; however, your organization may have its own security practices and requirements that should be considered.

 
FAQ
 
Can Sensitive Data Fields be used to populate Communications or Document Templates?
No, Sensitive Data Fields are not intended to populate Communications or Document Templates, given the sensitivity of the data they are used to collect.
 
Sensitive Attachments should be used when documents containing sensitive PII are uploaded.
 
What if users need to be provided a Document Template to input sensitive information?
To keep the sensitive information protected, use the generate document via Document Template form element for the user to download, wet-add any sensitive information, wet-sign (if applicable), and upload the completed document into PowerClerk as a Sensitive Attachment. By doing so, the sensitive information will be kept on the document only and can be accessed by Admin with MFA and the view sensitive data privilege.
 
What if sensitive information needs to be collected from individuals who lack a PowerClerk account? (i.e., a homeowner whose contractor has submitted an application on their behalf)
Our “Existing Project VersaForm” is specifically for collecting information from an individual without requiring a PowerClerk account. Access to the VersaForm can be shared using a data field tag (hyperlink) embedded within a Communication Template. Sensitive fields and/or attachments can be included on the VersaForm to collect the sensitive information. As an extra precaution, the Existing Project VersaForm link can be configured to become unavailable after the form has been submitted.
 
To learn more about how create a VersaForm for an existing project, please visit this link on our Support Center Article.
 
 

Attachment Fields

Attachment fields make it possible to upload project relevant document types such as .docx, .csv, .xlsx and .pdf file types for easy reference by Applicants or Administrators. Optionally you can request to specify additional acceptable file types and relax the existing 5 MB size limit currently applicable to this field type.
 
Configurable File Extensions: This option allows Program Designers to choose which file types are acceptable for each attachment field (e.g., .JPEG, .PNG, .CAD, etc.). You can define a variety of acceptable file formats with the exclusion of executable files like .exe or .bat:
 

 

Figure 121: Configure Allowed Files

Allow Large Files: The option to allow Large File sizes to be attached can be configured to enable attachments larger than the platform default. Please note: This option should only be used in circumstances explicitly requiring a deviation from the default value.
 

 

Figure 22: Allow Large Files

Feature Reference

Forms

Forms in PowerClerk are configurable by administrators, and can include logic that makes them dynamic and responsive based on user input. Data required in an application are entered into the application form by the applicant and are visible to the administrator upon submission. The application form is composed of fields, each uniquely labeled and positioned by the administrator or their designee. Many application processes have one application form; however, application processes with multiple application forms are also supported in PowerClerk, maximizing the flexibility to serve organizational needs to run programs.

Administrators define the fields contained in an online form, and the position of fields on the form via drag-and-drop. The Administrator drags each field from the list of options on the right side of the page, and drops the field onto the form as shown in Figure 18.

Field Types

The following list describes the field types which can be included in a form. It is important to note that additional field types can be developed to accommodate additional technologies, and not all field types will be applicable to all program types.

Field Properties

Most fields can be marked as required using a red asterisk. Integer and Decimal fields permit the administrator to specify minimum and maximum acceptable values; the field will reject entries outside of the acceptable range.

Conditional Visibility

Most fields can also be configured to be conditionally visible. Conditional visibility enables the administrator to specify the condition under which the field becomes visible/invisible to the applicant, and thus enables the form to adjust its requirements dynamically. Dynamic forms minimize applicant confusion by hiding fields that aren’t pertinent, thus reducing the overall length of the application, and the number of opportunities for an applicant to make a mistake.

In the example in Figure 19 below, the administrator is specifying that the Please Describe field is only visible when the applicant selects ‘Other’ in the preceding field: “Generation Type – Prime Mover.” Naturally, if the generation type was defined in a different entry in the drop-down list, the applicant wouldn’t need to specify the generation type in a text field.

 
Please note: If you intend to use a data field on two different forms and make one of the fields conditionally visible, then please review PowerClerk’s Conditional Visibility logic in the following video to better understand how PowerClerk would handle such Conditional Visibility configuration:

 
Please note: As an exception to the rule explained in the preceding video, Attachment field elements are the only form elements that are retained even if the attachment field is temporarily conditionally invisible. The reasoning for retaining uploaded attachments is to avoid uploading the attachment multiple times dependent on the underlying configuration for the field’s conditional visibility.
 

Additionally, the Administrator may specify Help Text and/or a Help Link for nearly every field type. Either will be visible to the applicant when clicking the blue help icon visible on a data field. See Figure 20 – Help Text and Help Link below.

Video Guides

Edit Forms – Tutorial #1

This video guide will show you how to insert key data fields into forms.  Capture key info from the form so that you have the necessary inputs to approve or reject applications.

Edit Forms – Tutorial #2

This video guide will show you how to adjust settings on key data field elements.  Set features like Conditional Visibility and PV or Custom List elements to capture key technical info.

Configuring Forms

This video guide explains how to Configure Forms in PowerClerk.

 
A full list of all Video Guides can also be found here.

FAQs

Q: I want to create a read only field to store the application fee amount, but prevent edits to this field, how can I do this?

A: The wrong way to go about this is to try and create a read-only field and assign a default value to this field. Such default values unfortunately are not saved upon form submission as read-only fields are intended for the purpose of displaying data that has been previously submitted.
The correct approach to accomplish what you are intending is to create a formula that contains the constant value, then save and enable that formula, and then connect the Formula Result element in your respective form field. This way the value for this field will be properly saved.

Q: Can I add HTML formatting to static text form fields?

A: Yes, within PowerClerk forms you can utilize a broad variety of formatting options to style your static text form elements according to your needs. Please click on this link for a list of available HTML formatting tags that you can add to static text form fields.

Q: How do I go about getting PowerClerk updated to reflect a new inverter that I cannot find in the current list?

A: PowerClerk uses the CEC-approved equipment lists for inverters (external link) and PV modules (external link) as the sources for its equipment option lists. We monitor those websites and when updates are made there, they are generally reflected in PowerClerk within one business day. However, we have no input or visibility into the approval process for any particular equipment items.
So it is up to the manufacturers to have their equipment models approved for inclusion on the CEC lists; instructions for that are available on the CEC website, including: http://www.gosolarcalifornia.ca.gov/equipment/documents/General_Listing_Request_Procedures.pdf.
Sometimes, the equipment item in question is actually in the option list but it is listed in an unexpected way so that it is not immediately found. Most often that’s due to a manufacturer name variation; here, in fact, there are two variations for this manufacturer, Northern Electric and Northern Electric & Power. But the model you inquired about it is not listed under either one.
Cases of unlisted equipment items like this happen quite infrequently, but some of our program admins have set up their form in such a way that an unlisted equipment scenario can be handled using conditional visibility of inputs. If you’d like some suggestions as to how you might do that, let us know.

WORK-AROUND One possible work-around for the issue with users selecting the “closest” model to their inverter is to set up the form with a “Technology Type” input that included Solar PV (Equipment not listed):
If Solar PV is chosen, then the standard PV System element is displayed, but if the “Solar PV (Equipment not listed)” option is chosen, then an alternative set of inputs could be displayed instead. For example:

Q: If you have a set of fields on a form (e.g. Form 1) that are also utilized on other forms (e.g. Form 2), do we need to update the same field value on each form or just update the field on Form 1 in order reflect the same data in the same data field on Form 2?

A: You would only need to update the Data Field on Form 1 to have Form 2 reflect the same change in data. Please note that for this to work, the data field on Form 1 would need to have the same Field Name as the data field on Form 2 as shown below:

Q: How can I make a field's appearance conditional?

A: Most fields can be configured to be conditionally visible. Conditional visibility enables the administrator to specify the condition under which the field becomes visible/invisible to the applicant, and thus enables the form to adjust its requirements dynamically. Dynamic forms minimize applicant confusion by hiding fields that aren’t pertinent, thus reducing the overall length of the application, and the number of opportunities for an applicant to make a mistake.
In the example below, the administrator is specifying that the Please Describe field is only visible when the applicant selects ‘Other’ in the preceding field: “Generation Type – Prime Mover.” Naturally, if the generation type was defined in a different entry in the drop-down list, the applicant wouldn’t need to specify the generation type in a text field.

Have additional questions? Contact us to nominate your FAQ and help others find answers to your own questions concerning this feature.

Create A Support Ticket

Not finding your answer here?  Submit a question to our support team at the PowerClerk Ticket System and leverage the PowerClerk team’s expertise.