# Ui\_table formatting and cell input

**URL:** https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351
**Category:** General
**Created:** [20 February 2021 14:00 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351 "2021-02-20T14:00:45Z")
**Posts on this page:** 10
**Page:** 1

<div class="post-metadata">

### Author: ![notnice](https://avatars.discourse-cdn.com/v4/letter/n/da6949/32.png) [@notnice](https://discourse.nodered.org/u/notnice)
#### Post date: [20 February 2021 14:00 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/1 "2021-02-20T14:00:45Z")

</div>

Starting with the basics of table formatting - just trying to turn off table header in inject function on an existing table:

```auto
msg.ui_control = {};
msg.ui_control.tabulator = {
	"headerVisible": false
}
return msg.ui_control;

```

It doesn't turn off headers when I inject it into the existing table. I did read a post on issues with light vs dark theme - not sure if that was solved yet, but I tried dark theme and still the same issue. Debug on output of function node looks Ok.  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/e/0ec8a789a7edb6435ee5755554df9f06666ffaa7.png)

Any ideas why its not working?

Secondly, I want to add a numeric input cell with a default value inot the table and then send the whole row data into an array after entry. I found some long threads/complicated looking solutions that feature this as part of it, and looked at tabulator docs, but just wonderd if there is a simple example somewhere I missed?

---

<div class="post-metadata">

### Author: ![ceysa75](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ceysa75/32/31340_2.png) [@ceysa75](https://discourse.nodered.org/u/ceysa75)
#### Post date: [21 February 2021 06:59 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/2 "2021-02-21T06:59:23Z")

</div>

Hi,

try this:

> msg.ui\_control = {};  
> msg.ui\_control = { tabulator: { headerVisible: false } };  
> return msg;

Regards

---

<div class="post-metadata">

### Author: ![notnice](https://avatars.discourse-cdn.com/v4/letter/n/da6949/32.png) [@notnice](https://discourse.nodered.org/u/notnice)
#### Post date: [21 February 2021 08:07 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/3 "2021-02-21T08:07:17Z")

</div>

Hi - thats worked thx very much! Whilst I've created some nice dashboards and bits of javascript in function nodes, still a lot to learn, especially about formatting...

If anyone has suggestions about how to make a cell editable, or a pointer to a concise solution already documented I'd appreciate that too. Thx.

---

<div class="post-metadata">

### Author: ![shrickus](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/shrickus/32/517_2.png) [@shrickus](https://discourse.nodered.org/u/shrickus)
#### Post date: [21 February 2021 21:34 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/4 "2021-02-21T21:34:18Z")

</div>

If you are looking for a way to allow edits to the data inside a table, here is an example of an [editable html table](https://discourse.nodered.org/t/gridview-with-crud-options-mysql/2244) using the JSGrid library. It involves a lot more than just editing data cells, but it may give you some helpful ideas.

Apologies if I have misunderstood your request...

---

<div class="post-metadata">

### Author: ![notnice](https://avatars.discourse-cdn.com/v4/letter/n/da6949/32.png) [@notnice](https://discourse.nodered.org/u/notnice)
#### Post date: [22 February 2021 07:23 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/5 "2021-02-22T07:23:46Z")

</div>

Thx Steve - I'll take a look and see if it helps my application.

---

<div class="post-metadata">

### Author: ![Christian-Me](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christian-me/32/10774_2.png) [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)
#### Post date: [22 February 2021 09:56 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/6 "2021-02-22T09:56:29Z")

</div>

Just a little note. Ui-table can let you edit cells too. If you like to continue with ui-table

---

<div class="post-metadata">

### Author: ![notnice](https://avatars.discourse-cdn.com/v4/letter/n/da6949/32.png) [@notnice](https://discourse.nodered.org/u/notnice)
#### Post date: [22 February 2021 11:21 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/7 "2021-02-22T11:21:16Z")

</div>

Hi Christian - yes my pref would be to stick with ui\_table as I now know how to format them 😉  
I did find various ui-table solutions posts which included cell editing, but the tables were a lot more complex than mine thus extracting just cell editing wasn't that staight forward. If you have a concise example in mind that makes it clear then pls post it. Thx.

---

<div class="post-metadata">

### Author: ![Christian-Me](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/christian-me/32/10774_2.png) [@Christian-Me](https://discourse.nodered.org/u/Christian-Me)
#### Post date: [23 February 2021 18:20 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/8 "2021-02-23T18:20:40Z")

</div>

Look here ... my ui-table handler could do the job for you ... and many other tasks.

> [@Get data from ui\_table](https://discourse.nodered.org/t/get-data-from-ui-table/41440/5):
>
> Hi ... I don't think there is a command available to "export" the hole table content. I use my ui-table handler subflow to take care of all the tasks around ui-table. it holds a copy of your table-data, tabel edits and table config (useful for replay on browser reconnects) [image] and you can export the table context too ... (merged tableEdit into tableData) this is the latest Version: [https://flows.nodered.org/flow/35d0480ce9151b2a722fa9d185a37825](https://flows.nodered.org/flow/35d0480ce9151b2a722fa9d185a37825) You can find it in my homie-de…

I use it for ALL my tables ... the API is not perfect (who calls an argument "object"?) ... but at least there is a little documentation. If I rework the API I have to rework many flows .... and no time for that.

---

<div class="post-metadata">

### Author: ![notnice](https://avatars.discourse-cdn.com/v4/letter/n/da6949/32.png) [@notnice](https://discourse.nodered.org/u/notnice)
#### Post date: [24 February 2021 07:09 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/9 "2021-02-24T07:09:05Z")

</div>

Thx Christian - I'll take a look through and see if I can pick out the bits that will be useful for my tables.

Appreciate you taking time to help out 👍

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)
#### Post date: [10 March 2021 07:10 UTC](https://discourse.nodered.org/t/ui-table-formatting-and-cell-input/41351/10 "2021-03-10T07:10:00Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
