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
WELCOME TO THE FUTURE
New faster ways for creating business solutions
ULTIMATEforms is a platform that enables everyone to easily create and maintain Microsoft SharePoint-based business solutions without a single line of code
Simple and Intuitive
Streamline form creation with smart, user-friendly tools
Deploy smart dynamic forms that adapt to your business needs
Utilize a drag-and-drop interface for effortless form design
Experience rapid form customization with intuitive editing tools
Accelerate project timelines with user-friendly, immediate solutions
Powerful Automation
Enhance operational efficiency and compliance
Streamline complex workflows into straightforward actions
Quickly establish compliant business processes
Seamlessly integrate data from diverse applications
Access and combine information easily for better decision-making
Comprehensive Reporting
Transform data into actionable insights
Generate detailed reports and dashboards for informed decision-making
Customize alerts and notifications to stay updated
Print and export data to PDF, Excel, or Word for easy sharing
Visualize data with color-coded calendars and intuitive dashboards
100’s of Templates
Streamline form creation with smart, user-friendly tools
Access hundreds of customizable templates for every business function
Install easily with one-time set-up; free for ULTIMATEFORMS customers
Replicate entire sites with settings between site collections and tenants using Template Manager
Jumpstart projects with pre-built solutions from our growing catalog, applied with a click
Dive deeper
Watch a short introductory video showcasing the different unique capabilities of UltimateForms.
Ready to get started?
Hands-on training is the best way to get proficient. That's why we've created three unique training offerings which will help you master ULTIMATEFORMS. Our interactive sessions are delivered via web meetings and conducted within personal virtual workspaces.
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
Microsoft partner logo GSA Schedule
© 2005-2024 Infowise Solutions Ltd. All rights reserved.
Privacy | Cookie Policy | Accessibility | Cloud SLA