Sheets Overview

DronaHQ Studio is a no-code platform that uses a visual development interface to create apps with little or no coding knowledge. Once you log oen to Studio using your organizational authentication you can see a default home page. Among the basic components is the Sheets that you can use in a manner similar to the different databases available. The sheets are designed to seamlessly enable data storage and other data operations and even calculations using the formulas.

Creating sheets

To create a sheet go to Studio > Sheets where you can see all your sheets listed out.

Click + (Add) Sheet button to create a new sheet.

You can add the Sheet in two ways: create a sheet or import a CSV file based on which your sheet would be created. Add a self-explanatory name and click one of the two options to create the new sheet.

Adding a new sheet

If you have selected to create a new sheet you need to define the columns that you want for your sheet. By default, there are a few columns that are present for all sheets, Unique_id, Created_By, and Created_At. They have auto-generated values, you cannot add or change them. Now to add columns of your choice, click +Column, where you can now add the column name and column type.

Once you have added the necessary columns, click Add columns and your sheet is ready.

Importing a CSV

You can create sheets based on an existing CSV file. Typically you can either use only the columns or import it along with the data, thus enabling you to use data from any spreadsheet application.

To create a sheet based on a CSV file , go to Studio > Sheets and click Import CSV to import a .csv file.

choose csv

  • Click Choose a .csv file, and select the file from the source location.

  • You can upload the column and the subsequent data from CSV File. To upload including the data, toggle switch to upload with data.

  • You can also auto-detect the Column Type for the respective Columns. Toggle switch auto detect column type. It shows the extent of accuracy in auto-detect. In case there is any conflict you can change the column type to the appropriate type. Optionally you can set all the column types manually.

  • Once you are satisfied click Upload. The sheet is created with the identified column and the respective data as per your selection.

For further details on importing a CSV file, refer to this article here.

Sheet operations

Now let us understand the different operations that can be performed from the Sheets dashboard.

  • The first two columns are Sheets and Owner which are self-explanatory.

  • Shared with: The next column Shared with provides the details of the other users with the level of access, apps, and sheets sharing the current sheet.

  • Created: Is the date when the sheet is created

  • Schema: Provides a quick view of the schema or the structure of the sheet.

  • Sheet permission: Allows you to view and edit the permissions assigned to the different users, apps, and sheets to access the sheet, like view only, edit, and the environment applicable. Only the sheet owner can assign permission to the respective sheet. Once assigned, the link can be shared with the respective user or notified via an email. Depending on the Sheets Permission, users can view Prod, Beta, and Dev filters in sheets. Depending on which filter is selected, corresponding Sheets data can be viewed. For a detailed understanding of the sheet permissions refer to the article here.

  • Other operations: The more options (three dots) provides you with the other operations applicable to the sheet for the logged-in user. The operations are to delete a sheet, rename a sheet, or duplicate sheet.

Under Studio, Sheets are thus designed to enable ease of data storage and data operations with your custom applications.