Formula Help
Hello! I'm struggling with writing a formula. Would love some assistance. Here is the situation.... I have 150 product options for users to select from. They can select multiple products, but ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
List(" ; ", ToText([field a]), ToText(field b]))
If you would prefer to not have the separate as space semi space, but want the sepration to be something else like just a tight semi between, then you could do this
var text LooseSemi = List(" ; ", ToText([field a]), ToText(field b]));
SerachAndReplace($LooseSemi, " ; ", ";")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
List(" ; ", ToText([field a]), ToText(field b]))
If you would prefer to not have the separate as space semi space, but want the sepration to be something else like just a tight semi between, then you could do this
var text LooseSemi = List(" ; ", ToText([field a]), ToText(field b]));
SerachAndReplace($LooseSemi, " ; ", ";")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
This worked perfectly!! Thank you so much!
------------------------------
Karen Henke
------------------------------
------------------------------
Karen Henke
------------------------------