If we want to edit and make changes to our database, we can by opening the Data View screen, and then by clicking the "Edit" button:
In the EDITION mode of the Database we can:
- Add rows (cells) and elements
- Delete rows and elements
- Rename each column
- Change the Data Type of each column
- Delete a column
ADD ROWS AND ELEMENTS
If we need to add rows, then we only need to type some element within the cell of the first row and automatically a new row will be added.
DELETE ROWS AND ELEMENTS
We can delete rows by simply clicking the "bin" button, as in the following picture:
At the right side of each column there is a settings button that we can use to rename each column, to change the data type and to delete the column.
RENAME EACH COLUMN
The first button allows us to rename the column. We must click on it to type another name.
CHANGE THE DATA TYPE OF EACH COLUMN
The second button lets us change the data type.
We can choose from: text, number, date, data set, location, image, remote image, audio, remote audio, video, remote video.
DELETE A COLUMN
The third button allows us to delete the column with the data.
Finally there is a button to set the ADVANCED OPTIONS
When clicking the button we can choose among 3 options:
If we have already created a database on our PC, we can import it into Mobincube by clicking the "Import Data" button.
The format for importing into Mobincube must be a CSV file and to be accepted it must have the same structure of the database created in Mobincube (same number of columns and same names).
If we have a database with many records and we do not want to write them, we can export the database file which contains them and then import it from Mobincube.
We can export the data in CSV format or in SQLITE.
- Change hours
If in a date or a dataset column, we need to use the time zone of another Country or to adapt the date to the time zone of our editing panel. We can add or subtract the number of hours or use the pink button to adapt it to our time zone.
- Link to the CLOUD
If we are using the Cloud as external server, we can upload the database we have locally (offline) to the Cloud (online) to update our database remotely. This allows for automatic changes in the App, already published and downloaded.
In order to link the database to the Cloud, we must click the button next to the icon of the cloud, as in the following picture:
When clicking the button, a window will be shown and it will ask us if we are sure to export the collection and it will warn us that all data will be converted to online collection, and all images fields into remote images.
If we confirm it, the database will be converted to remote and we will visualize the button to access the Cloud.
* NOTE: IF WE WANT TO ADD OR REMOVE COLUMNS, CHANGE DATA OR RENAME THE COLUMN TYPE, WE MUST SET THE DATABASE LOCALLY AGAIN, DISCONNECTING IT FROM THE CLOUD.
ONCE WE HAVE MADE THE CHANGES (AS WE HAVE CHANGED THE STRUCTURE OF THE DATABASE), WE NEED TO LINK IT TO THE CLOUD AGAIN AND REPUBLISH THE APP IN ORDER TO SEE THE CHANGES.