# Table like input

**URL:** <https://discourse.nodered.org/t/table-like-input/6391>\
**Category:** General\
**Created:** [4 January 2019 14:41 UTC](https://discourse.nodered.org/t/table-like-input/6391 "2019-01-04T14:41:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jjrivasescola](https://avatars.discourse-cdn.com/v4/letter/j/858c86/32.png) [@jjrivasescola](https://discourse.nodered.org/u/jjrivasescola)\
**Post date:** [4 January 2019 14:41 UTC](https://discourse.nodered.org/t/table-like-input/6391/1 "2019-01-04T14:41:01Z")

</div>

Hello forum people,

**I´m not an expert in Node Red, so maybe you could help me. Thanks in advance!!**

I would like to work with the following input received from a table from an email :

![Input](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/b/b357eb91875ed5087b3e3d89ad481e06b908be05.gif)

The main program will work at the begin with the second row, and turning a light on if the start is at that moment. After it will do the same with the next row.

Could you help me?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [4 January 2019 15:02 UTC](https://discourse.nodered.org/t/table-like-input/6391/2 "2019-01-04T15:02:35Z")

</div>

Hi there. Just a suggestion...

Instead of someone creating a table in an email, why not create an input form (using the dashboard nodes) for the user to enter batch data directly?

Alternatively, if this data exists in a database, connect to the db and get it directly?

As for how to parse the table of data into an array or object, there are many ways - a quick search of "HTML table to JSON" revealed this post...

> <https://stackoverflow.com/questions/6271856/html-table-to-json>

  
Might be a good place to start.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [4 January 2019 15:32 UTC](https://discourse.nodered.org/t/table-like-input/6391/3 "2019-01-04T15:32:48Z")

</div>

break the task down into chuncks.

Start with trying to get node-red to read the email and then work on getting the data from the html to a javascript object that Node-RED can understand ( the html node might be useful here). use debug nodes to understand what the nodes are doing and how your data gets changed