How to create Dynamic Dashboard

Dashboard
,
1

Hello! I'm having an issue with Dashboard v1.
I created a table on PostgreSQL that includes three columns: id, parameter, and data_type.
Then, I read the data and saved the id into a dropdown (I've managed to do this part).
When I select an id, I want the appropriate node to appear based on the data_type (in this case, I'm only using two nodes: a dropdown and a text input) with the label being the parameter.

Can someone help me with this? Please provide a sample flow.
Thank you very much!

2

Welcome to the forum @lebao

Please can you explain what you mean by "I want the appropriate node to appear"?
Maybe a sketch showing what the dashboard should display for a couple of different database IDs?

Also, why are you using a text input node? Are you intending to update the database from user input?

3

Hello jbudd,
I am very grateful that you are interested in my topic.
That sentence "I want the appropriate node to appear" means that when I select a dropdown option, the appropriate UI nodes will appear for it. For example, if I select 'Personal Information' from the dropdown, a text input for 'Full Name,' another text input for 'Age,' and a dropdown for 'Gender' will appear.
I have researched and it seems like the ui_control node might be able to meet my requirements.

4 
[{"id":"d3990ea58af4b54b","type":"ui_dropdown","z":"5b623fd31ca86a42","name":"","label":"","tooltip":"","place":"Select option","group":"6339e2ead216512f","order":1,"width":"8","height":"2","passthru":true,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"topic","topicType":"msg","className":"","x":465,"y":2300,"wires":[["d185ed3ec209d9ab","6721c09082dc906f"]]},{"id":"22b510d60b1dc7ef","type":"change","z":"5b623fd31ca86a42","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"[\"Option 1\",\"Option 2\",\"Option 3\"]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":305,"y":2300,"wires":[["d3990ea58af4b54b"]]},{"id":"98ae0c1f141b6758","type":"inject","z":"5b623fd31ca86a42","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":120,"y":2300,"wires":[["22b510d60b1dc7ef"]]},{"id":"d185ed3ec209d9ab","type":"switch","z":"5b623fd31ca86a42","name":"","property":"payload","propertyType":"msg","rules":[{"t":"eq","v":"Option 1","vt":"str"},{"t":"eq","v":"Option 2","vt":"str"},{"t":"eq","v":"Option 3","vt":"str"}],"checkall":"true","repair":false,"outputs":3,"x":625,"y":2300,"wires":[["a4e2022d1058d45c"],["ff9da100f6eadf1a"],["c0e84872d92b02a4"]]},{"id":"a4e2022d1058d45c","type":"change","z":"5b623fd31ca86a42","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"[\"Option 1-1\",\"Option 1-2\",\"Option 1-3\"]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":770,"y":2275,"wires":[["b26528bc02725907"]]},{"id":"ff9da100f6eadf1a","type":"change","z":"5b623fd31ca86a42","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"[\"Option 2-1\",\"Option 2-2\",\"Option 2-3\"]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":780,"y":2300,"wires":[["b26528bc02725907"]]},{"id":"c0e84872d92b02a4","type":"change","z":"5b623fd31ca86a42","name":"","rules":[{"t":"set","p":"options","pt":"msg","to":"[\"Option 3-1\",\"Option 3-2\",\"Option 3-3\"]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":770,"y":2325,"wires":[["b26528bc02725907"]]},{"id":"b26528bc02725907","type":"ui_dropdown","z":"5b623fd31ca86a42","name":"","label":"","tooltip":"","place":"Select option","group":"6339e2ead216512f","order":1,"width":"8","height":"2","passthru":true,"multiple":false,"options":[{"label":"","value":"","type":"str"}],"payload":"","topic":"topic","topicType":"msg","className":"","x":985,"y":2300,"wires":[["6721c09082dc906f"]]},{"id":"6721c09082dc906f","type":"ui_toast","z":"5b623fd31ca86a42","position":"top right","displayTime":"3","highlight":"","sendall":true,"outputs":0,"ok":"OK","cancel":"","raw":false,"className":"","topic":"","name":"","x":965,"y":2225,"wires":[]},{"id":"6339e2ead216512f","type":"ui_group","name":"Group 2","tab":"5e0dd10e66fdea95","order":2,"disp":false,"width":"30","collapse":false,"className":""},{"id":"5e0dd10e66fdea95","type":"ui_tab","name":"TEST","icon":"dashboard","order":9,"disabled":false,"hidden":false}]

May be like this ?

submenu

5

Hey bro,
Do you know how to show or hide nodes on the dashboard without using multiple groups?
I am working on a project where, when fetching data from PostgreSQL, there is a parameter value and I want the parameters to be selected from a Dropdown or entered via text input.
Previously, I used ui_control to make it dynamic, but every time I add a new device or table in PostgreSQL, I have to manually update the flow (add a new group or create a new Dropdown/Text Input). I want a dynamic solution.
Does anyone know how or have any suggestions?

6

unable to understand this part.

what is the issue in the solution provided ? based on what you select in first dropdown, the second dropdown contents are dynamically changed.

7

You can hide individual elements within groups
e.g. Hide - show a group element - #2 by E1cid