Allowing users to add new row and column

Hello,
 
Thank you for reaching out to us.
 
Please note that Flexmonster is a tool for data visualization rather than the editor. Therefore, we do not provide in-built functionality for modifying the data.
 
Still, we could research possible workarounds based on the data source used in your specific case.
Please let us know what data source is used in your project (plain CSV/JSON file, database, etc.) and how the connection is implemented (direct link, inline data, Flexmonster Data Server, etc.).
Also, please clarify if you want to modify the data in the data source itself or make temporary changes on the client side without affecting the dataset.
 
We are looking forward to hearing from you.
 
Kind regards,
Illia

Hello,
 
Thank you for the details.
 
If we understand correctly, the data will come from locally saved CSV/JSON files in most cases.
Editing these files would require operating with an OS file system. Modern browsers do not have permission to access the file system without manual navigation performed by the user.
It implies significant limitations on two processes required to implement desired functionality:

1. Inability to overwrite the existing CSV/JSON file directly from the browser.
2. Inability to update Flexmonster internal data structure according to changes made by a user.

 
In most cases, the possibility to edit the data would require a centralized server-side data provider. It is because you will need to handle the editing process manually and overwrite existing datasets afterward. 
 
Please let us know if other questions arise.
 
Best regards,
Illia

Hello,

Thank you for the clarification.
 
If the data only needs to be modified during the runtime (without saving), we want to explain the following:

• The mentioned editing only allows modifying existing records. You cannot add new records using this feature.
• For JSON data, you can use the updateData API call to complement it with records or remove existing ones without reloading the report. It is achievable using the partial update feature described in our documentation. Please note that custom controls for adding/removing records need to be implemented (for example, a set of inputes below the grid with an "Add" button).
• CSV data cannot be updated partially.

 
We hope it helps.
Please let us know if other questions arise.
 
Best regards,
Illia