We have Ninja Forms on our website connected to Google Sheets via Zapier, and it is working wonderfully except for passing data from fields that have multiple selectable options.
For example, a multiple checkbox field (in our case, select from multiple days - Mon, Tue, Wed, Thurs, Fri, Sat), when more than one option are selected, only 1 of the options is passed onto Google Sheets.
As a realtime scenario - if i select Mon, Tue, Wed options in the field on the Ninja Forms side, it may only pass over Mon to Google Sheets.
Has anyone had a similar issue or have any ideas?
Best answer by Troy TessaloneView original
Thanks for the swift reply - I have attached the images of one of the multiple option fields in ninja forms from one of the submissions with all 3 selected, an image of the field in google sheets for the same submission showing only 1 of the options in the cell, and the zap config.
would be appreciated!
Notice the  that indicates the first selected item in the array.
If 2 items are selected you’ll see a data point has  for the second selected item in the array.
You’ll need to map either a different field that includes all of the options OR map each of the options to this field.
Ah I get you - thank you for the response, I’ll try it out shortly and get back to you with how I go
Please post screenshots with how your Zap steps are configured along with an example of the issue, thanks.
Might also be worth checking if other related topics can provide guidance: https://community.zapier.com/search?q=ninjaforms