The Dashpivot template editor includes a Raw Code view that lets you edit the template's underlying JSON directly. This is a powerful tool for making bulk changes or importing custom field configurations, but it requires the JSON to be valid and use the correct field types.
This article covers the errors you may see when working in Raw Code or when using table formulas.
"Invalid raw code."
Why this happens
The JSON entered in the Raw Code editor could not be parsed. This usually means the JSON is malformed — a missing bracket, comma, or quotation mark is enough to make the entire structure invalid.
How to fix it
Review your raw code carefully for common JSON syntax errors: missing or extra commas, unclosed brackets or braces, and unmatched quotation marks.
Fix the issue and paste the corrected JSON back into the Raw Code editor.
Apply the changes and save.
"Invalid kinds used in raw code. Check the kind of the fields, table columns and table row columns."
Why this happens
The JSON is valid, but one or more fields, table columns, or table row columns use a kind value that is not supported by Dashpivot. This can happen if you copied JSON from an external source, manually typed a kind, or used a value that has since been renamed or removed.
How to fix it
Review the
kindvalues in your raw code against the full list of supported kinds in the JSON Conventions for Dashpivot Templates article.Replace any unsupported
kindvalues with the correct ones.Apply the changes and save.
"Formula error. Please check all formulas."
Why this happens
One or more formula columns in a table contain an invalid formula expression. This can be caused by a syntax error in the formula, a reference to a column that no longer exists, or an unsupported formula function.
How to fix it
Open the template and locate the table(s) with formula columns — the editor will expand the affected table to highlight the issue.
Click the formula column to review the formula expression.
Correct the formula and save the template.
"Some field IDs were invalid and have been regenerated."
Why this happens
One or more fields had duplicate or invalid IDs in the raw code. Dashpivot automatically regenerated valid IDs.
How to fix it
No action required — this is informational. Check that any logic rules or cross-references using those field IDs still work correctly after the regeneration.
"The number of fields exceeds the limit. Please remove some fields in order to Hide Raw Code and Save the template."
Why this happens
The raw code contains more fields than your plan allows. The template cannot be saved with raw code hidden until the field count is reduced.
How to fix it
Delete excess fields from the raw code until the count is within your plan's limit, then save.
If the issue continues
If you have followed the steps above and the error is still appearing:
Double-check your raw code against the JSON Conventions for Dashpivot Templates article, which covers required fields, supported
kindvalues, and common structural mistakes.Try reverting to the last saved version of the template and reapplying your changes incrementally.
Contact support with the template name and a copy of the raw code — this helps our team identify the issue faster.