Forum Discussion

MelanieProebste's avatar
MelanieProebste
Qrew Trainee
2 years ago

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

I am not sure why I am getting this error in my pipeline.

invalid literal for int() with base 10: 'user'



------------------------------
Melanie Proebstel
------------------------------

3 Replies

  • DougHenning1's avatar
    DougHenning1
    Community Manager

    Hi Melanie,

    Sounds like you did a query in step C but didn't use a loop on the results.  The loop will allow you to run the Create Record for each record in the search results.


    Hope that helps!



    ------------------------------
    Doug Henning
    ------------------------------
    • Surya_Avantsa's avatar
      Surya_Avantsa
      Qrew Trainee

      I had the same issue today and using it inside the loop worked. At least I wish the error message clearly indicated that the value I am using is out of scope. Something to think about for the Qrew Captains.

  • BrianSeymour's avatar
    BrianSeymour
    Qrew Assistant Captain

    You may be better off opening a Support Case with the Quickbase team who can access your app. The first thing I'd confirm is that both fields, the "expert_assigned" and field referenced in Step C {{c.user.id}}, are the same type. And I'd check to see if the field help text "Specify either user ID or user email" is displayed where you are setting the User (presumably) in your Pipeline step.

    Also, you can cast values to different types via Jinja, but I'm not sure that's appropriate here. For example, {{c.user.id|int}}

    Hopefully that helps!



    ------------------------------
    Brian Seymour
    ------------------------------