My team and I are new to Baserow and still settling in, we do however have a bit of an issue with one specific feature that I do not think Baserow currently has, but will be a big plus for us.
Currently when selecting an item from the multiple select field, the system does not allow you to add the same item multiple times, we would love to have this feature available as it’s vital for our day to day operations. Either if the item can be added multiple times, or even better if a quantity field can be added next to the item so the quantity of that item can be specified.
The fields get added from a Baserow form and it only gets submitted once at a time, submitting the same information again is not a viable solution.
Your assistance in this would be greatly appreciated!
Thanks for sharing your use case! While Multiple select fields don’t allow duplicate selections, you could achieve this by using a Link-to-table field for the item and a Number field for the quantity.
For example:
Item: Item A
Quantity: 3
This would let you specify how many of each item you need while keeping everything in a single record.
I have thought about this, but I do not think it will work. Reason being is that the information gets added via a form, the technician fills out all the fields for a call they are completing, but a particular field we use is a “Multiple Select” field where they select items from a list which they have used. They can use multiple different items as well as multiple of the same item. All of this gets added into one field. It would be awesome if they can select the item from the list and be prompted on the quantity when the item is selected, the quantity can be displayed in brackets in the field.
I have added a screenshot of what i mean, hopefully it makes sense
Thanks for the example @Marco. Multiple Select fields are designed to work this way, where each option can only be selected once, so I doubt we’re likely to change this behavior but I will discuss it with the team.
For your use case, I’d still recommend looking into restructuring the data with a Link-to-table + Quantity field, which should give you more flexibility while still working with the Form view.
Thank you Olga, I would appreciate it if you could speak with the team.
The issue I have with using the Link-to-table & Number field is that there is no option to add multiple quantities in one row. We tried using the Link-to-Table option but it also only allows one item to be selected at a time.
The key function we require is for multiple items to be selected in a single submission for that one field and somehow state quantities for each item, without this we cannot fully move over to Baserow from our old system.
