Im develeping my inventory database using ChatGPT to help me and I´m running into an issue in my scan inventory form script when I try to make a form for logging the scanned items.
🆘 Zoho Creator: `insert into` Always Fails with “Improper Statement” — Even with Minimal Code
Context:
I'm building an inventory system in Zoho Creator. I have a form called `Scan Inventory` and a second form called `Scan_Log1` where I want to log scans using Deluge.
Setup:
- I'm running a workflow (`update product seen`) in the `Scan Inventory` form
- The workflow is triggered On Success
- I’m using a very basic `insert into` block to write into `Scan_Log1`
Code Example:
insert into Scan_Log1
[
Scanned_RET = "TEST123";
];
What I’ve Confirmed:
✅ The form link name is exactly `Scan_Log1`
✅ The field `Scanned_RET` exists in that form and is not Required
✅ I’ve removed all other fields for testing
✅ There are no workflows or validations in `Scan_Log1`
✅ The user has full permissions
✅ The workflow is correctly running (confirmed with info "This workflow ran")
The Problem:
Despite all this, I consistently get the error:
Improper statement. Error might be due to missing ";" at the end of the line or incomplete expression
...on the `insert into` line, even when it contains just a single hardcoded field-value pair.
What I’ve Tried:
- Rebuilding the form from scratch
- Renaming fields and form
- Creating a fresh test form and inserting into that
- Removing all variables — using only hardcoded strings
- Making all fields optional
- Confirming no hidden required fields or workflows
❓ What could cause `insert into` to fail even with minimal, valid code?
Any ideas or deeper debugging steps appreciated. Thanks in advance!