Multi-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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI think that the use of the multi select field type will not meet any of your needs, you cannot restrict adding choices by Role anD you cannot easily use it to control the drop down choices in a subsequent multiple choice field.
Can you describe further the business need and maybe there is another solution.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
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
------------------------------
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
------------------------------
- MarkShnier__YouI think that the solution will involve tables and probably conditional drop downs but someone may need to talk to you one on one to help sort out a solution that will work well for the users.
I don't have enough information from your description of the business need to offer more detail for a suggested solution.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------