Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

General guidance on analytic apps

Pingu
10 - Fireball

Hi all!

 

We use manual inputs in our daily work (that unfortunately can't be pulled from a system directly) -  right now it happens with Excel sheets and want to transfer this to Alteryx.

 

As a start I want to create form where people need to enter data over time; daily, weekly, monthly. The data needs to be appended each time (like adding a new line to the dataset) and stored in a .yxdb. Nothing needs to be replaced.

 

For example:

Field 1 people will be selection a location from a fixed list

Field 2 people select another value from a fixed list

Field 3 people need to enter a time(phrame). Ideally this is automated based on when the form is accessed . Not sure if there's such functionality.

etc.

 

Is it possible that it errors if people enter data in the wrong format?

 

Any pointers where to start - and which (interface) tools to study?

5 REPLIES 5
gabrielvilella
14 - Magnetar

Hi @Pingu, you can validate manual entries, such as from a Text Box, using the Error Message tool. On you example only field 3 would probably be a Text Field. But my suggestion here is to make this a dropdown as well, you can grab the system date for example, but you will need a chained app. First one will generate the date and the second one will present the values to be selected. 

Pingu
10 - Fireball

Thank you @gabrielvilella, looking into it.

 

A chained app is nothing different than multiple apps running after eachother?

Akash__on
8 - Asteroid

yes.

meins
5 - Atom

 @gabrielvilella

 

Thank you for your help. That worked for me!

gabrielvilella
14 - Magnetar

Happy to help @meins! Don't forget to mark my answer as the solution :)

Labels
Top Solution Authors