Skip to main content
Question

Multi-select Text

  • June 23, 2022
  • 0 replies
  • 76 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

I 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)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • June 24, 2022
Are you building a Product Configurator?   This is a potential customer building the specification for a machine that you will sell?

The back end architecture gets complicated but if you want it to be easy on the End User, you need a table system and the conditional rules that will let them configure the machine.  

The native multi choice text box is very limiting.  I do not use them anymore for even very simple data options like Yes/No.

------------------------------
Don Larson
------------------------------
Terms & ConditionsAccessibility statement