logo image v2.2.0

AutoFill

DataTables Extensions

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

    Choose light or dark mode or Auto

  • Sidebar Theme

    Choose Sidebar Theme

  • Header color

    Choose your Header theme color

  • Accent color

    Choose your primary theme color

  • Sidebar Caption

    Sidebar Caption Hide/Show

  • Theme Layout

    LTR/RTL

  • Layout Width

    Choose Full or Container Layout