Form Scripts

From AgileApps Support Wiki
Revision as of 22:06, 13 August 2015 by imported>Aeric (→‎Add a Help Button to an Arbitrary Form)

About Form Scripts

Form Scripting lets you specify JavaScript code to execute when a Form is loaded or saved.

JavaScript code can be invoked at these form-level events:

  • On Load
  • This event happens when the form loads
  • By default, the On Load scripts are triggered on any record action (View, Add, Update)
Optionally, invoke the script on a specific action (View or Add or Update)
Learn more: Trigger on a Specific Action
  • On Save
  • This event happens when a user clicks the [Submit] button on a form
  • At this event, optionally perform custom front-end validations before sending the data to the server
  • Return false to cancel the save
  • Resusable Script Functions
  • Available to be called from the On Load or On Save event form scripts
  • Also available to be called from the On Change and On Focus event field scripts
Learn more:

Working with Form Scripts

Editing Form Scripts

Follow these steps to add or change scripting in a form:

  1. Click [Form Script]
  2. Click [Edit]
  3. Enter or change the JavaScript in On Load Script, On Save Script, and/or Reusable Script Functions
  4. Click [Save]

Writing JavaScript

Using JavaScript, you can

On Load Examples

These examples perform operations when a form is loaded.

Add a Help Button to an Arbitrary Form

This code works for forms in all objects, including Cases, Tasks, and custom objects. And it works when adding a new record, as well as when viewing an existing record.

In general, it puts a [Help] button in the upper right corner of a form:

HelpButtonScriptExample.png

Note that when viewing a record, there are two options, depending on which code you enable:

  • Put the button in the details area. (The button is only visible when details are shown, but the short block of code works for all objects.)
  • Put the button above the details area.
This option requires special-case code for the Cases object. Note that the placement isn't perfect (the case-description is pushed down). But the button is always visible, whether or not the details area is open:
HelpButtonCaseRecord.png

In either case, the code below opens the target page in a separate window.
(To open the page in the Help tab, see HowTo:Creating Application-Specific Help.)

<syntaxhighlight lang="javascript" enclose="div">

var targetURL = "http://google.com"; var action = _sdForm.get(0).a.value; // Is this an add-record or view-record form? var button =

'

\
    <input type="button" value=" Help " onclick="window.open(\+targetURL+'\')"> \

';

if (action == "add") {

  // POPUP DIALOG. PUT HELP BUTTON IN THE NEW-RECORD FORM.
  _sdForm.parent('div').parent('div').parent('div')
         .find('.assigned_title .row-fluid').append(button);

} else {

  // RECORD VIEW. PUT HELP BUTTON IN DETAILS AREA.
  // The simplest code. Works for all objects: custom objects, cases, and tasks.
  // The button shows only when the details section is open
  // Ideal when Company Info > Application Settings > Expand Details" is TRUE
  _sdForm.parent('div').parent('div').prepend(button);
  // OR (choose the else-clause above, or the one below)
  // PUT THE HELP BUTTON ABOVE THE DETAILS AREA, so it is always visible 
  // This code pushes the case summary down by the height of the button. 
  // Help button appears even when record details are hidden.
  var banner = _sdForm.parent('div').parent('div').parent('div')
      .find('.case-priority-status-header'); 
  if (banner.length == 0) {  
     // NORMAL RECORD VIEW (custom objects and tasks)--PUT BUTTON IN TITLE AREA.
     _sdForm.parent('div').parent('div').parent('div').find('h5').append(button);
  } else {
     // The special case-record banner that shows priority and status is present.
     // CASE-RECORD VIEW. PUT THE BUTTON UNDER THE BANNER.
     banner.after(button);
  }   

} </syntaxhighlight>

Help Page Target Options

As for the help page to point to, you have many options:

  • An externally-hosted web page
<syntaxhighlight lang="javascript" enclose="div">

var button =

'

\
     <input type="button" value=" Help " \
            onclick="window.open(\'http://path/to/REMOTEPAGE.html\')"> \

';

</syntaxhighlight>

Thumbsup.gif

Tip: The external page could be hosted on one of the free Wiki services, like WebDot, WebHub, or WebSpaces. (Those are some of the most widely used services at the time of this writing. They are very different from each other, so do an in-depth comparison to choose the one that will work best for you.

  • A JSP Page hosted in the application platform
This is arguably the most useful option, since displays a page that is already in the platform.
It also opens the page in a new window, which lets the user see the help and the application side by side.
(The remaining options change user-focus to a different part of the platform, so the user loses context.)
<syntaxhighlight lang="javascript" enclose="div">

var button =

'

\
     <input type="button" value=" Help " \
            onclick="window.open(\'/networking/page/PAGENAME.jsp\')"> \

';

</syntaxhighlight>

Notepad.png

Note:
In the button JavaScript, the path to a JSP page begins with a forward slash.
But a relative link to the same page coded inside a JSP page would not have one.
So the link would look like this:

<a href="networking/page/PAGENAME.jsp>...link-text to click...</a>
Use the link-target pattern:
https://{yourDomain}/networking/servicedesk/index.jsp#_portal/articles/{articleID}
Learn more: URL Addresses#KnowledgeBase Article
For that option, the JavaScript code needs to find the Help tab element, and "click" on it.
Learn more: HowTo:Creating Application-Specific Help
  • A JSP Page hosted in a platform Site
Add a Help Button Using a Static Resource Script

A useful piece of code tends to be useful in multiple forms, in multiple objects. To make the code available to every form in your system:

  1. Turn it into a function and store it in a .js file:
    <syntaxhighlight lang="javascript" enclose="div">

/**

* Usage: addHelpButton("target-page-URL");
*/

function addHelpButton(targetURL) {

 ...code goes here...

} </syntaxhighlight>

  1. Load the file as a Static Resource.
  2. Use the REST static resource API to get the resource ID
  3. Put the following code into the form to read the file, use the JavaScript eval function to make the function available, and invoke it:
    <syntaxhighlight lang="javascript" enclose="div">

$.get("https://{YOURDOMAIN}/networking/rest/staticResource/{RESOURCEID}?getFile=true",

 function( data ) {
    eval(data); 
    addHelpButton("YOUR HELP PAGE URL"); 

}); </syntaxhighlight>

Learn more: Static Resources#Accessing a JavaScript Resource from an Object Form

Add a Button Next to a Field in an Object Form

This example adds a button to a standard object Form, as shown here:

FormLookupButtonAdded.png

The standard form is shown on the left. ON LOAD JavaScript added to it injects the button, producing the form on the right.

<syntaxhighlight lang="javascript" enclose="div">

// Get a pointer to the current form var form = _sdForm

try {

   /*
    * Find the order number field, modify it's CSS properties,
    * and add a search button to the element it's contained in.

* (Each label and field is contained in it's own

. The
    *  .parent() function accesses it, and the button is added at the end.)
    */
   form.find("#orderNum").css( {'width': '50%',"margin-bottom":"0px"}); 
   form.find("#orderNum").removeClass("text_box_case"); 
   form.find("#orderNum").parent().append( 
      "<input type='button' id='lookup_order' name='lookup_order' value='Lookup Order'" 
    + "style='background: none repeat scroll 0 0 #EBEBEB;box-shadow: 0 0 0 0 #888888 inset;"
    + " height: 26px;margin-top:-0px; padding: 0 8px 0 6px;"
    + " margin-right:5px;margin-left:5px;' >" 
      ) ;
   /* 
    * Add an anonymous function to the button to invoke the WebServiceProxy method. 
    */
   form.find("#orderNum").parent().find("#lookup_order").click( 
     function() 
     { 
       // Perform some operation
       alert("jQuery/Javascript placed here gets executed");
       // Don't submit the input form when this particular button is clicked.
       return false;
     } 
   ); 

} catch (e) {

  // Report JavaScript errors 
  alert(e);

}; </syntaxhighlight>

How it works
  1. _sdform - A pointer to the current form
  2. form.find("#orderNum") - Find the order number field, using it's ID.
  3. .css - Define new CSS Styling for the field.
  4. .removeclass - Remove the reference to the CSS class currently used by the field. In this case, the field is a text field, so the class associated with that kind of field is removed. (For other field types, inspect the page to see what class is used.)
  5. .parent.append - Go to the div that contains the field and it's label. Append a new button to the end of it. Specify CSS styling for the button that fits into the form.
  6. Lookup Order - The label displayed on the button.
  7. find("#orderNum").parent - Find the button again, and go to the div that contains it.
  8. #lookup_order - Find the button we added.
  9. .click - jQuery function to define an "on click" event handler.
  10. function() - Define an unnamed ("anonymous") function that contains the combination of JavaScript and jQuery functions to execute when the click event occurs on the button.
  11. return false - Prevent the input button from causing the form to be submitted.
  12. catch (e) - Report JavaScript errors. (They occur in the browser, so they don't appear in the platform's Debug Log.)

Learn more:

For a fully worked-out example that uses this technique to access an external web service, see Invoke Web Services Programmatically. (The first part of that section defines a class to access the service. The last part adds a button to a form to access it.)

Add a Button to a Case Form

This example adds a button to a Case details form. In this case, the button appears on the same line as the Save and [Cancel] buttons, but it is floated over to the left, as shown here:

CaseFormButtonAdded.png
<syntaxhighlight lang="javascript" enclose="div">
var html = "
"
        + "<input type='button' id='customButton' value='Button Label'"
        + " class='lj-button fg-button ui-state-default ui-corner-all'"
+ "/>
";

try {

  $(".case_details_forms").find(".case_submit_button").parent().parent().prepend(html);   
  $("#customButton").click( function()
  {
    alert("jQuery/JavaScript code placed here executes when the button is clicked");
  });

} catch (e) {

  alert(e);

}; </syntaxhighlight>

How it works
  1. html - Define a string that contains the HTML code to insert.
  2. div...float:left - Create a div that floats to the left, to contain the button.
  3. class - These CSS classes make the button appear the same as other platform buttons.
  4. .case_details_forms - Find the details form by it's CSS class. (Only item uses that class.)
  5. .case_submit_button - Find the [Save] button at the bottom of that form using it's CSS class. (Only one item uses that class.)
  6. .parent().parent() - Find the div that contains the button, then find the div that contains that, so we can add our div to it.
  7. prepend - Insert our float-left div before the one that contains the buttons
  8. #custom_button - Find the button we just added, using it's ID.
  9. .click - jQuery function to define an "on click" event handler.
  10. function() - Define an unnamed ("anonymous") function that contains the combination of JavaScript and jQuery functions to execute when the click event occurs on the button.
  11. catch (e) - Report JavaScript errors. (They occur in the browser, so they don't appear in the platform's Debug Log.)

Convert a Date

Create readable date string from the current date for display in the order_date field.

var v1 = new Date(); 
var v2 = new Array('Sun', 'Mon', 'Tues', 'Wed', 'Thu', 'Fri', 'Sat'); 
var v3 = new Array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 
                   'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'); 
date_string = v2[v1.getDay()] + " " + v3[v1.getMonth()] + " " + v1.getDate(); 
setTextFieldValue(_sdForm, "order_date", date_string);

Trigger on a Specific Action

To invoke a script On Load + Action (View, Update, Add or Clone a record):

Trigger on record View:

var action = _sdForm.get(0).a.value;
if ( action == "view") {
   // java script to be triggered on the view of the record only
   ...
}

Trigger on record Update:

var action = _sdForm.get(0).a.value;
if ( action == "update") {
   // java script to be triggered on the update of the record only
   ...
}

Trigger on record Add or Clone:

var action = _sdForm.get(0).a.value; 
if ( action == "add") {
   //java script to be triggered on the add or clone of the record only
   ...
}

On Save Examples

These examples perform operations when a form is saved.

Create a Contact

Make sure there is a contact when creating a record in a "Leads" object.

var form = document.mainForm;
if (form.reference_type[form.reference_type.selectedIndex].value == 'Lead')
{
    if (form.contact_id.value == "")
    {
      alert("Please enter Contact Name");
      return false; // cancel the save operation
    }
}

Set a Date Field

If a user checked the "Done" radio button in a radio button group named technical_spec_completed, set the spec_date field with the current date formatted as month number, day number, and year.

var form = document.mainForm;
function formatDate(value)
{
    return value.getMonth()+1 + "/" + value.getDate() + "/" + value.getFullYear();
} 
for (var i=0; i<form.technical_spec_completed.length; i++) {
    if(form.technical_spec_completed[i].checked &&
        form.technical_spec_completed[i].value == 'Done' && form.spec_date.value == '')
    {
        t = new Date();
        form.spec_date.value = formatDate(t);
    }
}

Change a Checkbox Field

Change the value of a checkbox field to true when the request amount is large enough.

<syntaxhighlight lang="javascript" enclose="div">

if(_sdForm[0].request_amount.value > 10000) {

   setCheckboxState(_sdForm, "approval_required", true);

} </syntaxhighlight>

Confirm that a Field is Intentionally Blank

The email address field on a form is not mandatory, but you want to encourage users to enter it. If the user clicks OK in the confirm dialog, it cancels the save so they can then enter the email address. If they click cancel, the save proceeds.

var form = document.mainForm;

if(form.email.value=="")
    if (confirm("While the field is optional, we recommend entering a value")) 
    {
        //User clicked OK: do not proceed with save
       return false;
    else
    {
        //User clicked cancel: let save happen
        return true;
    }
}

Learn More