AutoFill

The features that DataTables provides can be greatly enhanced by the use of the plug-ins available on this page, which give many new user interaction and configuration options.

Reference
Auto Fill
Spreadsheets such as Excel and Google Docs have a very handy rapid data duplication auto fill UI method.
NamePositionOfficeAgeStart dateSalary
Tiger NixonSystem ArchitectEdinburgh612015/04/25$320,800
Garrett WintersAccountantTokyo632015/07/25$170,750
Ashton CoxJunior Technical AuthorSan Francisco662016/01/12$86,000
Cedric KellySenior Javascript DeveloperEdinburgh222017/03/29$433,060
Airi SatouAccountantTokyo332018/11/28$162,700
Brielle WilliamsonIntegration SpecialistNew York612017/12/02$372,000
Herrod ChandlerSales AssistantSan Francisco592017/08/06$137,500
Rhona DavidsonIntegration SpecialistTokyo552019/10/14$327,900
Colleen HurstJavascript DeveloperSan Francisco392016/09/15$205,500
Sonya FrostSoftware EngineerEdinburgh232018/12/13$103,600
Jena GainesOffice ManagerLondon302018/12/19$90,560
Quinn FlynnSupport LeadEdinburgh222020/03/03$342,000
Charde MarshallRegional DirectorSan Francisco362018/10/16$470,600
Haley KennedySenior Marketing DesignerLondon432017/12/18$313,500
Tatyana FitzpatrickRegional DirectorLondon192019/03/17$385,750
Michael SilvaMarketing DesignerLondon662017/11/27$198,500
Paul ByrdChief Financial Officer (CFO)New York642019/06/09$725,000
Gloria LittleSystems AdministratorNew York592016/04/10$237,500
Bradley GreerSoftware EngineerLondon412017/10/13$132,000
Dai RiosPersonnel LeadEdinburgh352017/09/26$217,500
Jenette CaldwellDevelopment LeadNew York302015/09/03$345,000
Yuri MantisChief Marketing Officer (CMO)New York402016/06/25$675,000
Caesar VancePre-Sales SupportNew York212015/12/12$106,450
Doris WilderSales AssistantSidney232019/09/20$85,600
Angelica RamosChief Executive Officer (CEO)London472016/10/09$1,200,000
Gavin JoyceDeveloperEdinburgh422019/12/22$92,575
Jennifer ChangRegional DirectorSingapore282019/11/14$357,650
Brenden WagnerSoftware EngineerSan Francisco282015/06/07$206,850
Fiona GreenChief Operating Officer (COO)San Francisco482019/03/11$850,000
Shou ItouRegional MarketingTokyo202015/08/14$163,000
NamePositionOfficeAgeStart dateSalary
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!
NamePositionOfficeAgeStart dateSalary
Tiger NixonSystem ArchitectEdinburgh612015/04/25$320,800
Garrett WintersAccountantTokyo632015/07/25$170,750
Ashton CoxJunior Technical AuthorSan Francisco662016/01/12$86,000
Cedric KellySenior Javascript DeveloperEdinburgh222017/03/29$433,060
Airi SatouAccountantTokyo332018/11/28$162,700
Brielle WilliamsonIntegration SpecialistNew York612017/12/02$372,000
Herrod ChandlerSales AssistantSan Francisco592017/08/06$137,500
Rhona DavidsonIntegration SpecialistTokyo552019/10/14$327,900
Colleen HurstJavascript DeveloperSan Francisco392016/09/15$205,500
Sonya FrostSoftware EngineerEdinburgh232018/12/13$103,600
Jena GainesOffice ManagerLondon302018/12/19$90,560
Quinn FlynnSupport LeadEdinburgh222020/03/03$342,000
Charde MarshallRegional DirectorSan Francisco362018/10/16$470,600
Haley KennedySenior Marketing DesignerLondon432017/12/18$313,500
Tatyana FitzpatrickRegional DirectorLondon192019/03/17$385,750
Michael SilvaMarketing DesignerLondon662017/11/27$198,500
Paul ByrdChief Financial Officer (CFO)New York642019/06/09$725,000
Gloria LittleSystems AdministratorNew York592016/04/10$237,500
Bradley GreerSoftware EngineerLondon412017/10/13$132,000
Dai RiosPersonnel LeadEdinburgh352017/09/26$217,500
Jenette CaldwellDevelopment LeadNew York302015/09/03$345,000
Yuri MantisChief Marketing Officer (CMO)New York402016/06/25$675,000
Caesar VancePre-Sales SupportNew York212015/12/12$106,450
Doris WilderSales AssistantSidney232019/09/20$85,600
Angelica RamosChief Executive Officer (CEO)London472016/10/09$1,200,000
Gavin JoyceDeveloperEdinburgh422019/12/22$92,575
Jennifer ChangRegional DirectorSingapore282019/11/14$357,650
Brenden WagnerSoftware EngineerSan Francisco282015/06/07$206,850
Fiona GreenChief Operating Officer (COO)San Francisco482019/03/11$850,000
Shou ItouRegional MarketingTokyo202015/08/14$163,000
NamePositionOfficeAgeStart dateSalary
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
NamePositionOfficeAgeSalary
Tiger NixonSystem ArchitectEdinburgh61$320,800
Garrett WintersAccountantTokyo63$170,750
Ashton CoxJunior Technical AuthorSan Francisco66$86,000
Cedric KellySenior Javascript DeveloperEdinburgh22$433,060
Airi SatouAccountantTokyo33$162,700
Brielle WilliamsonIntegration SpecialistNew York61$372,000
Herrod ChandlerSales AssistantSan Francisco59$137,500
Rhona DavidsonIntegration SpecialistTokyo55$327,900
Colleen HurstJavascript DeveloperSan Francisco39$205,500
Sonya FrostSoftware EngineerEdinburgh23$103,600
Jena GainesOffice ManagerLondon30$90,560
Quinn FlynnSupport LeadEdinburgh22$342,000
Charde MarshallRegional DirectorSan Francisco36$470,600
Haley KennedySenior Marketing DesignerLondon43$313,500
Tatyana FitzpatrickRegional DirectorLondon19$385,750
Michael SilvaMarketing DesignerLondon66$198,500
Paul ByrdChief Financial Officer (CFO)New York64$725,000
NamePositionOfficeAgeSalary
Scrolling DataTable
When dragging an AutoFill handle, the table (if DataTables scrolling is enabled) or the window will be automatically scrolled
NamePositionOfficeAgeStart dateSalary
Tiger NixonSystem ArchitectEdinburgh612015/04/25$320,800
Garrett WintersAccountantTokyo632015/07/25$170,750
Ashton CoxJunior Technical AuthorSan Francisco662016/01/12$86,000
Cedric KellySenior Javascript DeveloperEdinburgh222017/03/29$433,060
Airi SatouAccountantTokyo332018/11/28$162,700
Brielle WilliamsonIntegration SpecialistNew York612017/12/02$372,000
Herrod ChandlerSales AssistantSan Francisco592017/08/06$137,500
Rhona DavidsonIntegration SpecialistTokyo552019/10/14$327,900
Colleen HurstJavascript DeveloperSan Francisco392016/09/15$205,500
Sonya FrostSoftware EngineerEdinburgh232018/12/13$103,600
Jena GainesOffice ManagerLondon302018/12/19$90,560
Quinn FlynnSupport LeadEdinburgh222020/03/03$342,000
Charde MarshallRegional DirectorSan Francisco362018/10/16$470,600
Haley KennedySenior Marketing DesignerLondon432017/12/18$313,500
Tatyana FitzpatrickRegional DirectorLondon192019/03/17$385,750
Michael SilvaMarketing DesignerLondon662017/11/27$198,500
Paul ByrdChief Financial Officer (CFO)New York642019/06/09$725,000
Gloria LittleSystems AdministratorNew York592016/04/10$237,500
Bradley GreerSoftware EngineerLondon412017/10/13$132,000
Dai RiosPersonnel LeadEdinburgh352017/09/26$217,500
Jenette CaldwellDevelopment LeadNew York302015/09/03$345,000
Yuri MantisChief Marketing Officer (CMO)New York402016/06/25$675,000
Caesar VancePre-Sales SupportNew York212015/12/12$106,450
Doris WilderSales AssistantSidney232019/09/20$85,600
Angelica RamosChief Executive Officer (CEO)London472016/10/09$1,200,000
Gavin JoyceDeveloperEdinburgh422019/12/22$92,575
Jennifer ChangRegional DirectorSingapore282019/11/14$357,650
Brenden WagnerSoftware EngineerSan Francisco282015/06/07$206,850
Fiona GreenChief Operating Officer (COO)San Francisco482019/03/11$850,000
Shou ItouRegional MarketingTokyo202015/08/14$163,000
NamePositionOfficeAgeStart dateSalary
Settings
Theme Mode

Light / Dark / System

  • Sidebar theme

    Light / Dark

  • Sidebar Caption

    Hide/Show

  • Theme Layout

    LTR/RTL

  • Layout Width

    Full / Fixed