Let the user update a specific value in a column where the column is chosen by the user

Hello everyone,

My colleague and I are working on building an application for users in the Marketing Team to update their marketing events data.

Currently they have a flat file with columns such as Marketing Activity, Cost, Channel etc. and rows representing marketing activities.

We want them to use the app to select an activity, select a specific field and then update that field.

We have 2 parts of the chained app built already which allows them to

Pick a marketing activity (select the right row)
Select the field to update (select the right column)

But we are struggling with step 3, to update the selected field. Currently we can just write a new field but not write into the selected field.

See below snipping.

Is there a way to directly write into the selected field?

Thanks

alteryx1.png

Interface Tools

Chained App

Accepted answers

Kenda

Hi @ZeeshaanH

I found what may be causing the issue in your workflow. In your interface tools, you have to ensure that you rename each of them (in the configuration window) to match what you're calling it in your formula. Currently, They're all named Drop Down (8), etc. Instead, they need to be named Field, Activity, and Update. Once you change these, the formula will know the correct fields to look for.

Before (current) After (what it should say)

All comments

JoBen

Hi @ZeeshaanH, can you show how your action tool is configured?

Kenda

Hey @ZeeshaanH

I think you could do this all in one workflow, depending on how you have everything set up. See the attached sample app that I put together. I first get all of the values in the activity field to use in one of the drop downs. The other drop down is populated with the field names from your input file. The user chooses one from each drop down and fills in the text box with their update value. The Multi-Field Formula tool will take the user's selected values and only update the record in the chosen field on the chosen row with the update value in the text box. Note the Multi-Field Formula is getting the values from the drop downs using workflow constants. Check it out and see if this helps!

zeeshaanh.yxzp

ZeeshaanH

Hi,

I am unable to open the workflow as it says failure to import as it was created by a more recent version of Alteryx.

I am currently using Alteryx 11.5

Thanks

Zeeshaan

CiaranA

I'm working with Zeeshaan on this, I can open it in new version fine.

Thanks for your help.

Think this should work perfectly, thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703