User input

[Borisham]

Hello,

I would like to give the option to the user to write data into table.

This option could happen couples of time during the day, and should be as much as simple as possible, they are not data user, or non tech user.

This is the table I would like them to use:

Color_id and background_id should be the compsite keys for this table.

Color_id	background_id	True/false	Timestamp (time and date)

What is the best option could I create this ?

Thanks for help

[Borisham]

@atcodedog05  Thanks

Can you explain to me as I am alteryx beginner How the users write this data to the database ?

How Can I give them the oporitunity to use it ?

[atcodedog05]

Hi @Borisham 

In the below workflow replace the browse with output tool (DB write)

It should be able to do the job.

You can publish this as an app on the gallery.

Hope this helps 🙂

[atcodedog05]

Hi @Borisham 

Please go through the lessons below to better understand the actions.

https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Creating%2...

Hope this helps 🙂

[Borisham]

@atcodedog05 

Thanks.

I have another question belong to that - How could I check the data the user upload, if for example, the user forgets the fill in the color_id or other field. I would like to have a message box to the user when that happen if possible.

2. The timestamp you used in the workflow, use just the day and not the time... It looks like 2020-10-12 00:00:00. How could I use the time as well ?

Thanks

[atcodedog05]

Hi @Borisham 

You can use Error message tool to validate input and display a error message.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Error-Message/ta-p/892...

App:

Error warning

Error message tool config

You can add more validations.

Workflow:

2nd concern: I am getting date as well as time please check.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Borisham]

@atcodedog05thanks so much, your help is fully appricated.

Insted of text box I have changed the workflow to be used by field that the user should upload. Is there anyway to check each field / or just all the first  colomns ?

Thanks

[atcodedog05]

Hi @Borisham 

In the current workflow all the user inputs are checked for blanks using error message tool.

[Borisham]

@atcodedog05  Thanks

I used the error message tool for the CSV file the user upload, and I didn't get any erorr message

This CSV file looks like:

Color_id	background_id	True
10121012		True

Appriciate your help

[atcodedog05]

Hi @Borisham 

Error message tool works on user input provided in an analytical app(like if user leaves the text box empty). It doesn't work on uploaded files.

[Borisham]

@atcodedog05 

fair enough, that makes sence.

Do you have any idea how to show alert to the user if that happend if the user use in a file to upload many rows at once ?

Thanks