Skip Ribbon Commands
Skip to main content

KWizCom Repeating Rows Field Type Demo 

 

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

 

Example: Expense reports

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...
 

 Expenses

 
  
  
  
  
Expense Details
  
Edit
42015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
11/11/2016Lunchbambam$23.00
11/17/2016Lunchoom$29.00
11/9/2016Fuelgutter premo$545.00
$597.00
597
 
42015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
10/10/2016Lunchasddfasdfasd$24.00
10/12/2016Lunchasdfasdfasdf$20.00
$44.00
44
 
102015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
9/13/2016Lunchtest$1.00
9/22/2016Taxitest2$3.00
9/20/2016Fueltest3$3.50
$7.50
7.5
 
72015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
7/26/2016LunchBeef Grill$25.00
7/18/2016FuelMobil$30.00
7/23/2016LunchThree Dollar Cafe$29.00
7/26/2016Taxito airport$24.00
$108.00
108
 
42015SANDBOX2010\testclient1
 
122015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
3/8/2016Lunch1$10.00
3/6/2016Taxi1$10.00
4/27/2016Other3$5.00
5/26/2016LunchSubWay$6.00
$31.00
31
 
72015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
8/18/2015Lunchbest$29.00
8/19/2015Taxisunny$79.00
8/19/2015Fuelgasoline$144.00
1/13/2016Othertoll$25.00
3/8/2016LunchTEST 101$10.00
$287.00
287
 
42015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
6/4/2015LunchLunch$29.99
7/29/2015FuelFuel$30.22
$60.21
60.21
 
42015SANDBOX2010\testclient1
DateExpense TypeDescriptionCost($)
5/28/2015Fuelfdsfdf$323.00
5/29/2015Taxi31232$23.00
$346.00
346
 
42014SANDBOX2010\Administrator
DateExpense TypeDescriptionCost($)
4/9/2014TaxiTSCC conference - taxi to airport$63.00
4/9/2014LunchLunch at the airport$29.90
5/28/2015FuelSAMPLE TEST BB SYDT$12.00
$104.90
104.9
 

 

Sign-in to run this demo:
User: sandbox2010\testclient1
Password: pass@word1
 
 
For more details visit the Repeating Rows product page.
 
Got any questions?
Contact us at sales@kwizcom.com