Skip to main content
Question

Pipeline Validation error: Incorrect template

  • June 19, 2023
  • 0 replies
  • 368 views

I am looking to utilize pipelines to pull from a formula field and input a date into a reference field. 

Essentially I have a date/time field, this is coerced into a date field, and I want that date field to feed into my reference field. This should be simple but I continue to get the following error. 

Validation error: Incorrect template "{{a.packed_date}}". ValueError: invalid literal for int() with base 10: 'packed_date'

Input (Mapping)
production_date_mto_reference:"{{a.packed_date}}"
I have built a similar pipeline without error but this one is not working. Any help would be appreciated. 



------------------------------
Michael Pelzer
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+6
  • Quickbase Staff
  • June 21, 2023

Is step A a search step?  If so, then you need a loop to process the results.  Or if you only want the first record then you can reference it specifically like this:

{{a[0].packed_date}}



------------------------------
Doug Henning
------------------------------