Adding record to a table via Studio. Edit, and delete options
  • 16 Jul 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Adding record to a table via Studio. Edit, and delete options

  • Dark
    Light
  • PDF

Article summary

Adding a record to a Feature Table via the Data Source

The first method is to add a new record to the feature table via the Data Source section

Option

Description

Visualization

Open feature table list

  • On the "Project List" page, expand the "Data Source" section

  • In the left navigation panel, click "Tables"

Select feature table

  • From the list of "Tables," open the appropriate one where a new record should be added

Open the "Data" tab

  • The Data tab contains all previously created records and allows adding, editing, and deleting records

    • For background (BG) layers, all these options are disabled

    • For feature tables with geometry, only the Edit and Delete options are available

    • Editing is not available for fields such as "GlobalID,"  "ObjectID,"  "Shape_Area," and "Shape_Length"

Add new record

  • After clicking on the "ADD RECORD" button, the pop-up with empty fields will appear

Filling fields

  • Fill all fields with valid data

  • The fields may vary, depending on the table’s needs and requirements

Save

  • Presses the "Save" button

    • A pop-up saying "Feature has been successfully created" should appear

  • After saving, a new record should appear in the table containing all the previously entered information

Editing records via the Data Source

For the Data Source tables, all actions (e.g., Add, Edit, Delete) are enabled by default

Option

Description

Visualization

Open feature table list

  • On the "Project List" page, expand the "Data Source" section

  • In the left navigation panel, click "Tables"

Select feature table

  • Open the appropriate "Feature Table"

Open the "Data" tab

  • The Data tab contains all previously created records and allows adding, editing, and deleting records

    • For background (BG) layers, all these options are disabled

    • For feature tables with geometry, only the Edit and Delete options are available

    • Editing is not available for fields such as "GlobalID,"  "ObjectID,"  "Shape_Area," and "Shape_Length"

Editing

  • Click on the "Edit" button

Change the data

  • Modify the values in the required fields

Save

  • Click the "Save" button to apply changes to the record

Edited record

  • The changes should be reflected on the page

Deleting records via the Data Source

For the Data Source tables, all actions (e.g., Add, Edit, Delete) are enabled by default

Option

Description

Visualization

Open feature table list

  • On the "Project List" page, expand the "Data Source" section

  • In the left navigation panel, click "Tables"

Select feature table

  • Open the appropriate "Feature Table"

Open the "Data" Tab

  • The Data tab contains all previously created records and allows adding, editing, and deleting records

    • For background (BG) layers, all these options are disabled

    • For feature tables with geometry, only the Edit and Delete options are available

    • Editing is not available for fields such as "GlobalID,"  "ObjectID,"  "Shape_Area," and "Shape_Length"

Deleting

  • Click on the "Delete" button

Confirm deletion

  • Click "Yes" to confirm the deletion of this record

    • After pressing the "Yes" button, a pop-up saying "1 feature has been successfully deleted" should appear

Adding a record to a Feature Table via the Studio Project

The second method is to add a new record via the Studio project

Addi in Studio functions similar to Data Source, but users can manually enable or disable it for specific pages

Once adding is enabled, it becomes accessible to all users in the Studio and on the Clarion website

Option

Description

Visualization

Open Studio

  • On the "Workspace List" page, double-click on a needed project from the list to open it

Open the required page

  • Click on the "Pages" button

  • Select the required page

Edit feature table

  • Click on the proper Feature Table

  • Click on the "Edit" pencil icon to open the Feature Table settings page

"Allow Add" action

  • Make sure that the "Allow Add" action is enabled

  • If "Allow Add" is disabled, follow the "Add Record Template" instructions

Add new record

  • After clicking on the "ADD RECORD" button, the pop-up with empty fields will appear

Filling fields

  • Fill all fields with valid data.

  • The fields may vary, depending on the table’s needs and requirements

Save

  • Presses the "Save" button

    • A pop-up saying "Feature has been successfully created" should appear

  • After saving, a new record should appear in the table containing all the previously entered information

Editing records via a Studio Project

Editing in Studio functions similarly to Data Source, but users can manually enable or disable it for specific pages

Once editing is enabled, it becomes accessible to all users in the Studio and on the Clarion website

Option

Description

Visualization

Open Studio

  • On the "Workspace List" page, double-click on a needed project from the list to open it

Open the required page

  • Click on the "Pages" button

  • Select the required page

Edit feature table

  • Click on the proper Feature Table

  • Click on the "Edit" pencil icon to open the "Feature Table" settings page

Allow edit

  • Enable the "Allow Edit" action

  • Click "Save" to enable the marked actions

Editing

  • Click on the "Edit" button

Change the data

  • Modify the values in the required fields

Save

  • Click the "Save" button to apply changes to the record

Edited record

  • The changes should be reflected on the page

Deleting records via a Studio Project

Deleting in Studio functions similarly to Data Source, but users can manually enable or disable it for specific pages

Once deleting is enabled, it becomes accessible to all users in the Studio and on the Clarion website

Option

Description

Visualization

Open Studio

  • On the "Workspace List" page, double-click on a needed project from the list to open it

Open the required page

  • Click on the "Pages" button

  • Select the required page

Edit feature table

  • Click on the proper Feature Table

  • Click on the "Edit" pencil icon to open the "Feature Table" settings page

Allow to delete

  • Enable the "Allow Delete" action

  • Click "Save" to enable the marked actions

Deleting

  • Click on the "Delete" button

Confirm deletion

  • Click "Yes" to confirm the deletion of this record

    • After pressing the "Yes" button, a pop-up saying "1 feature has been successfully deleted" should appear