Solved: Yes/No column value to be true/false - Page 2

Remco_Edelenbos · 01-23-2020 06:55 AM

Hi,

For a JSON put request i need the yes/no column to be true/false. I know that the backend value in google sheets is true/false but appsheet uses Y/N. Is there a way to force this? Ofcourse i can fall back on a EnumType. But i like the switch buttons on the Quick edit columns option.

-Remco

Remco_Edelenbos

THE SOLUTION: “true” and “false” in the IF statement with the " ". I think appsheets sends the true and false with Y /N. So we came back on the orignial problem

With big help from @LeventK!

{
  "PtProject": {
    "Element": {
      "Fields": {
        "PrId": "<<[Projectcode]>>",
        "U47E045AF46C52C9490047C8376873EF6": "<<IF([Plattegrond__check_]='Y',"TRUE","FALSE")>>"
      }
    }
  }
}

View solution in original post