This is correct. Collection Field Keys are always lowercase, and Field Keys are what is used in a query ( not the Field Name). What happens is that if an insert is performed using a Field Key that does not exist in the collection, a new field is created with the “new” field key in square brackets. Exactly what happened to the O.P.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Duplicate field created when inserting a new record | 2 | 176 | June 6, 2018 | |
| Strange behavior when inserting into a collection | 3 | 225 | January 8, 2018 | |
| Troubles with Collection Entries | 2 | 187 | May 10, 2018 | |
| wixData.insert() creates a new field in the database | 2 | 410 | February 7, 2020 | |
| Database saving my info in new fields that it creates | 0 | 111 | September 4, 2018 |