List edit in a Data table widget

brittany_sorrel · ‎02-20-2018

Hi all,

I've embedded the Data table with Filter widget into a custom widget and now trying to see if it is possible to perform a list edit action on the table. I've searched through the community and haven't found anything yet.

I'm doubtful that the Data table with Filter widget will allow me to perform inline edits based on what the code was showing, but I wanted to ask if anyone has found a workaround for this limitation. Or do I need to use a different widget to be able to do inline list editing?

Thanks,

~britt

Jon Barnes · ‎02-20-2018

I put it inside the td. but there are a few other issues that I had to overcome in that the sp-editable-field directive requires a data model that you would normally get from the $sp.getForm call. But I didn't want to call that for every record in the list, so created a custom script include to give me the data I needed for each field. If you think of a better way, let me know, but here is the update set for what I did. hope that helps you.

View solution in original post

SamuelTse · ‎02-16-2022

I believe all you need is to modify the list view of that table. If you didn't create a specific view for this data table, it may be called "mobile". Just go to the list view of the table in the backend Servicenow and reorder it there.

Lisa Silvaroli · ‎11-15-2021

Jon,

I am using your editable list and it is great! Thank you for sharing it. I was just curious if this one is the most recent version or if you have updated and posted it elsewhere?

I noticed that the functionality of clicking on the "i" icon or on the record itself does not actually open up the record to view it, is there a way to fix that?

SamuelTse · ‎02-07-2022

Hi Jon,

Thanks for sharing this widget. It is awesome and it works well in our project.

I ran into a problem with the List field type. It doesn't seem to work when it contains multiple values. I suspect it has something to how the data source was defined. Are you able to shed some light as to how to fix it? I know List works for sp-editable-field out of the box. I hope you can help.

Thanks again for your time and for sharing this widget.

Sam

NihSri · ‎09-25-2023

Hi Jon, Thanks for sharing the code. I find it really helpful. I am using the same code shared by you. It does make the table editable however, the table records can only be seen with admin role. When I am trying to impersonate other users with the required roles the records are not shown. To specify, the users have access to the records in the platform view in ServiceNow and the table that I am using is a custom table. Any suggestions?

NihSri · ‎09-25-2023

Hi Jon , Thanks for sharing the code. I find it really helpful. I am using the same code shared by you. It does make the table editable however, the table records can only be seen with admin role. When I am trying to impersonate other users with the required roles the records are not shown. To specify, the users have access to the records in the platform view in ServiceNow and the table that I am using is a custom table. Any suggestions?