Hi, I'm creating a grid view with CRUD options using MySQL. The following link consists of the example: https://flows.nodered.org/flow/e32f2b942bce77ef6079c0642b93c036 I had tried a part of it here and I'm unable to display the data. In short, the page went blank. Debug node showing all the data …

That is a nice little GridView example -- I just had to make a few small tweaks to the Web Template node to get it to display properly: <!DOCTYPE html> <html lang="en"> <head> <title>License Plate</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial…

Hi all, Is anyone there to help? Thanks for helping.

Providing your flow would be helpful

Hi, I'm now able to perform CRUD operations. However, I'm unable to display the data and perform CRUD operations with dropdown fields. I'm only seeing a blank page with "Machine Management" heading once I changed two fields type from "text" to "select". If I set the fields type to "text" back and …

[image] rishanaziz: I'm only seeing a blank page with "Machine Management" heading once I changed two fields type from "text" to "select". If I set the fields type to "text" back and remove other dropdown properties, everything is working perfectly. And in which node are you making that chang…

Please provide the code that created the database and a sample of the data

The following link consists of an example which meet my requirement. In the example, country names are being displayed on Country column. When click on any row, Country column field of the row will become dropdown (with options from another table of the database) and we are able to perform CRUD. Fo…

That is a great demo of the front end, but doesn't answer my request. If you want help you have to provide the date. I'm not going to spend the time creating the SQL to create the tables and load that data, it is not worth my time to do that. If you provide it so I can create the database and table…

Hi, I had uploaded the the sample data here. Thanks for helping. queries.txt (725 Bytes) Sample Data (tab delimited).txt (2.0 KB)

The sql and data (not in a format that will allow someont to load it into a database!!) do not match the table you are using in your queries. To move forward with helping you, you have two choices: (1) provide the sql that will create the table and load the data you are using in your flow or (2)…

Node-RED

Node-RED Forum

Gridview with CRUD Options (MySQL)

Dashboard

rishanaziz 2 October 2018 09:43 29

You're welcome

EXAMPLE (template) - displaying a two dimensional table

Topic		Replies	Views
Guriddo jqGrid + sqlite CRUD (Create, Read, Update, Delete) General	2	1185	27 April 2020
UI Dropdown - get result from SQL Dashboard	50	19000	12 November 2018
Dashboard-2-sqlserverDatabase-crud Dashboard dashboard-2	5	301	8 July 2024
Gridview with CRUD option in template node Dashboard	1	1520	21 June 2019
Dashboard 2 CRUD node Dashboard database , dashboard-2	30	944	8 July 2024

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.

Gridview with CRUD Options (MySQL)

Related topics