How to create Multi-value field in Profile table in Adobe Campaign?

[khushboo_verma0790]

How to create Multi-value field in Profile table in Adobe Campaign. Or how we can store Checkbox multiple values in single field?

[Jyoti_Yadav · Accepted solution]

Hi Khushboo,

You can save values using a separator, like there are 3 checked values 'A','B','C'.

Write javascript to save checked value as one string separated by hypen or comma or linebar, i.e

'A-B-C' or 'A,B,C' or 'A|B|C'.

Thanks,

Jyoti

[khushboo_verma0790]

Hey Jyoti, 

Thanks for your reply, Yes We are currently Using Seperator for some of the field for getting values from tables and for reporting purposes. But Now I have a scenario where i have to do filter queries in my workflows on the basis of selected brand. And those brands will be collected by landing pages which will should be saved against one key. That is why i am looking for Multivalue field. Yes but using sepaterator will be my saviour if nothing works.   

[Jyoti_Yadav]

Hi @khushboo_verma0790 ,

You can query based on brand value received from Form. 

Use @brand contains 'variable value sent by form'. Only catch will be to use brand Code instead of brand Name and brand code should be of same length.

If we consider last example, suppose landing page sent value 'A' as brand, then you can query 

your brand table and fin out the brand code for that brand.

And then query using : "@brand contains brand code".

Thanks,

Jyoti

[Krishnanunni]

Hi @khushboo_verma0790 

@Jyoti_Yadav 's comment sure is feasible and convenient.  Another approach is that you create a Boolean column for each for the fields in recipient and mark true or false based on the value received. But revision in checkbox fields would require change in schema.

[khushboo_verma0790]

Thanks Krishnanunni!! Boolean Coulun will not serve the purpose as I want user to select multiple value and those multiple value should be save against one field. then only i will be able to filter that out in my workflows.. Otherwise i have check so many brands, using boolean true/false criteria.