Hello Everyone,
I am looking to see if there is a solution for uploading files and having them auto populate records on a join table that links my sales order units with document files. I would like to know if it is possible to have the file attachment text contain the necessary info for a pipeline to read and perform the needed tasks. here is what i am currently trying.
using file manager plugin i upload docs through sales order table(projects table)
then it uploads to its documents table
testing a pipeline that can read unit# on the attached file once it is uploaded however i seem to get an issue when pipeline goes to create the records in the docs join table, the error message is below so at the moment i cant even tell if it can read the unit# and create a link for each unit per attachment.
Validation error: Incorrect template "{{b.id}}{{b.related_sales_order}}". ValueError: invalid literal for int() with base 10: 'id'
