Add a new column to a table where user controls its input

[#1]

Hi All,

I'd like to have the user be able to control some numbers and add those numbers in my table (all go in a new column).What's the best way to do so? Should I create variables and then have an input box (then can I create a field in my table based on those variables?)

Here's the table (comes from various sources): The UserInputs column is empty just that you guys understand what I'll need to do.

ID	Criteria	Step	Numbers per each step	UserInputs
2512	cri2	1	12
2874	cri3	2	11
3290	cri1	2	3
1249	cri1	3	4
2840	cri3	1	6
1295	cri2	1	7

[Clever_Anjos · Accepted solution]

PFA attached

[#3]

Thanks!Can you explain more on how you've done the loading? Not sure how I can use INPUTFIELD and join to my main table

[Clever_Anjos]

You mark your field as InputField (check the script) and use the Inputsum() function

[#5]

I've added INPUTFIELD NewField; to the beginning of my script but it doesn't show up anywhere so that I can use Inputsum function..

[Clever_Anjos]

NewField exists into your model? It must exist

[#7]

No it doesn't, and that's one of my problems, so I'll create an empty field (or with some default values) and let the user change it. Thanks!

Now one question: Is it possible that when the user inputs the value for one record, I automatically set the same value for the other records with the same Criteria? Because All of the records that have the same Criteria need to have the same value in NewField. Not sure if it's possible?

[Clever_Anjos]

Not sure about it´s possible, I don´t use this feature regularly.

[#9]

Thanks!:)

[#10]

Sorry one more question: How can I make sure the user can only enter integers?