Display lines from multi line text field as multi choice field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hello, I would like to gather information in a multi line text field, and then have that information available (either on the same, or on a child, record) as a multi choice, in which each choice is a single line of the original text field. Is there a way to do this?
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,570 Points 50k badge 2x thumb
Since that's very difficult or impossible, natively, , can I suggest that you tell us the workflow or business problem you are trying to solve? Maybe there is an easier different viable approach.
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
HI Mark, nice to hear from you again.  We deal with many clients, and any client can at any time ask us to take care of multiple requests.  Each request is identifiable by what we will call a "serial "number", but there are potentially thousands of "serial numbers", and keeping a central database of all of them would be a waste.  We manually input several numbers at a time into a multi line text field, but then, almost immediately, the project will split, and the developments for each serial number must be tracked individually.
For when things don't have to be done on the fly, I've arranged a child table in which there is a lookup field for all the serial numbers, and a formula text field which by default contains all of the serial numbers, but is replaced by only several when those are copy/pasted into a "work on these serial numbers" text box.  The purpose of this arrangement is that 50% of the time, all serial numbers do follow the same flow, so the default setting eliminates the need to copy/paste in these cases.
My main issue is when things have to be input quicker, as some situations demand, where the "copy, paste, and start a new child record for the other serial numbers(s)" procedure is a but too bulky.  That is why a multi choice, or a multi select, would be ideal. 
Based on the other questions you've posted in the community regarding this issue and some of the challenges you're running into, I might suggest that having a table of your serial numbers might actually be more helpful in the long run that you realize.
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
:-) I understand what you're saying, but I don't think it would be practical, both from my end, and from the end users.  Everything I need can definitely be done using Javascript, or custom code, and I may have to go down that route with some Quick Base Affiliates.  I'm just trying to do what I can with formulas first. 
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
I have an idea, I'll post back to let you know how it's working.  When the serial numbers are first entered, they should be separated by a comma.  There will be a formula field for each possible serial number (there shouldn't be more than 12 at most) which pulls a specific serial number using the 
"part" function.  Those field will be used as lookup fields on a child table, where I will use the "copy this field" function for every field, twelve times, and label and arrange them on the form so that they correspond to a specific serial number.
Photo of Yehudah Greenberg

Yehudah Greenberg

  • 600 Points 500 badge 2x thumb
The above solution seems to work.  I have a text warning on the form that all serial numbers must be separated by a comma, and the total number of serial numbers may not exceed thirteen.  Next, I have thirteen formula text fields, each one identifying the "part" before a comma.  In addition, i have thirteen check-boxes, and each one is named to correspond to a single serial number.  That way a user can identify the serial number he/she would like to act upon.