Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
PFA attached
PFA attached
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
You mark your field as InputField (check the script) and use the Inputsum() function
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..
NewField exists into your model? It must exist
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?
Not sure about it´s possible, I don´t use this feature regularly.
Thanks!:)
Sorry one more question: How can I make sure the user can only enter integers?