Problem: You need to display a table with first name, last name and age. Sample data: Paul Doe, 24 Greg Jones, 31 Able Smith, 29 We will use a function node to create the table like this: [55%20AM] And display the table using the template node. Here is what we use in the template node: [09%…

Here is a flow to get a dynamic table with sortable columns, a searchbar and outputs the clicked row data: Enjoy! [image] [{"id":"ee4d312b.cc342","type":"ui_template","z":"95993933.d7c978","group":"18e6e44c.b0561c","name":"Search Sortable Table","order":1,"width":"6","height":"5","format":"<style>…

Thank you for the great examples. How could any of the examples be adapted to add the possibility to edit values in the table and send them back to the database?

From my example above, you could modify the template to have fields in the table's ng-repeat section and add a save button to output the whole table via ng-click. <div> <form> <span class="input-group"> <i class="fa fa-search"></i> <input type="text" class="form-contr…

Nice example! I noticed onething, the input 'type' for the age should be number <td><input type="number" ng-model="user.age"></td> or, if it has been changed, you get a string back on save.

Thanks again. Could you please explain how exactly can the click of the "Save" button be handled in a function node, that prepares the SQL"update" query that should be executed by a (for instance) SQLite node ? For me it is not clear how can from the "Template" html code be generated a new message …

Have you tried adding debug nodes to your flow and experimenting? That will show you what is coming out of a node and you can then decide how to handle that data - i.e. pass it to a function node to build the sql.

Node-RED

Node-RED Forum

EXAMPLE (template) - displaying a two dimensional table

Dashboard

dceejay 23 November 2018 12:56 6

There was a thread a short while back from someone trying to do similar - Gridview with CRUD Options (MySQL)

Topic		Replies	Views
UI Template Edit msg.payload then Output Dashboard node-red-dashboard , ui-template	8	708	22 February 2024
Editable table in template node Dashboard	11	4394	10 November 2018
Send payload of array to UI-Template Table Dashboard	13	2504	6 September 2022
Modify database table Dashboard dashboard-2	5	309	7 May 2024
Failure to create my first UI table Dashboard	26	2738	28 May 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

EXAMPLE (template) - displaying a two dimensional table

Related topics