Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
If you use
ToText([My Multi-Select field])
then it will be a text in a formula.
ToText([My Multi-Select field])
then it will be a text in a formula.
- WayneMajor6 years agoQrew CadetI tried this, except i get an error basically stating that the ToText() function does not support conversions from a textlist (It basically says it is looking for text, numbers, bools, etc. but found textlist)
- QuickBaseCoachD6 years agoQrew CaptainThe formula will save just fine. The formula editor has a bug in it which is giving a false warning.
- JimHarrison6 years agoQrew ChampionThis is not true. The error no longer saves the formula and does not implement.
For example this does not work.
If(Contains([Eye Wear Type(s)],ToText([Eye Wear Type(s)]))) - AustinK6 years agoQrew CommanderJim you might have to also do this... Give it a try. That is my best guess since Contains is supposed to work with a text field, that is probably where the error was. IF this one does not work then I will test it myself.
If(Contains(ToText([Eye Wear Type(s)]),ToText([Eye Wear Type(s)]))) - JimHarrison6 years agoQrew ChampionYeah, tried that too. Noped.
- QuickBaseCoachD6 years agoQrew CaptainI don�t understand in English what you are trying to test for. The formula looks incomplete.
- WayneMajor6 years agoQrew CadetI have again recently tested with converting a Text List using ToText() and it worked fine for me, Jim maybe there is another area of your formula that is causing the data type error. If there is more to your formula than the line you commented above can you show it?
- JimHarrison6 years agoQrew ChampionHere's the entire thingy. I commented out all the other code to pinpoint only that one piece of code and it doesn't work.
//21 fields
//List(", ",
//If([Acid Suit],"Acid Suit"),
//If(Contains([Boot Type(s)], ToText([Boot Type(s)])),
//If(ToText([Eye Wear Type(s)])
//If([Face Shield],"Face Shield"),
//If([Fall Arrest System],"Fall Arrest System"),
//If([Fire Retardant],"Fire Retardant"),
//If([Hard Hat],"Hard Hat"),
//If([Hearing Protection],"Hearing Protection"),
//If([Kevlar Sleeves],"Kevlar Sleeves"),
//If([Metatarsal Guards],"Metatarsal Guards"),
//If([Reflective Vest],"Reflective Vest"),
//If([Respirator],"Respirator"),
//If([Rubber Boots],"Rubber Boots")
//)
//&
If(Contains(ToText([Eye Wear Type(s)]),ToText([Eye Wear Type(s)])))
//& If([Boots], ", Boots: " & [Boot Type(s)])
//& If([Gloves],", Gloves: " & [Glove Type(s)])
Plain english:
If the multi-select field named Eye Wear Type(s)_ has any selections checked, then display those selections in this formula rich text field. - QuickBaseCoachD6 years agoQrew CaptainTry this
If(ToText([Eye Wear Type(s)]),<> "", ToText([Eye Wear Type(s)])), - JimHarrison6 years agoQrew ChampionYeuss!!
If(ToText([Eye Wear Type(s)])<>"", ToText([Eye Wear Type(s)]))