I’m using Make (formerly Integromat) to import a row from Excel into Knack. The import works well for all the fields except for the Choice (Yes/No) fields. No matter what settings I use, it seems to always set the Choice field to “Yes”. Make offers a lot of ways to prep the data before sending it over to the API, but I can’t find the magic one that will work.
It works if you make that column empty then it shows as false(No) if there is any value in that column is setup as true(Yes).
Thanks Sunny! That makes sense, no matter what I put into the field, it kept showing up as true - but I didn’t think of making it an empty field. Thanks!