The easiest way to do that is to create a second variable which is formatted and save that one instead of the original. For you case you would use the join function to convert the list into a nicely formatted string.
{note}
{formattedpropertystrategy=join(propertystrategy, "BLAZE_AND")}
Formatted Property Strategy: {=formattedpropertystrategy}
You would save this second variable to Data Blaze instead of the original.
{endnote}
Alternatively, may want to use a Multiple Select field type in Data Blaze for this type of Data. That would display your data as separate chips in Data Blaze:
If you used that field type, you wouldn't change how you were saving the values as the Multiple Select field type needs values in the original format.
I'm trying the same thing, but it looks like the datablaze multiple select field type need prepopulated options to allow the list values to be displayed as chip. Otherwise the field is empty.
In my use case, a snippet read column "Name" from table A , show a menu to select 1 or more of the values in table A . Then insert that result in column "User" in table B . "User" column need to be displayed as multiple select.
I can confirm that this behavior is expected @cdagenais. You need to make sure all the options are available when updating them via a Text Blaze snippet. This is done to avoid the potential issue of selecting invalid values, since the field can only contain approved values.
If you wish to set any possible value, this can be done using other fields such as the Text Field.
as the multiple select options I want to use are stored in another table, I managed to get the intended behaviour with the Link to table column type and passing the row id to dept->id as explained here Data Blaze | BSQL Reference
Only thing now is that if I use the datablaze select field , i get the id displayed in the form that I would like to hide.
There is no way to hide the IDs when selecting the value using the DB select menu, but a workaround is to get all the values from Data Blaze as a list, and then show only the names using a {formmenu} from the data you received.
Something like the below, where the "name" in x["name"] is the column name where your name is.
{dbselect: SELECT Type, Vial # FROM Open Nutrient Vials; space=0MSsJcbWTzhtX6WDaGm5KD; menu=no; name=form; multiple=yes}
{formmenu: values={=map(form, (x) -> x["name"])}; name=value}
{selectedValue=find(form, x -> x.type = value)}
{=selectedvalue}