Import from computer

Create a form by importing a file from the computer

  1. Click the Add New icon, displayed at the top of the Design page:

  2. Select FORM, as shown below. If you're creating the first form in your app, you will be taken directly taken to step three.

  4. Select the required file, as given below. Supported file formats include: .xls, .xlsx, .csv, .tsv, .mdb, and .accdb.
    • Drag and drop a file in the window, or​,
    • click to choose the required file, then click From Computer​. This will open the computer's file explorer, through which you can select the required file.

      If you drag and drop, or select a file with an incorrect format, Zoho Creator will alert:

  5. The import interface's Tabular page will appear, as shown below. You will be able to preview the data present in the selected file.

    1. The link name of the app, in which you're creating a form, will be displayed on the top-left of the page
    2. If your file contains multiple sheets, the first sheet will be displayed at the top, followed by the rest. One form will be created per sheet.
      • Uncheck the checkbox next to a sheet if you do not want to import the data it contains
      • Rename a sheet as required
    3. Set Header as. This tells the import process the row that contains the field names.
      • First Row is selected by default:

      • Selecting Second Row will immediately discard the first row:

      • Selecting Blank Row will add a row:

    4. Click on a column's header to perform the following customizations:
      • Customize its Field Name
      • Change its Field Type: By default, a field type is auto-selected based on the data it contains
      • Enable the required Properties: Properties applicable for the selected Field Type will be present
      • Uncheck the checkbox next to Add this column if you do not want to import it

    5. Click the Description icon at the top-right of the page:
      • You can view the number of sheets in the file, and the number of rows and columns across which data is present in each sheet:

      • Navigate to the Settings tab to define what is to happen if an error occurs while importing:

    6. Click Lookup​ to view and establish relationships between the sheets in your file:

  6. Click Create, displayed at the top-right of the page, once you're done selecting and customizing the sheets you want to import. Upon completion of the import process, a prompt will appear:

  7. Click the Expand icon, as shown above. The the number of records successfully created, and the number of failures per sheet, will appear.
  8. Click Access Application to access the newly created form.

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: