AnsweredAssumed Answered

Combining fields into one

Question asked by celticguardian93 on Dec 23, 2017
Latest reply on Jan 2, 2018 by celticguardian93

Hi, I'm helping my dad make an app to keep track quotes he underlined in books. He has 5 fields for topics contained within the quote. I'm trying to combine those five fields into one field. I tried using the script:

Topic 1 & ";" & " " & Topic 2 & ";" & " " & Topic 3 & ";" & " " & Topic 4 & ";" & " " & Topic 5

but if there is only one topic, it still shows the semicolons. I'd like to hide the unneeded semicolons if possible. Is there a way to do that? Thank you for your time and your help in advance!

Outcomes