Use Infowise UltimateForms for SharePoint to Create a Dynamically Updated Date FIeld | Infowise

Kickstart Training

Kickstart Training Overview

List Setup and Initial Form

Form Building - Part 1

Form Building - Part 2

Form Building - Part 3

Form Building - Part 4

Form Building - Part 5

Form Building - Part 6

Form Building - Part 7

Email Alerts Setup

Getting Started

Differences Between Infowise UltimateForms for Microsoft 365 and On-premise Versions

Creating a site from a Business Solution Template

Kick Start Training

Form Designer - Make a Basic Form

Build it Now - Expense Reports

Build it Now - Form Designer

Build it Now - Approval System (Classic)

Build it Now - Charts (Classic)

Build it Now - Notification and Escalation System (Classic)

Build it Now - Process Diagram with Workflow (Classic)

Build it Now - Reservations System (Classic)

Build it Now - Timesheets (Classic)

Expense Report with One Approval (Classic)

Vacation Report with One Approval (Classic)

Actions

Smart Actions in Infowise UltimateForms for SharePoint

AND / OR Conditions

Create List Item Action

Delete Items Action

Send Email Action

Create a List/Library Action

Copy List Item Action

Create a Site Action

Manage Permissions Action

Check if field value changed

Create a history section

Alerts

Working with Dates

Time and Date Functions

Build a dynamic Today field

Today field date comparisons

Form Designer

Using Grid Design to Fine-Tune Form Layout

CSS for the Modern Form Designer – a Closer Look

Create a Public Facing Form

Associated Items Button

Moving, Adding and Removing Fields

Form Builder - Basic Styling

Rules to Control Form Element Behavior – Form State

Tabs and Tab Permissions

Enabling the Display All Columns Tab (Classic)

Create a Tabbed Interface

Tab / Field Permissions (1/3) (Classic)

Tab / Field Permissions (2/3) (Classic)

Tab / Field Permissions (3/3)

General Settings (Classic)

Multiple Columns (Classic)

Fragments - Inserting Custom Diagrams in Forms (Classic)

Manual Form Layout (Classic)

Use SharePoint Group Permissions (Classic)

Views and View Customization

Color Choice as a status indicator

Load a custom icon library

Add Forms to Microsoft Teams

Validation

Validate a signature field

Advanced Column Permissions

Hide fields to simplify the Add form

Signature Field

Adding a Signature Approval for List Changes

Item IDs

Create Item IDs using a seed value

Associated Items

How to Set up Associated Items

Revealing Associated List Information with Modern Form Designer

Print Formatting

Calendar Print Template

Adding Parameters to Print Template

Custom Print Headers and Footers

Charts, Filters and Other Web Parts

Range Column Chart

Charting in Office 365

List Search Filter by View

Creating a Rollup (O365)

List Filters (On premises)

Rollups (On Premise)

Event Calendar

Basic Event Calendar Office 365

Basic Events Calendar On-Premise

Email Approvals

Setup Sharepoint List

Setup Email Import

Connected Fields

Creating a Master- Detail Lookup Column with On-Premise Infowise

Voting Fields

Creating a Voting Column

Setting an Owner Column

List Search

List Search Setup

SharePoint doesn't provide a way to compare dates against the current day's date.
Infowise allows you to easily create this field and make it update dynamically using a smart action.

Instructions

In your list settings create a standard SharePoint "Date and Time" field.
Use the standard default settings for the field.
Create a new smart action to update the field value.
Use the timer event setting to have the action run once each day.
Hide the field from users since this is triggered automatically.
Set the custom "Today" field to the current day by using the SharePoint "[Today]" function.
Use the standard "ID equals [ID]" action.

In Office 365 actions are hidden from the users by default. In this case, simply leave "Manual execution" unselected. Also the "Column Name" selection is not present in Office 365. The interface looks slightly different as shown:

Summary

Normally you might have to use a custom workflow created in SharePoint designer or some other work around to dynamically check the current date. Infowise allows you to create a dynamically updated field that is critical for date comparisons which can be used as KPIs or to trigger other smart actions.

Last modified: 9/1/2017 5:38 PM

Loading...

Add your comment

Comments are not meant for support. If you experiencing an issue, please open a support request.

© 2005-2024 Infowise Solutions Ltd. All rights reserved.

Privacy | Cookie Policy | Accessibility | Cloud SLA