Cannot set range to the numeric field in the form node (flowfuse dashboard V2)

Dashboard
,
1

I am facing dilemma with form-node. As it does not provide the option so that input value is lies in particular range. Am i missing something?

Issue:
With form-node (nodered dashboard v2), is it possible to set range that user can provide to the number field?

I want to actually create PDI form using which i want to push value to database. Now, the form will include following fields:

coil_id                -  Text type                - mandatory
order_id               -  Text type                - mandatory
grade_id               -  Text type                - mandatory
thickness              -  Real                     - mandatory          < 0.2-0.4 >
width                  -  int                      - mandatory          < 900-1250 >
weight                 -  int                      - mandatory          < 5000-21000 >
target_coating         -  real                     - mandatory          < 1.2 - 3 >
remarks                -  multiline comment        - optional

The sql table script:

CREATE TABLE pdi_coil (
	coil_id VARCHAR(50) PRIMARY KEY,
    order_id VARCHAR(50),
    grade_id VARCHAR(50),
    thickness NUMERIC(6,3),
    width NUMERIC(8,2),
    weight NUMERIC(10,2),
    target_coating NUMERIC(8,3),
    status VARCHAR(20),
    created_at TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
    
    FOREIGN KEY (grade_id) REFERENCES grade_master(grade_id)
);

The form should include two button submit and clear. The submit button should push the value to database and clear button will empty the filled value (if any). Also, the submit button should not be activated unless all mandatory field has been filled. And If submission to database is succeded then the user will receive pop-up that "Entry is submitted successfully"

Also, since grade-id is referencing grade-master table meaning if operator input wrong grade-id, the insert will fail and will show this as notification to user.

The thing is i'm power app developer. I know the basic of node-red and JS only. So my options are limited

2

As per the documentation, the ui_update.options payload to provide settings dynamically to function node. Though documentation does not mention use of min, max and step options, but I still tried but no luck.:

msg.ui_update = {};

msg.ui_update.options = [
  {
    "type": "number",
    "label": "Thickness",
    "key": "thickness",
    "required": true,
    "min": 0.2,
    "max": 0.4,
    "step": 0.001
  },
  {
    "type": "number",
    "label": "Width",
    "key": "width",
    "required": true,
    "min": 900,
    "max": 1250
  },
];

return msg;

Can anyone guide me what should i do?

3

Anyone?

@TotallyInformation. Apologies for calling you un-anounced. Please do not mind.

4

Whilst it is nice to be recognised :smiley: , I'm afraid you are tagging the wrong person to talk about D2. I don't use it in anger at all. I use UIBUILDER (unsurprising since I'm the main developer of it).

I can help you with a form in UIBUILDER, it isn't hard at all, but I've never used ui_update.

5

No issue. But thanks for the time.

I too think, ui-builder node is the only option though it'll require knowledge of more tech stacks

6

No problem.

If you want to start investigating UIBUILDER, I'd start as simple as possible and remember that you can happily run it along side existing Dashboards.

As well, worth remembering that with modern HTML/CSS, it is amazing what you can do without complex frameworks.

I'm generally around so do shout out if you want to discuss anything.