Date and time table to send messages

Hi, guys a time ago I asked about a table on the dashboard to paste the hour to send on/off messages to a mqtt out node so I want to do the same but with an specific date. I will paste my flow.

[{"id":"fa431dfa.cb60b","type":"tab","label":"Flow 4","disabled":false,"info":""},{"id":"59638d89.eec624","type":"debug","z":"fa431dfa.cb60b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":1190,"y":340,"wires":[]},{"id":"8bbbbc4a.69089","type":"function","z":"fa431dfa.cb60b","name":"","func":"var msgOut = msg.payload;\nflow.set(\"msgOut\", msgOut);\nmsg.payload = msgOut;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":1040,"y":340,"wires":[["59638d89.eec624"]]},{"id":"44d5c2c4.5ed13c","type":"function","z":"fa431dfa.cb60b","name":"check command","func":"const time = new Date(msg.payload);\nconst hour = time.getHours();\nconst minute = time.getMinutes();\nlet timef = \"\";\nif(minute<10){\n    if(hour>9){\n        timef = String(hour) + \":0\" + String(minute);\n    } else {\n        timef = \"0\"+ String(hour) + \":0\" + String(minute);\n    }\n} else {\n    if(hour>9){\n        timef = String(hour) + \":\" + String(minute);\n    } else {\n        timef = \"0\"+ String(hour) + \":\" + String(minute);\n    }\n}\nconst msgOut = flow.get(\"msgOut\");\nmsgOut.forEach(element => {\n    if(element.time == timef) node.send({payload:element.command,item:element.item});\n});\nnode.done();\nreturn;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":460,"y":440,"wires":[["fe38512d.2ec09","6b650a61.620c94"]]},{"id":"2c7bdbc6.ff09f4","type":"inject","z":"fa431dfa.cb60b","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"60","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":270,"y":440,"wires":[["44d5c2c4.5ed13c"]]},{"id":"fe38512d.2ec09","type":"debug","z":"fa431dfa.cb60b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":630,"y":440,"wires":[]},{"id":"6b650a61.620c94","type":"mqtt out","z":"fa431dfa.cb60b","name":"","topic":"","qos":"","retain":"","x":650,"y":540,"wires":[]},{"id":"e9ae4e1b.47dbc","type":"change","z":"fa431dfa.cb60b","name":"ui_control & placeholder","rules":[{"t":"set","p":"ui_control","pt":"msg","to":"{\"customHeight\":20,\"tabulator\":{\"layout\":\"fitColumns\",\"clipboard\":true,\"clipboardCopySelector\":\"table\",\"clipboardCopyStyled\":false,\"clipboardPasteAction\":\"function(rowData){     this.send({ui_control:{callback:'clipboardPasteAction'},payload:rowData});     return this.table.replaceData(rowData); }\",\"columns\":[{\"field\":\"col1\",\"title\":\"Column #1\"},{\"field\":\"col2\",\"title\":\"Column #2\"},{\"field\":\"col3\",\"title\":\"Column #3\"}]}}","tot":"json"},{"t":"set","p":"payload","pt":"msg","to":"[{\"col1\":\"click here & CTRL+v\",\"col2\":\"or click here & CTRL+v\",\"col3\":\"or click here & CTRL+v\"},{\"col1\":\" or on any other cell\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"\",\"col2\":\"\",\"col3\":\"\"},{\"col1\":\"there is a issue with small or empty tables\",\"col2\":\"will be dixed soon\",\"col3\":\"\"},{\"col1\":\"Untill then we have\",\"col2\":\"to fill in some\",\"col3\":\"dummy lines\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":470,"y":340,"wires":[["b3e1ceb0.2f843"]]},{"id":"dbe41bc.e96b6e8","type":"debug","z":"fa431dfa.cb60b","name":"clipboardPasteAction","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":1100,"y":300,"wires":[]},{"id":"b3e1ceb0.2f843","type":"ui_table","z":"fa431dfa.cb60b","group":"dddd0a60.dd20e8","name":"Copy & Paste","order":1,"width":"17","height":"7","columns":[],"outputs":1,"cts":true,"x":712,"y":340,"wires":[["3d5eccb0.6cc844"]]},{"id":"3b00a1b3.99ab1e","type":"ui_ui_control","z":"fa431dfa.cb60b","name":"on tab change","events":"change","x":253,"y":340,"wires":[["e9ae4e1b.47dbc"]]},{"id":"3d5eccb0.6cc844","type":"switch","z":"fa431dfa.cb60b","name":"","property":"ui_control.callback","propertyType":"msg","rules":[{"t":"eq","v":"clipboardPasteAction","vt":"str"},{"t":"else"}],"checkall":"true","repair":false,"outputs":2,"x":886,"y":340,"wires":[["dbe41bc.e96b6e8","8bbbbc4a.69089"],["44d0fe85.d8507"]]},{"id":"44d0fe85.d8507","type":"debug","z":"fa431dfa.cb60b","name":"something else","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":1060,"y":380,"wires":[]},{"id":"dddd0a60.dd20e8","type":"ui_group","z":"","name":"ui-table Copy & Paste","tab":"39ebf361.3595cc","order":1,"disp":true,"width":"17","collapse":false},{"id":"39ebf361.3595cc","type":"ui_tab","z":"","name":"ui-table test","icon":"dashboard","disabled":false,"hidden":false}]

Can you explain what this flow is suppose to do? It doesn't seem like your table does anything - i.e. you don't add data to it fro the flow and you can't update it in the dashboard.

Can you help me? @JGKK

Ok, since you don’t want to answer a simple question I out of here. Good luck with your issue.

so in my first column I'm going to set the time and date to do the action new schedueld
so that's all that I want add the date

Im sorry im on holiday right now and only have my phone and no access to any of my nodered instances.

1 Like

@JGKK enjoy your holiday. you deverve it

Are you available to help me? sorry for asking