0

Is it possible to turn a multiple choice field into text with values separated by a “|” ?

Hello

I am working with a website developer who is trying to integrate my ninox database with woocommerce via zapier... one of the things we need to do for zapier to read ninox is turn multiple choice fields into text with each value separated by a “|” (is it called a “pipe mark”?).

I can turn the multiple choice value into text by using the formula text(multiplechoice), but that results in each value being separated by a comma, i.e. choice1, choice 2, choice 3. Does anyone know how to replace the comma with a “|” so that it becomes choice1 | choice2 | choice3 

Many thanks

Ben

2 replies

null
    • Sean
    • 4 yrs ago
    • Reported - view

    Ben,

    Here are a couple of easy ways to do that...

     

    join(chosen(“MC Table2”), “|”)

    or

    replace(text(“MC Table2”), “,”, “|”)

    • Earthsong Seeds
    • Ben_Heron
    • 4 yrs ago
    • Reported - view

    Thank you Sean - much appeciated!

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 520Views