Updating Render Tool Output file with interface action tool Update Value with Formula

Question

Hi,

How do I update my output file in the render configuration to intake what my action update value with formula has?

I am trying what is pictured, but no New file is being generated.

I am updating it with formula -

"path" + DateTimeToday() + ".xlsx"

where am i going wrong?

2024-02-05_17-56-18.jpg

wonka1234 · Answer

@apathetichell  i dont understand how to create it in formula and pass that to the render tool.

apathetichell · Answer

don't overthink this - create it in a formula tool - pass it into render. take value from formula. I would not do what you are doing on a temp file output.

having said that - datetimetoday() is a datetime - if you want to the file to be labeled "path02052024162300.xlsx" you would use "path"+datetimeformat(dattimetoday(),"%d%m%Y%H%M%S")+".xlsx"

and if you want the path you'd use an engioneworkflow variable. and I don't know what your action tool is connected to.