Hi,
I have a summary screen which has list of columns that I generated using a Record Type list and not through an interface. How do I put a checkbox using a grid column?
I found this link which talks about the delete functionality but not sure where do I enter this code as I am not able to access the expression editor to the entire summary screen instead I only see individual grid column expression editor.
docs.appian.com/.../recipe-delete-rows-in-a-grid.html
Basically I want to implement delete functionality by selecting each row using checkbox and delete them. Appreciate any help and advance thanks!!
Suneetha.
Discussion posts and replies are publicly visible
Refer to this: https://docs.appian.com/suite/help/21.1/read-only-grid-configuration.html#selection
You can use the selection property on the grid field for the selection and with the click of the button using delete from the datastore entity to delete the data.
Hello Suneetha,
You can use the selectable read-only grid and use the related action field. Using the a!recordActionField. Please make sure you create a process model to delete entries based on the primary key or the identifier. Use this Process model in the record type to create a related action. Then you can use this related action in the read-only grid in the Interface directly.
Thanks, I am able to use the Selection property to enable check box in my grid field. But how do I create a Record List Action to delete multiple records at the same time as per user selects the rows using the checkbox. Is there any sample code for deleting multiple rows from the database using gridField. (like Add a new record to database using Record List Action)
Thanks
For that you can use richtextIcon as a column in the grid. on click of that icon you can delete the row from the DB at the same time. but with checkbox, you have to create a seperate button which can delete the records from the DB
If you want to delete multiple rows you need to use the a!deleteFromDataStoreEntities() function. You can select the rows and store the data in a local variable and use that local variable in the dataToDelete parameter of a!deleteFromDataStoreEntities(). Hopefully this should do the work.
Suneetha: Hello. Nobody got your point, isn't it?
you wanted to add a checkbox here... all along the column...
and you wanted to add the capability of choosing many records and erase them a with button click...
I have noted there is a lot of missunderstandings in the blog. We have to illustrate more to express what we want. Acording to what I have learnt you can not do this here. Because this list is part of the object "record type", and we can not modify this, simply we do not have access to add "selectable" to the grid. May be you know already this, but I write for others that may come later. The best for this purpose is to create our own interface with a selectable grid and develope the multiple records erasing capability.
Regards!