Is there a way to populate multiple, Yes or No filed using a comma-delimited string?

[HowDoYouWannaDoThis]

I have a comma-delimited value of different choices that my users picked from a different form. Now I want to create a new DataPage (tabular report) that will get this data and convert to a yes/no field

Ex.

apple, orange, pear will turn to:

apple | Orange | Pear | Mango

  Y               Y               Y               N

 

 

[Wikiwi]

If you're looking for a trigger solution then you can use this.

The trigger above will take your comma-delimited string and check for a "substirng" (in this case one of your choices) if it's in that string. If it did find the specific value then it will return a 1 which is greater than 0 causing the condition to set the value for that Yes/No field to True.

[Kurumi]

Hi @HowDoYouWannaDoThis - if you want to display it only, you may use Calculated Field as well: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/