Auto Fill
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
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
Mantis Customizer