User Data entry

[Lord_Lunacy]

I am trying to design a Alteryx Application and need some assistance. Currently our Logistics team uses an extremely archaic process of recording product returns on individual excel spreadsheets, as you can imagine this, is less than ideal for ensuring accuracy and  makes it quite difficult to report on this information

I would like to create a gallery data entry form to allow them to enter a few key pieces of information using the Alteryx data interface tools, initially I would store their entered data on a central excel spreadsheet but I have plans to eventually migrate it into out data warehouse. 

I don't have much experience with the interface tools or working with Apps, and messing around with them so far hasn't been very fruitful. So, I would really appreciate if someone could give me some helpful tips. 

[echuong1]

You can build an app that populates a text input. This would then flow to an output tool that is configured to append to the existing master excel file/database. See attached for an example.

I have 3 user inputs - Value 1, value 2, and value 3. The interface tool is the user prompt. The action tool will update the text input with the user inputs during runtime.

To run this workflow, click the wand next to the run button.

Hope this helps!

[Lord_Lunacy]

Thank you echuong1f or the quick response. Your solution is working, except for one problem. I am unsure now how to configure the Action tools to properly update the values in the Text Input tool. I currently have it set up to Update Value but it is replacing the Field names with the input values. For example I have a field for ReceivedDate  in the text input table  when I run the app it will change ReceivedDate  to the date I selected.  I have it it configured as follows.

Field[@name='ReceivedDate']

The default option, Update Cell, doesn't seem to working, I cannot select either of the dropdown options. So, which action type should I be using?