Skip to main content
vishwass0329
vishwass0329
February 14, 2024
Question

Regarding editable grid

  • February 14, 2024
  • 10 replies
  • 0 views
I have a query regarding editable grid, I have seen your video of editable grid.
I want to remove data on single click from the interface. And wouldn't be reflect 
on the grid after deleting it. But it should be soft delete not hard delete.

    10 replies

    konduruc733182
    konduruc733182
    February 14, 2024

    Hello [mention:d7d669d78ce84e26943b9fd9b575165d:e9ed411860ed4f2ba0265705b8793d05] 
    You might have referred edit, remove on an editable grid on Documentation hopefully, so suggest the below.

    In your component richTextDisplayField inside the a!richTextIcon in the link parameter use the below

    link: a!dynamicLink(

    saveInto: a!save(fv!item.fieldIsActive, false()) 

    )

    instead of remove()

    that would help. If you are not having any field as isActive i would recommend to add it, as it would be helpful for such situations. In the showWhen parameter of your row please add the isActive field to define it accordingly.

      vishwass0329
      vishwass0329Author
      February 15, 2024

      Thanks for reply.

      I want to delete and update the rows in the editable grid. Deleting the data from interface should not affect the database.

      Only the value of field "isdeleted"  should change from o to 1. "1" if data has been deleted from interface and "0" id data is not deleted

      mikes0011
      mikes0011
      Brainy
      February 15, 2024
      I want to delete and update the rows in the editable grid.

      Then you would simply make the grid not show a row entry for rows in the data where i.e. "fv!item.isDeleted = 1".

      stefanhelzle0001
      stefanhelzle0001
      February 14, 2024

      What do you mean with "soft delete"? A "undo" function in the UI, or only a deactivation of data in the DB?

      vishwass0329
      vishwass0329Author
      February 15, 2024

      "Soft delete" means data should not be removed from database after once I clicked on delete icon in interface. Row should only be removed from interface until "Isdelete(boolean type field in database) value is 1". 

      I want to delete and update the rows in the editable grid. Deleting the data from interface should not affect the database.

      Only the value of field "isdeleted"  should change from o to 1. "1" if data has been deleted from interface and "0" id data is not deleted

      stefanhelzle0001
      stefanhelzle0001
      February 15, 2024

      Hm ... that is the default. Appian does not do anything to your database until you write data back using the writeRecords() function or the Write Records smart service.

      For this to work, you do not need to add any fields.

      Terms & ConditionsAccessibility statement