Hello @maahi, we use Apache NiFi to insert or update records in the database.
We have a link column which we show in a table. We show a very simple web page which is hosted on NiFi when user clicks the link. If user clicks the “Save” button on the web page we update or insert the record in the database. Web page takes the record id from the link. It is something like http://localhost:7500/UpdateRecord?id=101 . The id (101) is generated from the database.
I believe that Node-Red has a simpler approach, or any web developer can use his stack (WAMP, etc) but we must use an external tool to make it work. But it is not a big issue to deal with.
I may share the complete flow if anyone needs it. We’ve developed a flow which records the alarm information when grafana triggers any alarm. User then may enter a reason or cause for that alarm. We’ve used this procedure with Postgresql and SQL Server.
Regards.