Manipulate JSON items in N8N Form node

Help me Build my Workflow
1

I have a MySQL database which contains a View of a list of items waiting for approval, before they can be submitted to the next step of the business process.

I’m looking for a way to:

  1. Pull this data into a workflow (I can do this bit already)
  2. Present it to a human in a web-browser, so that they can tick an “Approve?” checkbox (or equivalent) next to each line/item.
  3. For lines/items where the box is ticked, it needs to update a value in MySQL (pretty sure I can do this, too.)

Can anyone offer any tips or suggestions on how to achieve my step 2?

I’m probably talking about fewer than 100 items on each “run”, but it could potentially be 1000 or more, in some instances.

I want to avoid converting to file, updating, and then re-uploading via a separate form, if possible. Mostly, because this method presents too much opportunity for other values to be accidentally/deliberately changed, which would throw-off other parts of the process.

2

That looks as a task for n8n next form page node.
E.g. you have a n8n form “Check for approves”, when you hit next button, it will fetch the data from the sql DB (e.g. 10-20 entries) and populate the dropdown list to select the items which can be approved.