Creating Tables

what are tables? tables are the foundation of hunni tables can contain data or files tables can be shared internally or externally table data can be accessed directly or indirectly through views tables and table data can be modified using the hunni api you can create a new table by either 1 uploading from an excel file or 2 using the table builder creating tables /#uploading a new table creating tables /#create a new table using the table builder uploading tables uploading a new table 1\ prepare your table start by making sure your table is setup so hunni can read your data the table should be in the first sheet of your excel workbook starting in cell a1 your top row should contain names for each column no empty columns or rows inside your table your excel file should be in xlsx or csv format if you want to add a file column, after uploading you can edit the table in the table builder 2\ go to desired table location in the assets dashboard next, you'll want to navigate to where you'll want the table to be stored in your folders in the assets dashboard you can always change an asset's location later by selecting the asset and click the edit > location button 3\ select upload > new table button once you are in your desired table location, click the upload button in the top right of the asset nav window and select upload new table from the dropdown 4\ click the "browse" button to select the excel file with your table hunni will scan your file to make sure your layout is good and detect the types of data in your columns for the next step this make take longer for larger tables 5\ choose table name and column types next you'll pick a table name and choose your column types if you don't see an expected column type , that means we detected data in that column that wouldn't fit that column type for example, if you have decimal numbers in a column, you won't be able to select an integer column type you cannot upload data to file columns uploading a file id or a file name will not associate it to a row files must be uploaded through the expanded grid row editor or through the api code examples docid\ n3w2kf2 cfm3ihf3 rbvu choose column types carefully currently, you cannot edit a column type after it's been chosen if you'd like to change a column type, you will need to edit the table, create a new column with the new column type, then transfer the data to the new column after uploading, you can adjust display formats for decimal and integer columns in the table builder by selecting the table and clicking edit >structure details 6\ upload after making your selections, click the "complete" button , and your table will upload if your table is large, you may recieve a pop up asking if you'd like to recieve an email, when it's ready to be accessed most tables with over a million data values could take a couple minutes to upload if you recieved an error, double check your table layout against the instructions in step 1 if you continue to have issues, please email support\@hunni io please attach the table you are trying to upload you can also submit a support request by clicking the question mark icon from the banner menu in the top right and selecting " contact support" from the dropdown uploading new rows to an existing table 1\ prepare your upload table when uploading new rows to an existing table, your upload table needs to match the structure of the hunni table you are uploading to, including the "hunni id" column in column a first row should match the column names and order of the existing table if you are editing rows in the same upload the first column must be a "hunni id" column leave this column blank for any new rows to be added you can use this same upload process to edit table rows, by including the hunni id of rows you wish to replace see editing table data docid 1 omie2 22vlu 5ospb9d make sure your upload table data matches the column types of the table you are uploading to you can check the column types by selecting the table, then clicking edit >structure/details 2\ select the table to add rows to in the assets dashboard once your upload table is ready, navigate to the existing table in the assets dashboard and select it 3\ select upload > upload to selected table click the upload button in the top right of the asset nav window and select upload to selected table from the dropdown 4\ click the "browse" button to select the excel file with your table 5\ upload after selecting your file, the new rows will be added to the table if you recieved an error, double check your table layout to make sure it matches the below is an example format of an upload table with new rows and edits in the same table table builder use the table builder to create a new table, by first defining its structure (column names, column types, description), then adding data/files to it later edit an existing table's structure/details use the table builder to add file columns to tables create a new table using the table builder 1\ go to desired table location in the assets dashboard first, you'll want to navigate to where you'll want the new table to be stored in your folders in the assets dashboard you can always change an asset's location later, by selecting the asset and click the edit > location button 2\ select new >table click the " new " button in the top right of the asset nav window and select table from the dropdown 3\ build table choose column name and type , then click the "add column" button click and drag columns to change column ordering click the pencil button to edit a column the "required" column indicates whether a new row can be added with empty data in that column (yes = column cannot be empty, no = column can be empty) use the "column display format" column to adjust display formatting for interger and decimal columns name your table and give it a description after you click save table, your table will be available in the assets dashboard you can then creating tables /#uploading new rows to an existing table to the table using an excel file, or use the excel add in to add rows directly from excel see using the excel add in docid\ csq1t zq9n61xwwnkacza for more info