Overwrite format

Question

Hello,

I'm currently working with blob tools in my workflow and need some guidance.

I've designed a simple template to use as a reference point. My goal is to write text input fields over this template. I have attached the dummy workflow, but I'm having trouble appending the text correctly so it appears as shown in the image below.

Can anyone help?

Movie Template.yxzp

CloudDuck · Answer

Is there a way to convert this to a macro while preserving the format in the blob? When I attempt to add the fields dynamically, I encounter this error. Specifically, when I switch the workflow to macro and add the interface tools for the input field

face tools for the input fields i get this error

New Workflow2.yxmc

Yoshiro_Fujimori · Answer

Hi @CloudDuck ,

Your Blob Output (2) tool outputs a file to "_externals\2\._Insert Movie.xlsxBomba.xlsx".

This is because the param [Modfy File Name by:] is set to "Prepending Field To File Name".

If you want to output to [Filepath], you should change the param to "Replacing Entire Path With Field".

The other two ranges are not set to output to the [Filepath]. So I added some tools similarly to the first range.

I hope this helps.

Workflow

1277353.yxzp