Notion Number Insert Issues with Decimal Points

Error Tests

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!!

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:

1 Like

Thanks for your help that was the issue!! :laughing:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.