Our Portfolio

Custom Solutions For Every Customer

  • all
  • Business Process Mgmt
  • Graphic Design
  • Motion Graphics
  • SharePoint
  • Video
  • Website Design
Create a button to Export SharePoint List View to Excel
Show/Hide InfoPath Help Text
Introduction Requirement: Create a user-defined In...
Introduction
Requirement: Create a user-defined InfoPath section that can be displayed or hidden based upon the user's need.
Table of Contents
  •  
    Create Control List Fields
    In order to create 'Help' buttons for your form user's, first create control fields in your custom list for each of your Help sections.
        1. Create a new column:
          1. Column name:  ShowHideBGDesc, ShowHideSTGYDesc, ShowHideBusTypeDesc, etc.
          2. Type: single line of text
          3. Required: No
          4. Accept defaults for everything else
    Add 'ShowHidexxxx' columns for every needed InfoPath help section you will create in the next section.
    Customizing the InfoPath form
    If you don't already have a list form that you need to customize, create one now. It can be based on a Custom list template, or any other list template that you need, such as Tasks.  
    • Add Picture button that user will Click to show/hide the Help text section
    • Add Help Text section
    Help Text InfoPath form section and Picture button
    Help Text InfoPath form section and Picture button
    Picture button rules
    1. Click on Picture button
    2. Click on Manage Rules from Home tab of InfoPath form
    3. Create a new Action Rule
    4. Set Condition to:
    • In first dropdown field, choose Select a field or group...
    • Select appropriate field, ShowHideSTGYDesc
    • In middle dropdown field, Select is blank
    • In And field dropdown field, Select or
    • In second line first dropdown field box, choose Select a field or group...
    • Select same field as previous, ShowHideSTGYDesc
    • In middle dropdown field box, Choose is equal to
    • In third dropdown field box, Choose Type a number...
    • Type '3' (without quotes)
    • Click OK
    5.  Add an Action by Clicking Add 6.  Select Set a field's value 7.  In Field box, Click field selection box and Choose same field as previous, ShowHideSTGYDesc 8.  In Value field, Type '2' (without quotes) 9.  Click OK 10.  Ensure that Don't run remaining rules if the condition of this rule is met
     

    11.  Create another Action Rule on picture button 12.  Set Condition to:

    • In the first dropdown field, choose Select a field or group...
    • Select same field as previous, ShowHideSTGYDesc
    • In the middle dropdown field box, choose is equal to
    • In the third dropdown field box, Choose Type a number...
    • Type '2' (without quote)
    • Click OK
      13.  Add an Action by Clicking Add 14.  Select Set a field's value 15.  In Field box, Click field selection box and Choose same field as previous, ShowHideSTGYDesc 16.  In Value field, Type '3' (without quotes) 17.  Click OK
     Help Section Rules
    1.  Select appropriate InfoPath section that will be tied to the previously set up Picture button
    2. Click on Manage Rules from Home tab of InfoPath form
    3. Create a new Formating Rule
    4. Set Condition to:
    • In the first dropdown field, Choose previously set up field, ShowHideSTGYDesc
    • In middle dropdown field, Choose is not equal to
    • In third dropdown field box, Choose Type a number...
    • Type '2' (without quotes)
    • Click OK

    5.  Under Formatting, Place a check in Hide this control field

Restrict InfoPath Section Visibility Based on User
Introduction During a recent client build (JPMC), ...
Introduction
During a recent client build (JPMC), I had a custom SharePoint list InfoPath requirement where I had to restrict a section of the InfoPath form view (I created 4 in total...see more here) to a specific group of users ('Management Use' only).  Instead of simply marking the section/fields with a heading such as 'Management Use only', I can show or hide this section based on the logged in user and separate custom permissions list where we can maintain the specific management group.  This ariticle describes how to achieve that in InfoPath.
Table of Contents
   
Creating the 'Management' List
In order to restrict sections in the form, create a custom list that contains the users who will have access to the section.  We will reference this list in a data connection in InfoPath.
  1. Create a custom list and name it: ElevatePermissionsUsers
  2. Create a new column:
    1. Column name: Admin/User
    2. Type: Person or Group
    3. Required: Yes
    4. Allow selection of: People Only
    5. Accept the defaults for everything else
  3. In Advanced Settings, Allow management of content types
  4. Change the Item content type and hide the Title field
  5. Change the default All Items view:
    1. Remove the Title field
    2. Add Edit (link to edit item) and move it to the first column
Now your list is ready, Add a couple of site users to the list.
Customizing the InfoPath List Form
If you don't already have a list form that you need to customize, create one now. It can be based on a Custom list template, or any other list template that you need, such as Tasks.
Add linkage fields
For this customer, I created a custom list and named it IOLRequest.  By adding two additional fields, IsAdmin (number, hide in all views) and CurrentUser (single line of text, hide in all views) to IOLRequest, I created a relational interchange between IOLRequest and the previously created ElevatePermissionsUsers. Now let's return to the InfoPath List Form by clicking the Customize in InfoPath button from any IOLRequest list view.  Click on the DATA tab on the InfoPath Ribbon, then go to Manage Data Connections.
Manage Data Connections
Add a New connection to ElevatePermissionsUsers list and name it GET-ElevatePermissionsUsers. Select the following fields:   AdminUser ID Accept the defaults and complete the wizard steps    
Create the Rules
  1. Select the DATA tab in the ribbon
  2. In the Rules section, click on the Form Load button
  3. Create a new Action rule and name it Assign Admin Users
  4. Accept the default Condition - None - Rule runs when form is opened
6.Create a new Set a field's value action:
  • Field: IsAdmin
  • For Value, click on the fx button
  • Click Insert a Field or Group
  • Click on Show advanced view
  • Change the data source to GET-ElevatedPermissionsUsers
  • Under dataFields, drill down and select ID
7. Click Filter Data 8. Click Add 9. In the first drop-down box change ID and click Select a field or group... 10. On the Data source dialog, under dataFields, drill down and select AdminUser AccountID
11. Click OK 12. Accept the default in the second drop-down: is equal to 13. From the third drop-down, select Use a formula... 14. On the Insert Formula dialog, click the middle button Insert Function... 15. Select the userName function and click OK
16. Click OK several times to close all dialog boxes The final Rule Details dialog should look similar to the image at right:
Manage Restricted Section
1. Click on the section tab that contains your restricted content 2. Create a new formatting rule and name it Hide From Non-Admin Users 3. Set the condition to IsAdmin = Is blank 4. Select the Hide this control check-box 5. Right-click on the CurrentUser field in the fields section and select Field Properties... 6. Change the Default Value by clicking the fx button next to the Value text box 7. Insert the userName function
Publish the form
Test the form by signing in to the site with a user who is in the ElevatedPermissionsUsers list, then with one who's not in this list.
Lincoln Park Zoo
Grainger
Accenture
OfficeMax
Tech Intro
Short Introduction to a educational film I created...
Short Introduction to a educational film I created for a client designed to show off additional technological capabilities.
The Kidology Lab Project
Is Your Site Mobile Friendly? It Better Be!
Easter 2014 – Light to Dark
The theme for this year's Easter was Light to Dark...
The theme for this year's Easter was Light to Dark. This bumper video was created as an introduction to the sermon.
PopUp Good News
A New Way to Tell an Old Story! PopUp Good News is...
A New Way to Tell an Old Story! PopUp Good News is a wholly created and produced animation series by ScottieDog Productions. The Bible made easy for everyone! Designed with your child in mind, an easy-to-use site rich with resources for parents faithfully raising a generation of kids to live out their faith in a watching world. From the vibrant homepage you can click thru to the download page for all our episodes, order a themed DVD, download tons of free activities, tune into blogs about issues facing parents and kids today, Watch Video clips from the entire series and more. Here's an early Christmas gift to you. PopUp Good News has decided to share this year's Advent episodes with YouTube. Each week in Advent we'll release the latest episode of PUpGN, telling the story of the Birth in a fun and unique way. Visit our website, PopUp Good News to download our episodes or order any of our themed DVD collections.
Volleyball Tournament
Here's a compilation of video I shot at a volleyba...
Here's a compilation of video I shot at a volleyball tournament held by New Life Church in Yorkville, IL.
The Progressive Life
Tea Time @ NLC
One of my favorite ladies at New Life Church has a...
One of my favorite ladies at New Life Church has asked me to help them put together a video highlighting the Woman's group accomplishments, outreach and the various ways they have touched women's hearts in the past year. This is a fun project, entailing After Effects, video production and Premier Pro. Check out the collaboration wallwisher we've utilized to build this video.
PIC Walk/5K
Began work with Pregnancy Information Center in Au...
Began work with Pregnancy Information Center in Aurora to put together promotional video for upcoming Walk/5K Run fundraiser.  Met with Penny for design meeting.  She talked about creating a video series to promote and market PIC to additional area churches and donors.
Who Is Jesus?
Who Is Jesus?  Working on this sermon series (Apr...
Who Is Jesus?  Working on this sermon series (April 2013) graphic package.  Designed to answer questions regarding Jesus's role in both God's plan and history.  Check out the graphic.