HamzaGHALLABI
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Multi-select Text
Thanks Mark for the response. I will give an example: We sell very specific machines which depend on the number of products the machines will have to produce; per day and per week. The (commercial) user will have to fill in a numeric field with the number of products per week. We don't know how many days the machine will work per week. Most of the time it is 4 days. The field I want to create should give the user a choice between; [how many products per week]/4, and manual classification. A simple way I thought of is a yes or no question (the machine will produce [how many products per week]/4 per day). Otherwise to display and ask to fill in another field. This will need to be done for about 13 fields, which means at least 26 new fields. This is not optimal from a dataset perspective. My question is about the possibilities of a "multi-select field" combined with a formula or another field. ------------------------------ Hamza GHALLABI ------------------------------15Views0likes1CommentMulti-select Text
Hi there, Question 1: I would like your feedback on making a "multi-selection text" field from the result of another field or a calculated formula. Example1 : The client owns a machine producing 12 kilos per week. Depending on how many days of the week the machine is working, we can conclude the production per day. So from the number of days of operation of the machine (which will be field by the user), I would like to have a "multi-selection text" field with: Default value: 12/[number of days of operation of the machine], other values (...) Example2: The user fills in a "multi-selection text" field containing 12 fruits. He chooses 3 fruits. In another section, I would like to give him the choice between the 3 chosen fruits in another "multi-selection text" field. PS: I have already read some solutions by creating tables and linking them to answer this question. This is not a solution for me since for each project I can have up to 40 variables that if I create a table for each it will take up to 3h of work per week and an unoptimized dataset on which nobody cannot work later. Question 2: Can we restrict the "Allow users to create new choices" option to certain roles? Question 3: Is there any documentation on the "From another field" input type? ------------------------------ Hamza GHALLABI ------------------------------