CSV Upload Issue: All Boolean Values Turning Into “True”

Get Help
1

Hey everyone! has anyone run into this?

When I upload a CSV into one of my collections, the column that’s set as True/False keeps converting EVERYTHING to True, no matter what I try.

I tested a few combinations in the CSV:

  1. Entering FALSE

  2. Leaving the value blank

But after upload, every single row still ends up as True.

Is this a known issue or is there a specific format Adalo expects for Boolean fields during CSV import? Any tips would be appreciated!

Thanks!

2

Hello @ProvmanRI, please make sure to write them as the following:

  • true (If it’s true)
  • Leave it empty if it’s false

Thank you!

Ali Bazzi

3

yes, I left them empty also and it returned back as True

4

Completely blank or have any hidden spaces? Just tried and works nicely!

image

5

Thanks! I followed the steps exactly, left the cells blank and even double-checked there were no spaces. Still coming back as TRUE.”

6

@ProvmanRI, would you be able share a screen recording using loom.com?

7

Sure can

8

Hey @ProvmanRI, please if you can try it on another database collection and let me know if the issue persists there.

Thank you!

Ali Bazzi