I have a small part of the workflow that returns a list of projects. The result is formatted as a IN statement for SQL ('123456','234567'). I want to user that as a source to update a second SQL input. Meaning "A.Field = ('789456'), and I would update ('789456') with the result of the first part. I can technically do it by formatting it in such a way that I can interface using the dropdown tool, but I don't want to have a prompt on the app. I just want to have it updated directly. Hopefully this is enough information to have an answer. Let me know if further detail is needed.

Update value (Using Action tool) from result of formula tool

I have a small part of the workflow that returns a list of projects. The result is formatted as a IN statement for SQL ('123456','234567').

Action Tool Workflow 1.PNG

I want to user that as a source to update a second SQL input. Meaning "A.Field = ('789456'), and I would update ('789456') with the result of the first part.

Action Tool Workflow.PNG

I can technically do it by formatting it in such a way that I can interface using the dropdown tool, but I don't want to have a prompt on the app. I just want to have it updated directly.