Skip to main content
khushbooverma
Level 2
Aug 18, 2021 6:25 AM UTC
Solved

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

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
Aug 18, 2021 7:23 AM UTC

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

View in thread

5 replies

Jyoti_Yadav
Jyoti_YadavAccepted solution
Level 8
Aug 18, 2021 7:23 AM UTC

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

Translate
khushboovermaAuthor
Level 2
Aug 18, 2021 8:08 AM UTC

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.   

Translate
Jyoti_Yadav
Jyoti_Yadav
Level 8
Aug 18, 2021 10:07 AM UTC

Hi @khushbooverma ,

 

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

 

Translate
Krishnanunni
Krishnanunni
Level 4
Aug 18, 2021 7:58 AM UTC

Hi @khushbooverma 

@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.

Translate
khushboovermaAuthor
Level 2
Aug 18, 2021 8:13 AM UTC

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. 

Translate
Terms & ConditionsAccessibility statement

Loading footer...