How to add the attachments from attachment variable of record producer to data source

SomashekarB
Tera Contributor

I have different attachment variables which will display based on actions selected. I have created a data source with transform map to load and transform data from attachment variables to target table. Once record producer is submitted with attachments, attachments is not getting copied to data source.

Any solution?

SomashekarB_0-1722423829128.png

SomashekarB_1-1722423844339.png

 

4 REPLIES 4

Mark Manders
Mega Patron

What kind of record does your record producer create? You could create a flow from that record to copy the attachment to the data source, or create a datasource directly from the record producer if you don't need another record.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

I have created custom table to create records which are attached to data source. The data source is already created, and attachment should copy to data source when submitted. I have created script which is working on main attachment button but not for attachment variables

SomashekarB_0-1722426385059.png

 

Just copy them from your custom table to the data source then.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

I have written a script in record producer to copy the attachment from variable attachment to data source. In the data source transform map i given the target table as custom table which script has to load and run the transform when record producer is submitted with attachment.

The script is not working for variable attachments but working for main attachment which is at the bottom of the form.