I fill out a Jotform with information for an invoice that I want to have populated into a Notion database but I keep getting Bundle Validation Error.
blueprint.json (73.6 KB)
blueprint.json (73.6 KB)
It may be an issue with the date format from Jotform fields mapped into the Notion module. Date values must be formatted as YYYY-MM-DD
4 Likes
Yes, that was the issue! Thank you so much! It wouldnât accept the "prettyâ date option, so I had to put the individual items with â-â between.
But the question: to make them look how I want them to (MMM d, YYYY), would I just add a Tool module > Set Multiple Variables to change the look before sending it to a Google doc?
I ask because I tried to do formatDate(Invoice Date // from Notion module; MMM d, YYYY) and received this error.
It looks like the mapped variable may be wrong - either you erroneously selected an array/collection instead of a date value, or you would need to use the âparseDate()â function before the âformatDate()â function, in order to ensure Make âunderstandsâ it is a date object that is being processed
3 Likes