Dynamic R Tool Updating

[ncarrillo5]

Hi All!

I am currently using the R tool to create an Alteryx Macro. I am fairly new to Macros and need help with the following:

I need to dynamically populate a field using the ListBox (or any other Macro that would work) using a table in the workflow. The end goal is to have the user select the table that they want to use, and then select the field that they want to use to run in the RCode. 

You can see the workflow below shows the general idea of my approach. I simply need the selected field name to update the "col" string in the RCode as highlighted below.

Any ideas or further tips help! Thanks :)

[NeilR · Accepted solution]

Check out this article. As Dr Dan explains, you can use question constants in the R code.