Problem: Number Format causes errors but text based number work using .toString. without decimal point. Has anyone else had this issue? Am I missing something?
Thank you in advance!!
Screenshot: “quantity” as a text field accepts data using .toString()
Next I’ll set up the price that is in plain number format
I retrieve data from Splitinbatches, a number field with no decimal points.
Number data with no decimal point does work
Retrieve data from Splitinbatches, a number field with decimal points.
Error on workflow screen
Error inside Node
Information on your n8n setup
n8n version: 0.175.1
Database you’re using (default: SQLite): SQLite
- Running n8n with the execution process [own(default), main]:
Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker-Compose
Hey @soulphforum, I am sorry to hear you’re having trouble.
I’ve created a simplified database in Notion with a single numeric field to reproduce the problem:
I could reproduce the problem when sending a string to Notion’s numeric field (green numeric value works, red string value fails):
Could you check whether your data is by any chance a string rather than a floating point number? You can see this by enabling the JSON view shown in the screenshot above on the node your Notion node retrieves data from.
If so, you could convert your string into a floating point number when passing it on to Notion by adding parseFloat() to your expression like so:
Thanks for your help that was the issue!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.