# How to read the cell value from the table column, which has render type as view

**URL:** <https://forum.inductiveautomation.com/t/how-to-read-the-cell-value-from-the-table-column-which-has-render-type-as-view/99791>\
**Category:** General Discussion\
**Tags:** perspective\
**Created:** [December 13, 2024, 10:03am UTC](https://forum.inductiveautomation.com/t/how-to-read-the-cell-value-from-the-table-column-which-has-render-type-as-view/99791 "2024-12-13T10:03:30Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [December 14, 2024, 4:03pm UTC](https://forum.inductiveautomation.com/t/how-to-read-the-cell-value-from-the-table-column-which-has-render-type-as-view/99791/4 "2024-12-14T16:03:28Z")

</div>

You need to create an onActionPerformed event script to update the database. (Right-click on the button ...)

Tip: format your code using the \</\> button. See [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831). Then you'll get this and it will be obvious which are single and double quotes.

```python
SELECT 
    *,
    '' AS Status,
    CAST(CURRENT_TIMESTAMP as DATETIME) AS Date_Time,
    '' AS UserName 
FROM statusTable

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-to-read-the-cell-value-from-the-table-column-which-has-render-type-as-view/99791)._