Convert text from checkbox in database by insert

Ask the community
,
1

Hey,
I have a multiple dropdown menue and insert the data of the clicked checkboxes in a RichTextField in the database.

Is there any way to convert the text from this style:

[
“apple”,
“banana”,
“something”
]

into this ?

  • apple

  • banana

  • something

Maybe with some html ?

2

Is the first one a string or an array?

3

It’s a string.

4

@nickoertel so:

 let originalString = 
`[
  "apple",
  "banana",
  "something"
]`;
let arr = originalString.split('"');
arr.pop();
arr.shift();
arr = arr.filter(e => e.trim() !== ",");
let newString = "• " + arr.join("\n• ");
5

@jonatandor35 Hey, I tried your code, but I don’t get the bullet points.

Let me explain, what I’m trying to do.

I have a multiple checkbox menu in a custom form:


You can check 0 - 3 checkboxes (you don’t have to check them)
When I insert the data into my database

"fieldkey": $w("#checkboxGroup1").value,

I get this as result:
[
“apple”,
“banana”,
“something”
]

But I want to convert it into this style:

  • apple

  • banana

  • something

I can also use single checkboxes, if it would be easier to code.

6

@nickoertel I asked you if it’s a string or an array and you said it was a string. Now it looks like it an array. So first make sure that is and then we’ll be able to proceed.

7

@jonatandor35 Hey, sorry about this.
I had an idea and it worked, here’s my result :grinning:

  1. Go to your checkboxGroup and insert
  2. YourText
    3. as value


Then use this code (for example in the insert function)

 const toInsertDatabase = {
 "fieldKey": "<ul>" + $w('#checkboxGroup1').value.toString() + "</ul>"
    };
8

@nickoertel I see. the question is what you’re trying to do with these values. If you want to use them as html then your code is fine.
Another direction is to use the value without

  • , and to write:

    const toInsertDatabase = {
"fieldKey": `<ul><li>${$w("#checkboxGroup1").value.join("</li><li>")}</li></ul>`
};