Skip Ribbon Commands
Skip to main content
SharePoint

Repeating Rows Field Type

 

  
  
Expense Details
  
  
  
10
Expense-typeExpense DateDetailsAmount$
Parking4/17/2015parking$100.0
Parking6/9/2015twice driving to the conference$45.0
Fuel12/15/2015added from the details list$80.0
Other3/18/2016test$10.0
5/10/2016ss$20.0
Fuel10/15/2016hzth$55.0
11/14/2016cvi$100.0
Other11/24/2016xcfsd$100.0
Other3/3/2017drtergerg$56.0
Other1/17/2017dfgdrfgdf$2.0
Other3/9/201732324234$29.0
Other4/13/2017eeeee$1.0
Other3/30/2017asdfasdf$2.0
4/25/2014 2:37 AMtestclient1
  
09
Expense-typeExpense DateDetailsAmount$
Taxi3/18/2015Taxi$50.0
Lunch3/18/2015Chipotle$10.0
Fuel3/19/2015Travel to conference$100.0
Lunch3/13/2015Chipotle$12.0
Other3/18/2015Asdf$20.0
Parking11/11/2015werwerw$32.0
$224.0
10/23/2014 10:49 AMtestclient1
  
10
Expense-typeExpense DateDetailsAmount$
Fuel10/6/2015conference$59.0
Fuel4/14/2016zd$22.0
$81.0
10/12/2015 4:41 AMAdministrator
  
02
Expense-typeExpense DateDetailsAmount$
Lunch10/23/2015Test$30.0
Fuel10/23/2015test$10.0
$40.0
10/23/2015 3:08 PMtestclient1
  
04
Expense-typeExpense DateDetailsAmount$
Lunch1/22/2016ljljl$20.0
$20.0
1/22/2016 3:52 AMtestclient1
  
03
Expense-typeExpense DateDetailsAmount$
Fuel2/26/2016aaa$22.0
2/26/2016zxax$33.0
$55.0
2/26/2016 12:50 AMtestclient1
  
02
Expense-typeExpense DateDetailsAmount$
Lunch2/2/2016Jef$29.0
Parking2/2/2016NAT BANk$5.0
Fuel2/4/2016Fuel 50l$86.0
$120.0
2/29/2016 10:01 AMtestclient1
  
02
Expense-typeExpense DateDetailsAmount$
Fuel4/14/2016test$1.0
$1.0
4/14/2016 12:11 PMtestclient1
  
01
Expense-typeExpense DateDetailsAmount$
Donuts8/19/2016Conference$10.0
Donuts8/5/2016Lunch$2.0
$12.0
8/19/2016 10:25 AMAdministrator
  
09
Expense-typeExpense DateDetailsAmount$
11/13/2016test$20.0
11/13/2016 11:18 AMtestclient1
  
01
1/29/2017 5:50 PMtestclient1
  
02
Expense-typeExpense DateDetailsAmount$
Donuts4/14/2017 bv$3.0
Lunch4/20/2017dbrer$7.6
Parking4/27/2017parking$75.0
4/3/2017 7:15 AMtestclient1
  
02
Expense-typeExpense DateDetailsAmount$
Lunch12/2/2017DXSDFASDF$25.0
6/22/2017 6:59 AMtestclient1
Sign-in to run this demo:
User: sb2013\testclient1
Password: pass@word1

 

Check-out the Repeating Rows Field:

The Repeating Rows column enables you to implement multi-row forms in SharePoint, no need for external propiatery tools such as InfoPath.

We have used the Repeating Rows column to connect the "Expenses" list to the "Expense Details" list, so each expense item may include several expense details items.

Add your own expense report by adding a new item to the "Expenses" list below.

You might notice that:

  1. You can add multiple expense details to each expense item.
  2. The "Cost" column was configured to include SUM function. This summary function was also appears as a column in the list, that can be used in views to filter/sort your data.
  3. While viewing the list below, you can quickly see each expense item's details by simply hovering over the "View Details..." link.
  4. We have used KWizCom Forms settings to add dynamic field constraints:
    Try to add a "Lunch" expense type which is over $30...
 
 
For more details visit the product page on KWizCom website.
 

Got any questions?
Contact us at sales@kwizcom.com