# Table editable value write back to the dataset tag In perspective

**URL:** <https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490>\
**Category:** Ignition\
**Created:** [October 29, 2021, 11:21am UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490 "2021-10-29T11:21:53Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anita.Shinde](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Post date:** [October 29, 2021, 11:21am UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/1 "2021-10-29T11:21:53Z")

</div>

I have a dataset tag, I am binding tag to a table. I want two columns to be editable in that and after editing, dataset value should write back to the same tag.  
How can I do this?  
Any idea?  
Thanks.

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [October 29, 2021, 11:38am UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/2 "2021-10-29T11:38:19Z")

</div>

[https://docs.inductiveautomation.com/display/DOC81/system.dataset.setValue](https://docs.inductiveautomation.com/display/DOC81/system.dataset.setValue)

---

<div class="post-metadata">

**Author:** ![Anita.Shinde](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Post date:** [October 29, 2021, 12:13pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/3 "2021-10-29T12:13:23Z")

</div>

I have tried with system.dataset.setvalue().  
Table data is in json format, so setValue is not working for json data.  
I have tried to convert data in dataset or Pydataset like this but it is not working.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/6/6678c6856b08d75d662928c1764918a268e3bd3d.png)

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [October 29, 2021, 12:28pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/4 "2021-10-29T12:28:14Z")

</div>

ah yes like that it wont work  
You will have to create a dataset then from the ‘json’ using header and data like the first example here

[https://docs.inductiveautomation.com/display/DOC81/Datasets](https://docs.inductiveautomation.com/display/DOC81/Datasets)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 29, 2021, 1:07pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/5 "2021-10-29T13:07:28Z")

</div>

I think I may be missing something. Are you directly binding to the tag? If I bind a table’s data to a tag, it stays a BasicDataset.

---

<div class="post-metadata">

**Author:** ![Anita.Shinde](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Post date:** [October 29, 2021, 1:12pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/6 "2021-10-29T13:12:54Z")

</div>

Yes from tag we can get basic Dataset but I have transform script to convert tag data into json because to make fields editable data should be in json right?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 29, 2021, 1:39pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/7 "2021-10-29T13:39:39Z")

</div>

You would if you are modifying the data directly in the table. But, you are binding to a tag, instead.

onEditCellCommit

```python
	newData = system.dataset.setValue(self.props.data, event.row, event.column, event.value)
	system.tag.writeBlocking('[tagProvider]path/to/tag', newData)
```

---

<div class="post-metadata">

**Author:** ![Anita.Shinde](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Post date:** [October 29, 2021, 1:50pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/8 "2021-10-29T13:50:49Z")

</div>

> [@JordanCClark](#):
>
> ```python
> newData = system.dataset.setValue(self.props.data, event.row, event.column, event.value)
> system.tag.writeBlocking('[tagProvider]path/to/tag', newData)
> 
> ```

But it is giving error  
1st arg can't be coerced to com.inductiveautomation.ignition.common.Dataset

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 29, 2021, 2:07pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/9 "2021-10-29T14:07:42Z")

</div>

Did you bind it without the transform?

---

<div class="post-metadata">

**Author:** ![Anita.Shinde](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@Anita.Shinde](https://forum.inductiveautomation.com/u/Anita.Shinde)\
**Post date:** [October 29, 2021, 2:51pm UTC](https://forum.inductiveautomation.com/t/table-editable-value-write-back-to-the-dataset-tag-in-perspective/52490/10 "2021-10-29T14:51:14Z")

</div>

Yes, It worked, Thanks a lot.I thought json data is required for editable functionality.  
I have one more doubt,  
[How to Access network drive folder in perspective - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/how-to-access-network-drive-folder-in-perspective/52487)  
any idea for this?
