Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Idea for choosing the right field

Omri Zeman September 5, 2023

I have a request from an employee who wants to have a list of "products" each of which will have the option of choosing its own quantity.
The idea he wanted was to make a field with the name for each one and under each field there would be another field of "quantity", I am against this idea because it makes me create double fields both text fields and "quantity (1), quantity (2)... "
I'm trying to think of an idea or a specific field that will save me this.
It is important to note that in one form of "create" an employee can choose more than one product and therefore a different quantity for each of them.
I suggested that maybe he just write down the quantities in the Description field, but he doesn't want to because he wants to do analysis afterwards on the "quantity" field for each product.

For example:
AP1587E-RD-01

AP1698C-RD-01

AP1586C-RD-01

MCI-CB-04987

AP1558A-RD-01

USB cable

USB cable + charger

Box 1698

Box 1587

So these are the values and he wants each of them to be able to enter a certain amount 1-100
And I don't want to create 9 text filed fields and then he will record a quantity, because in the future he will probably want to add more products.
I would appreciate any advice or help, thank you very much.

1 answer

0 votes
Aron Gombas _Midori_
Community Champion
September 5, 2023

The TableGrid app provides a smart "table-like" custom field type. 

You can define two columns, one for the product, one for the quantity. Also, you can allow the values in the first column be selected from a predefined set and the second column accept only integers. This is definitely worth a try.

Suggest an answer

Log in or Sign up to answer