Possible to map multiple checkboxes on a record producer to one field on the main table?

[C_dric Chen]

Hello, everyone.

Here is what I'm trying to achieve: On the record producer, there will be multiple checkboxes for different social media platforms, and the users would check all the social media platforms that would be involved in their requests. I'm trying to find whether it's possible to save all the choices in one field, as below:

Any feedback would be greatly appreciated by this n00b!

[Tudor]

Hi Chen,

Yes, you can achieve that, but I'd have to do the following:

• in the record producer you will not use the OOTB functionality "Map to field", but a script that will run through the checkbox variables and if true populate your desired field
• your desired field will need to be:
• a list collector, which will not likely point to a different table containing the same options.
• string field, but in this case, you will need to parse it to create additional logic based on the selection
• of use the tags field, but here it will be a bit tricky because tags are used withing the whole instance, not only on your desired table

Hope this helps!

Tudor

[Ankur Bawiskar]

Hi,

yes why not

you can use record producer script and check which checkboxes are checked and accordingly combine them to some string field on target table

Regards
Ankur

[Ankur Bawiskar]

@Cédric Chen 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

[Ankur Bawiskar]

@Cédric Chen 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur