N8n Form Dynamic Dropdown From Data Table For Stock Requests

    What this workflow does

    The workflow contains these steps: Run Once to Create Tables → Stock Request Form → Stock Request Settings → Setup Run? → Create Stock Table → Create Request Log Table → Check Requester → Requester OK? → Requester Problem → Find Data Tables → Tables Found? → Tables Missing → Load In-Stock Items → Build Item Page → Any Items in Stock? → Nothing in Stock → Choose Item and Quantity → Load Chosen Item → Check Request → Request OK? → Take Stock → Stock Taken? → Ask Again → Tries Left? → Request Not Sent → Log Request → Needs Low-Stock Alert? → Email Stock Keeper → Clear Alert Flag → Email Requester Receipt → Request Confirmed.

    What you need

    • An n8n instance to import and run the workflow.
    • StickyNote access for the StickyNote steps listed in this workflow.
    • ManualTrigger access for the ManualTrigger steps listed in this workflow.
    • FormTrigger access for the FormTrigger steps listed in this workflow.
    • Set access for the Set steps listed in this workflow.
    • IF access for the IF steps listed in this workflow.
    • DataTable access for the DataTable steps listed in this workflow.
    • Code access for the Code steps listed in this workflow.
    • Form access for the Form steps listed in this workflow.
    • EmailSend access for the EmailSend steps listed in this workflow.

    Workflow nodes

    1. Run Once to Create Tables (n8n-nodes-base.manualTrigger)
    2. Stock Request Form (n8n-nodes-base.formTrigger)
    3. Stock Request Settings (n8n-nodes-base.set)
    4. Setup Run? (n8n-nodes-base.if)
    5. Create Stock Table (n8n-nodes-base.dataTable)
    6. Create Request Log Table (n8n-nodes-base.dataTable)
    7. Check Requester (n8n-nodes-base.code)
    8. Requester OK? (n8n-nodes-base.if)
    9. Requester Problem (n8n-nodes-base.form)
    10. Find Data Tables (n8n-nodes-base.dataTable)
    11. Tables Found? (n8n-nodes-base.if)
    12. Tables Missing (n8n-nodes-base.form)
    13. Load In-Stock Items (n8n-nodes-base.dataTable)
    14. Build Item Page (n8n-nodes-base.code)
    15. Any Items in Stock? (n8n-nodes-base.if)
    16. Nothing in Stock (n8n-nodes-base.form)
    17. Choose Item and Quantity (n8n-nodes-base.form)
    18. Load Chosen Item (n8n-nodes-base.dataTable)
    19. Check Request (n8n-nodes-base.code)
    20. Request OK? (n8n-nodes-base.if)
    21. Take Stock (n8n-nodes-base.dataTable)
    22. Stock Taken? (n8n-nodes-base.if)
    23. Ask Again (n8n-nodes-base.code)
    24. Tries Left? (n8n-nodes-base.if)
    25. Request Not Sent (n8n-nodes-base.form)
    26. Log Request (n8n-nodes-base.dataTable)
    27. Needs Low-Stock Alert? (n8n-nodes-base.if)
    28. Email Stock Keeper (n8n-nodes-base.emailSend)
    29. Clear Alert Flag (n8n-nodes-base.dataTable)
    30. Email Requester Receipt (n8n-nodes-base.emailSend)
    31. Request Confirmed (n8n-nodes-base.form)
    StickyNoteManualTriggerFormTriggerSetIFDataTableCodeFormEmailSend
    37 nodesOther
    View on GitHub

    Need this workflow customized or debugged? Book a 30-min scope call →

    Want this set up for you? Book a 30-min scope call

    I build and fix n8n workflows for agencies and SaaS teams. 30-minute scope call — bring the problem, leave with an estimate.

    Related workflows