Forum Discussion
MikeKlausing
7 years agoQrew Assistant Captain
I was able to mimic this action by using the following formula on a combined text field:
var text CombinedText = ToText([Combined Text Window Size]);
var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");
// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","<br>")
That makes it look like this:
I still havent found the proper way to combine the fields if they are 3 seperate fields entirely.
------------------------------
Mike Klausing
------------------------------
var text CombinedText = ToText([Combined Text Window Size]);
var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");
// substitute new line for semicolon
SearchAndReplace($RemoveSpaceAfterSemiColon,";","<br>")
That makes it look like this:
This is exactly what I need to do with the original question as well where they have the option of having 4 total items in this list, but if not it doesnt leave blanks.
I still havent found the proper way to combine the fields if they are 3 seperate fields entirely.
------------------------------
Mike Klausing
------------------------------