Get Free Trial
Get Free Trial

change edited value on datachanged event

Closed
Niv asked on November 14, 2019

Hi, i need to change the value (and also what the user see) for the user on datachanged event for specific case.
is there any way to do so?

6 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 14, 2019

Hello, Niv,
 
Thank you for your question.
 
The datachanged event is triggered after the user edits data. After editing any data by the user it will be displayed on the pivot automatically. You can find an example here: http://jsfiddle.net/flexmonster/vy78qb4o/.
Please consider that the user is not allowed to change the data by default. If you want to give such permission, please, include the following code into the options object of your report:

editing: true

You can find out more about options object and its properties by the link: https://www.flexmonster.com/api/options-object/.
 
The data changed by the user will be displayed only for him without any influence on the data source. If you desire to allow the users to change the data source through changing the pivot, you can create an API call, entailed by the datachanged event.
You can find more about this event by the link below: https://www.flexmonster.com/api/datachanged/.
 
Also, our team kindly asks you to point on some example of the specific case you want to adjust.
 
Please let us know if it helped you.
Feel free to contact us in case of any questions.
 
Kind Regards,
Illia

Public
Niv November 14, 2019

Hi, what i want to do is change the data on the view on on data source the user change it already on the view himself.
some sort of value change on view

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 14, 2019

Hello, Niv,
 
Thank you for your feedback.
 
If you need to update the pivot after updating the data in your data source, we can recommend using the updateData method. This method allows updating your data without changing the report settings.
You can find more information about the method by the link: https://www.flexmonster.com/api/updatedata/.
 
Please, let us know if we have correctly understood your needs.
Feel free to provide more details if needed.
 
Kind Regards,
Illia

Public
Niv November 17, 2019

Hi,
let me explain better (first time here so sorry for misunderstanding),
i want the user edit only one column (the rows of that column) of course i dont have only one column so if i set “editing:true” he can edit them all, after i look over the web i found that flexmonster not support that kind of feature so i try to do something else,
what i try to do is : when the user try to edit other column except the one i want him to edit i want to change the value of that column row,
for example if the user change one row that have value “250” to “350” and that the row that i dont want him to change i want to change back that row (on the fly) to “250”.
is thing like that is even possible?
 

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster November 18, 2019

Hello, Niv,
 
Thank you for providing more details.
 
The datachanged event is triggered already after data is stored, and totals are calculated. That’s why such an approach doesn’t work for your case.
 
For now, we did not find any workaround that would handle your requirements.
 
You are welcome to contact us in case of additional questions.
 
Best Regards,
Illia

Public
Niv November 18, 2019

Ok Thanks 🙂

This question is now closed