How to get value automatically when I click item column?

[umin-kyaw]

Hello My Dear Sir,

I have a question about the related of getting value.

For example, In my inventory there are many items. After I clicked the item from valid if column in form view to generate receipt, I also fill the number of quantity in quantity column. This is the routine.

But I want to do that when I click the item which I choosed 5 times to get the automatic fill 5 in quantity column.

How to do that?

Please let me know Sir 

 

 

[jrullan]

Hello, 

It isn't clear what you want to accomplish. You could try adding some screenshots of the related tables structure and the data to better convey your issue. Also, if you are not a native english speaker, I would suggest you use Google Translator or a similar tool to provide more clarity to your issue.

[umin-kyaw]

Ok 🆗 Sir, I will try my writing.

I mentioned about that

If I do 5 time click the item ( 1,2,3,4,5 ), there will be Number 5 in quantity column automatically fill. So I don't need to fill in quantity column.

If I clicked 1 time the item, number 1 in quantity column.

If I do 4 time click , number 4 in quantity column.

If I do 6 time click, number 6 in quantity column.

If you understand, please how to do that.

[jrullan]

If I understand what you are saying correctly, you want to select the same item several times and you want the quantity to be incremented automatically, before saving the form? 

You could easily do that by selecting the item in the dropdown widget once and then click the + sign 5 times. But if it isn't what you want then you would have to get creative with actions and a dashboard kind of view, and probably another table to hold the item instances for this record. 

[umin-kyaw]

Thanks Sir

I will try follow your suggestions.