Spreadsheets such as Excel and Google Docs have a very handy rapid data duplication auto fill UI method.
Name
Position
Office
Age
Start date
Salary
Tiger Nixon
System Architect
Edinburgh
61
2015/04/25
$320,800
Garrett Winters
Accountant
Tokyo
63
2015/07/25
$170,750
Ashton Cox
Junior Technical Author
San Francisco
66
2016/01/12
$86,000
Cedric Kelly
Senior Javascript Developer
Edinburgh
22
2017/03/29
$433,060
Airi Satou
Accountant
Tokyo
33
2018/11/28
$162,700
Brielle Williamson
Integration Specialist
New York
61
2017/12/02
$372,000
Herrod Chandler
Sales Assistant
San Francisco
59
2017/08/06
$137,500
Rhona Davidson
Integration Specialist
Tokyo
55
2019/10/14
$327,900
Colleen Hurst
Javascript Developer
San Francisco
39
2016/09/15
$205,500
Sonya Frost
Software Engineer
Edinburgh
23
2018/12/13
$103,600
Jena Gaines
Office Manager
London
30
2018/12/19
$90,560
Quinn Flynn
Support Lead
Edinburgh
22
2020/03/03
$342,000
Charde Marshall
Regional Director
San Francisco
36
2018/10/16
$470,600
Haley Kennedy
Senior Marketing Designer
London
43
2017/12/18
$313,500
Tatyana Fitzpatrick
Regional Director
London
19
2019/03/17
$385,750
Michael Silva
Marketing Designer
London
66
2017/11/27
$198,500
Paul Byrd
Chief Financial Officer (CFO)
New York
64
2019/06/09
$725,000
Gloria Little
Systems Administrator
New York
59
2016/04/10
$237,500
Bradley Greer
Software Engineer
London
41
2017/10/13
$132,000
Dai Rios
Personnel Lead
Edinburgh
35
2017/09/26
$217,500
Jenette Caldwell
Development Lead
New York
30
2015/09/03
$345,000
Yuri Mantis
Chief Marketing Officer (CMO)
New York
40
2016/06/25
$675,000
Caesar Vance
Pre-Sales Support
New York
21
2015/12/12
$106,450
Doris Wilder
Sales Assistant
Sidney
23
2019/09/20
$85,600
Angelica Ramos
Chief Executive Officer (CEO)
London
47
2016/10/09
$1,200,000
Gavin Joyce
Developer
Edinburgh
42
2019/12/22
$92,575
Jennifer Chang
Regional Director
Singapore
28
2019/11/14
$357,650
Brenden Wagner
Software Engineer
San Francisco
28
2015/06/07
$206,850
Fiona Green
Chief Operating Officer (COO)
San Francisco
48
2019/03/11
$850,000
Shou Itou
Regional Marketing
Tokyo
20
2015/08/14
$163,000
Name
Position
Office
Age
Start date
Salary
KeyTable Integration
If you are looking to emulate the UI of spreadsheet programs such as Excel with DataTables, the combination of KeyTable
and AutoFill will take you a long way there!
Name
Position
Office
Age
Start date
Salary
Tiger Nixon
System Architect
Edinburgh
61
2015/04/25
$320,800
Garrett Winters
Accountant
Tokyo
63
2015/07/25
$170,750
Ashton Cox
Junior Technical Author
San Francisco
66
2016/01/12
$86,000
Cedric Kelly
Senior Javascript Developer
Edinburgh
22
2017/03/29
$433,060
Airi Satou
Accountant
Tokyo
33
2018/11/28
$162,700
Brielle Williamson
Integration Specialist
New York
61
2017/12/02
$372,000
Herrod Chandler
Sales Assistant
San Francisco
59
2017/08/06
$137,500
Rhona Davidson
Integration Specialist
Tokyo
55
2019/10/14
$327,900
Colleen Hurst
Javascript Developer
San Francisco
39
2016/09/15
$205,500
Sonya Frost
Software Engineer
Edinburgh
23
2018/12/13
$103,600
Jena Gaines
Office Manager
London
30
2018/12/19
$90,560
Quinn Flynn
Support Lead
Edinburgh
22
2020/03/03
$342,000
Charde Marshall
Regional Director
San Francisco
36
2018/10/16
$470,600
Haley Kennedy
Senior Marketing Designer
London
43
2017/12/18
$313,500
Tatyana Fitzpatrick
Regional Director
London
19
2019/03/17
$385,750
Michael Silva
Marketing Designer
London
66
2017/11/27
$198,500
Paul Byrd
Chief Financial Officer (CFO)
New York
64
2019/06/09
$725,000
Gloria Little
Systems Administrator
New York
59
2016/04/10
$237,500
Bradley Greer
Software Engineer
London
41
2017/10/13
$132,000
Dai Rios
Personnel Lead
Edinburgh
35
2017/09/26
$217,500
Jenette Caldwell
Development Lead
New York
30
2015/09/03
$345,000
Yuri Mantis
Chief Marketing Officer (CMO)
New York
40
2016/06/25
$675,000
Caesar Vance
Pre-Sales Support
New York
21
2015/12/12
$106,450
Doris Wilder
Sales Assistant
Sidney
23
2019/09/20
$85,600
Angelica Ramos
Chief Executive Officer (CEO)
London
47
2016/10/09
$1,200,000
Gavin Joyce
Developer
Edinburgh
42
2019/12/22
$92,575
Jennifer Chang
Regional Director
Singapore
28
2019/11/14
$357,650
Brenden Wagner
Software Engineer
San Francisco
28
2015/06/07
$206,850
Fiona Green
Chief Operating Officer (COO)
San Francisco
48
2019/03/11
$850,000
Shou Itou
Regional Marketing
Tokyo
20
2015/08/14
$163,000
Name
Position
Office
Age
Start date
Salary
Column Selector
This ability to exclude columns from the AutoFill action can be particularly useful if the table contains non-data
columns. This example uses the Select extension for DataTables to allow row selection through the select option
Name
Position
Office
Age
Salary
Tiger Nixon
System Architect
Edinburgh
61
$320,800
Garrett Winters
Accountant
Tokyo
63
$170,750
Ashton Cox
Junior Technical Author
San Francisco
66
$86,000
Cedric Kelly
Senior Javascript Developer
Edinburgh
22
$433,060
Airi Satou
Accountant
Tokyo
33
$162,700
Brielle Williamson
Integration Specialist
New York
61
$372,000
Herrod Chandler
Sales Assistant
San Francisco
59
$137,500
Rhona Davidson
Integration Specialist
Tokyo
55
$327,900
Colleen Hurst
Javascript Developer
San Francisco
39
$205,500
Sonya Frost
Software Engineer
Edinburgh
23
$103,600
Jena Gaines
Office Manager
London
30
$90,560
Quinn Flynn
Support Lead
Edinburgh
22
$342,000
Charde Marshall
Regional Director
San Francisco
36
$470,600
Haley Kennedy
Senior Marketing Designer
London
43
$313,500
Tatyana Fitzpatrick
Regional Director
London
19
$385,750
Michael Silva
Marketing Designer
London
66
$198,500
Paul Byrd
Chief Financial Officer (CFO)
New York
64
$725,000
Name
Position
Office
Age
Salary
Scrolling DataTable
When dragging an AutoFill handle, the table (if DataTables scrolling is enabled) or the window will be automatically
scrolled