Set Default Values in List Columns using Infowise Ultimate Forms in SharePoint Online
Bijay Kumar
Bijay Kumar
September 28, 2018 | Guest Blogger

In a business form, lots of time we required to display some default values to various list columns in SharePoint online. We can use some scripts to do that, but I will show here how easily we can create and manage things in Infowise Ultimate Forms. In the previous post, we discussed, how to Implement Date Validations using Infowise Ultimate Forms in SharePoint Online List Forms.

By using Infowise Ultimate Forms we can easily set default values to list columns. Here I have a task list and I want to set the default value of “Assigned To” column to the current user and Due Date to today + 5 Days. If you have not used Infowise Ultimate Forms, check out few of my posts: InfoPath alternatives for designing SharePoint Forms, Top SharePoint Workflow and Forms Applications Price Comparison, Update Field Value without using Workflow by using Infowise Update Action, Infowise Actions vs SharePoint workflows, Easily Configure Email Notifications using Infowise Ultimate Forms action, Infowise Actions vs SharePoint workflows: Copy List Item easily using Infowise Action SharePoint Online, Implement Date Validations using Infowise Ultimate Forms in SharePoint Online List Forms.

Configure Set Default Value in Infowise Ultimate Forms:

Set Default Value for Assigned To:

First thing is we can add the Infowise Ultimate Forms to SharePoint online site. Then you can see a “Design” option in the ribbon, on click of that it will open the “Infowise Ultimate Forms” Designer.

Infowise ultimate forms Date validation
Infowise ultimate forms set the default value

In the designer, you can see “Configure Defaults and Validation” section, there click on “Default values and dynamic rules”.

Infowise Ultimate Forms set default value
Infowise Ultimate Forms set the default value

Then in the General Settings, first choose:
Column -> Assigned To

Value -> [Current User], You can add Current User from Lookup builder.

And you can set when you want the value to appear, that is:

  • New item
  • Edit existing item

The screen looks like below:

Infowise Ultimate Forms set default value to people picker
Infowise Ultimate Forms set the default value to people picker

Then click on Add to add the rule. Once you add the rule, you can see the rule under the “Current rules” section. The good thing is you can see all the rules in one section.

Infowise Ultimate Forms set default value to people picker
Infowise Ultimate Forms set the default value to people picker

Set Default Value for Due Date:

Now we will see how we can set the default value for the due date column. Fill the below details in General Settings.

Column: Due Date

and then choose the Dynamic rule and then Value as “$AddDate([Today]|5|0)”, You can choose this value from the Value Picker like below:

Infowise Ultimate Forms set default value to due date
Infowise Ultimate Forms set the default value to due date

Then you can also set whether you want this to appear in New item or Edit existing item. So the rule looks like below:

Infowise Ultimate Forms configure todays date in due date
Infowise Ultimate Forms configure today’s date in due date

Both the rules will look like below:

Infowise Ultimate Forms configure rules
Infowise Ultimate Forms configure rules

Now it is time to test both the rules.

Test Rules:

To test whether the rules are working or not, open the list and then try to add an item to the list. Once you open the Add new item list page, you can see:

Due Date: This will be auto populate to Today’s date + 5 days

 

Assigned To: This will be populated to the current username. You can check in the screenshot.

Infowise Ultimate Forms configure rules
Infowise Ultimate Forms configure rules

Conclusion:

We have seen here how easily we can set default values to columns in SharePoint online list using Infowise ultimate forms. You can signup for an Infowise Ultimate Forms trial and check out various useful features which we can achieve without writing any code.

Loading...

Add your comment

Comments are not designed to replace support calls. If you have a specific issue with one of our products, please send an email to support@infowisesolutions.com to open a support ticket.

UltimateForms

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

Facing difficulties installing the application? Contact our fantastic support team.

support@infowisesolutions.com

Related Topics

What is right for you?

Online Trial

Not ready to install yet? Create a trial site in our environment
  • Full control of the site and its settings
  • Optionally pre-install one of our solution templates
  • Site provisioned instantly
  • Automatically removed after 30 days
  • Available to everyone!

Error!

There was an error processing your request.
Please contact us for further details.

Installation

Install in your own environment, on Microsoft 365 and on premises
  • Start working with real users and data
  • Install online or on premises
  • Register for 30 day trial
  • Seemlessly convert to paid license
  • Requires administrator permissions

Success!

Download link has been emailed to .
If you do not receive it within 5 minutes, please check your spam.
The link is valid for 72 hours.
If you are having problems, please contact us.

Error!

There was an error processing your request.
Please contact us for further details.
Technical details:

Request a Live Demo

Book an appointment for a one-on-one with an ULTIMATEforms expert trainer.

Test drive the awesome power of ULTIMATEforms

Learn how to quickly and easily turn time-consuming business processes into automated, efficient workflows.

Have a strong start

Only thirty minutes of well-coached time can translate into great future savings in time and money. So, sit back and enjoy the ride.

It's Free

Learn how to address business process pain points immediately. Save time and money.