Editing Fields in a Database

So, when you're dealing with a database, making changes such as modifying, adding, or deleting fields is pretty straightforward. It's just a matter of a few simple steps.

Editing a Field

To edit fields in a database:

1. On the Lucy app homepage, head to the My Work tab on the left sidebar.

2. All the folders you have created, as well as those created by others, will be listed.

3. If you cannot locate the folder in the list, type in the folder name under Search Folders.

4. Click on the folder you wish to open.

5. Jump to the Databases tab.

6. Search and select the database you wish to edit fields.

7. Hover over the database and click the Edit icon that appears.

8. Select the field you want to edit and enter the new field name.

9. Modify the respective field's data type by selecting a different data type if needed.

10. Once you have made the required modifications, click Update Database. All the changes made to the database will be applied.

Adding a New Field

To add a new field:

1. On the Lucy app homepage, head to the My Work tab on the left sidebar.

2. All the folders you have created, as well as those created by others, will be listed.

3. If you cannot locate the folder in the list, type in the folder name under Search Folders.

4. Click on the folder you wish to open.

5. Jump to the Databases tab.

6. Search and select your database.

7. Hover over it and click Edit icon that appears.

8. Click Add New Field button.

9. A blank field and its corresponding type will be included in the field list, allowing you to input the field name and its type.

Deleting a Field

To delete an existing field in a database:

1. On the Lucy app homepage, head to the My Work tab on the left sidebar.

2. All the folders you have created, as well as those created by others, will be listed.

3. If you cannot locate the folder in the list, type in the folder name under Search Folders.

4. Click on the folder you wish to open.

5. Jump to the Databases tab.

6. Search and select your database.

7. Hover over it and click Edit icon that appears.

8. Select the field you want to delete and click respective Delete button.

9. Click Update Database. All the changes made to the database will be applied.

Saving the Changes

Once you've made required modifications to your database fields, you need to save it.

To save the changes:

1. On the Lucy app homepage, head to the My Work tab on the left sidebar.

2. All the folders you have created, as well as those created by others, will be listed.

3. If you cannot locate the folder in the list, type in the folder name under Search Folders.

4. Click on the folder you wish to open.

5. Jump to the Databases tab.

6. Search and select your database.

7. Hover over it and click Edit icon that appears.

8. Click Update Database.