Get Free Trial

Allowing users to add new row and column

Answered
B asked on June 9, 2021

Hi Flexmonster,

Would like to check if Flexmonster supports the feature of allowing users to add/remove new rows and columns in the flat form view.

5 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 9, 2021

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

Public
B June 11, 2021

Hi Illia,

Thank you for responding so promptly. Currently what we are experimenting is allowing users to perform simple modification to their data imported from CSV/JSON file, probably the changes to be temporary on the client side till the save/export button is clicked.

Hope you can help us with this, thank you!

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 11, 2021


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

Public
B June 15, 2021

Hi Illia,

The plan is to just modify the data on the browser after the data is being imported, to facilitate rendering of the charts based on the newly modified data. Since editing of cell data is possible and supported right out of the box, would this be possible as well?

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 15, 2021

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

Please login or Register to Submit Answer