How to save array in database?

[lambert15]

[swf]

Depends on how you like to save and retrieve data. You can save the values (IDs) comma separated in one field like 1,2,4,5 then you’ll need “split” to handle the data.

Or into an additional table with multiple records and the ID of the parent table like:

parentID childID
1 1
1 3
1 4
1 5

then you’ll have to use repeats to handle data. Hope this helps

[Teodor]

With the JSON fields you don’t need to split/join arrays any longer:

PREVIEW: Using JSON Database Fields to Store Multiple Choices

Intro You can use a JSON field in your database to store multiple choices like multiple checkbox or select values. In our example we will show you how to setup your database JSON field and how to generate an insert record form which will automatically create your checkboxes and their values and handle multiple value insert. Creating a JSON Database Field First let’s create a JSON field in our database table. Open the Database Manager: [Screenshot_2] We have a table storing our products: […

Multiple values are stored as arrays in the database

[lambert15]

Nice,I will check it sir, thanks.