Riyan Arshad
Riyan Arshad
October 14, 2024

Managing expense reports efficiently is critical for any business, but many non-developers find it daunting to set up custom workflows and forms. Luckily, Infowise ULTIMATEFORMS offers a range of prebuilt SharePoint forms that can be easily customized to suit any organization’s needs without the need for coding.

In this guide, we'll show you how to use, customize, and automate prebuilt SharePoint forms for expense reports. This step-by-step tutorial ensures that even first-time users can set up an efficient system for managing expense reports with ease.

Step 1: Creating a SharePoint List and Accessing Prebuilt Forms

Before you can start customizing expense reports, the first step is to create a SharePoint list and access the Solution Catalog in the Infowise ULTIMATEFORMS app. This is where you’ll find the prebuilt forms that can be customized for your expense reporting needs.

Steps to Create a SharePoint List:

  1. Log into your SharePoint site where you plan to manage your expense reports.
  2. Navigate to the Site Contents and select New > List from the top bar to create a new SharePoint list.

  1. Ensure Infowise ULTIMATEFORMS is installed in your SharePoint environment. Once installed, you’ll see an option for Design in the top bar after creating the list.
  2. Click on the Design Button: This will open the Infowise Ultimate Forms customization interface for the list you just created.

Accessing Prebuilt Forms via the Solution Catalog:

  1. In the Infowise ULTIMATEFORMS interface, look at the top bar and locate the Solution Catalog option. This catalog provides access to various prebuilt forms, including templates for expense reports.
  2. Click on Solution Catalog and use the search bar to look for prebuilt forms related to Expense Reports. Once found, you can select the template that best fits your business needs.
  1. Choose Installation Option: When you select the form, you’ll be presented with two options for installation:
    • Install to the Current Site: This installs the form directly to the current SharePoint site where you are working (this is the option we’ll use).
    • Create a New SharePoint Site Under Current Site: If you need to manage a more complex or isolated process, you can create a new sub-site under the current site and install the form there.

  • Tip: If you’re new to SharePoint, it’s generally easier to install the form to the current site, especially if you’re managing expense reports for the same team or department.
  1. Once the form is installed, you can proceed to customize it according to your business needs.

 

  • Tip: If you don’t see the Design button, make sure that Infowise ULTIMATEFORMS is properly installed and activated for your tenant.

 

Step 2: Customizing Your Expense Report Form

Now that you've Installed the prebuilt form, it's time to customize it for your specific business needs. You can easily tweak the form fields, layout, and validation rules using the Form Designer in Infowise Ultimate Forms.

  1. Open the Form Designer
  2. Drag and Drop Fields: Modify your form by dragging fields like "Expense Category," "Date," "Amount," and "Receipt Attachment" into the form layout. You can also add a "Manager Approval" section.

  1. Set Default Values and Validation Rules:
    • Set default values for fields like “Date” to today’s date.
    • Add validation to ensure fields like "Amount" cannot be left empty or that attachments are required for expenses over a certain limit.
  2. Create Tabs for a Cleaner Layout: You can divide the form into sections by adding tabs, like General Info, Expense Details, and Approval. This makes the form easier to navigate.

Step 3: Automating Approvals and Notifications

Automation is key to reducing manual workload, and Infowise Ultimate Forms provides powerful tools for this. You can set up automatic notifications and approval workflows for the expense reports.

  1. Go to the Actions section under Ultimate Forms.
  2. Set up an action for Manager Approval:
    • When an expense report is submitted, trigger an automatic email to the relevant manager.

https://storage.infowisesolutions.com/images/postimages/riyanarshad/1-SharePoint-Expense-Report.png

  1. Automate Alerts:

  Create a New Action for Amount Threshold Alerts:

  • In the Actions panel, click on New Action to create an alert for when an expense report exceeds a predefined amount (e.g., $1,000).
  • Name the action (e.g., High-Value Expense Alert).

  Set Conditions:

  • In the Conditions section, configure the rule:
    • Set it to trigger when the Amount field is greater than your specified threshold (e.g., Amount > 1000).

https://storage.infowisesolutions.com/images/postimages/riyanarshad/1-SharePoint-Expense-Report.png

Step 4: Finalizing and Testing the Expense Report Form

Before deploying the form to your team, it's essential to test its functionality and ensure everything works as expected.

  1. Preview the Form: Use the Preview option in Infowise Ultimate Forms to see how the form will look to end users.
  2. Submit a Test Report: Fill out the form with sample data to test the submission, approval, and notification workflows.
  3. Review Submission Process: Ensure that the form flows smoothly from submission to approval and that documents are stored correctly.

 

Once you're satisfied with the form, publish it for your team to start using!

Conclusion

With Infowise ULTIMATEFORMS’s prebuilt form capabilities, managing expense reports has never been easier. This guide has walked you through the process of customizing and automating expense report workflows—ensuring you can streamline approvals, document storage, and notifications with minimal effort.

For businesses looking to enhance their SharePoint capabilities without coding, Infowise ULTIMATEFORMS is the perfect solution.

Loading...

Add your comment

Comments are not meant for support. If you experiencing an issue, please open a support request.
Build powerful business applications in SharePoint using only your browser.
100% No-Code Solution
It’s never been easier to create, innovate, and share. All you need is your web browser!
Cost-Effective
Address business process pain points immediately. Save time and money.
Fantastic Support Team
In addition to our responsive support team, a wide variety of resources, documentations, tutorials, blogs and webinars is available to you
Flexible Forms
Convenient responsive forms, featuring tabs, permissions, dynamic rules, repeating sections, electronic signatures and input validation
Intuitive Automation
Replace complex workflows with simple, but versatile actions to create and update data inside SharePoint and in a variety of integrated applications
Clear Reporting
Present data as actionable insights with detailed shareable reports, dashboards, calendars and charts
100’s of Templates
Build and replicate business solutions with ease, selecting from our vast free library and creating your own custom templates
Dive deeper
Watch a short introductory video showcasing the different unique capabilities of UltimateForms.
Microsoft partner logo
© 2005-2024 Infowise Solutions Ltd. All rights reserved.
Privacy | Cookie Policy | Accessibility | Cloud SLA
Pick a solution template to install
Solution Templates
Webinar Templates