I have created a table that shows details about material with available quantity. I want to write required quantity in the input box that I have created inside the table.
When I enter anything in the first input box it shows that value in every input box.
Please help me to figure out from this problem.
Hi Mubasshir,
That's because your input variable is a generic one and should be an attribute you have on the structure / query binded to the list.
So your input variable should be something like GetMaterials.List.Current.Product.Quantity, where GetMaterials would be the source of the data you are displaying on the table. The key is the List.Current, meaning that the value on the input would be a different one for each line.
In case you don't have the quantity in the database, you can add a calculated attribute on your query. If it's an aggregate, just click on the New Attribute button, call it Quantity and set the value to 0 (so the Quantity starts with 0), like on the image below, so you can use it later on the list:
Kind Regards,João
I don't want to take data from database. I want to input values and then check the logic on click of a button that is required quantity is greater than available quantity.
As I mentioned, you want to have the quantity at a list-level, not on a screen level, so you can have different values in each row of the list.
For that, you need to add a field Quantity to the structure you are binding to the list, so you can then use this Quantity as the variable of your quantity input.
Depending on how you are filling the list of records, the way to add this extra attribute may vary.
Hello
Adding a calculated attribute to an aggregate is nothing related to your database.it is a temporary attribute and it will only hold the value temporarily.Like your local variable does.But in a list, it will be different for each row of your aggregate.You have to go to your aggregate and add an attribute as @João Marques mentioned above.
ThanksTousif Khan
i have the same issue with @MUBASSHIR SHAIKH but i have add the attribute and link with the input field. May i know what should i do next in order to click a button to get all the data that in the input field and submit to the database ?