I gather the best way to store tabular data in EPiServer is by using the Dynamic Data Store, but how could I allow editors to create new and edit current rows in my tabular data from within Edit Mode?
Here is my example: I need to store employee information. Each employee has the following information...
Name, Age, Role, Salary, Email Address
...obviously I can create a Data Store called "employee" with these fields, but how do I allow editors to add new employees from within Edit Mode, delete employees and edit them too?
I gather there is a plugin to allow the editing of all Dynamic Data within EPiServer but I don't want editors breaking something by editing a Data Store I do not wish for them to see.
Any help greatly receieved :-)
Agreed - don't give your editors access to an admin-level DDS tool.
I'm interpreting your question as wanting to build a datagrid view which supports inline editing, so you can change cells in each row with save/update/delete functionality, kind of like Excel. Apologies if my interpretation is off.
Creating an editable grid should be fairly easy - roughly:
That should get you started, though there are probably sexier ways to do it.
That should work OK if I am able to allow them to create new records too.
Is there a way to allow editors this functionality from with the CMS area, rather than using a published page in a new area of the site? I'm hoping I can keep everything together in one place you see.
Maybe this will help?
Limiting the CRUD functionality to only be available when PageEditing.PageIsInEditMode is true may be the way forward?
Thanks, I'll give it a whirl :-)
If you need edit functionality I would probably store employees as pages/container pages. If it is a "fair" amount of employees that is. :)