I want to create a form, by which a user can create a new Product.
There are already existing products in the common database, and I would like the user to access them through a drop-down menu, to avoid entering a reference that could already exists.
Also, the Products are linked to a “Manufacturer” and a “Category” (each Product can have only 1 Manufacturer and 1 Category ; each Manufacturer or Category can have multiple Products).
So here is the user experience I am looking for:
User select a Manufacturer and a Category through a drop-down menu:
For now, I don’t find how to create a drop-down menu, instead of this text field.
In a better world, I would like the User to select a Product in a drop-down menu, on the second screen. And I would like all product shown in the drop-down menu to be filtered by the Manufacturer and Category he selected on the first screen.
Then, if the user don’t find the product he wants to add in the drop-down menu, he can add a new product through another way, by typing the text, and that product will be available in this drop-down menu for any future user (if the future user filters the same Manufacturer and Category with which the Product have been created).
Does anyone have proposals on how to do it?
To clarify : a Product can have multiple Users, and a User can have multiple Products.
If someone have the solution, I will celebrate this person!
You can achieve this with custom forms and you cannot achieve this with the form component, unfortunately!
If products available for the selected Manufacturer and Category has to show them on the drop-down and does it needs to create a record once the button clicked?
Yes you are correct : if Products are available for the selected Manufacturer and Category, they have to be shown on the drop-down, and I would like the selected product to be recorded once the button clicked.
Thank you for your little demo.
The only way I found until now for a product to be created once selected, is through a click-action on a list which I have set up like that:
Cloning you app allowed me to quickly learn:
– how to group components (dropdowns + buttons) to create more custom “forms”
– how to avoid duplicated items in a list, with your smart introduction of an “original” boolean as a property in a collection (which was my main problem)
– how to link a selection to another screen output, without the need to create a data in the base for now, by appealing it from “Other Components” → “All Screens” → “Screen containing the selected option”
