Aug 13, 2024 05:32 AM
The problem is, for example when creating a new table from import, and having fields with 0s and 1s, it imports. then you change the field type to checkbox, and everything works.
Now, if you already have those fields as checkbox, and delete all the data from the table for ex, then import back in, the fields doesn't recognize the data and every checkbox field is just blank. the system should already determine when importing back the data to map correctly to the checkbox type field. and dont omite data.
Best regards, Lorenzo
Aug 13, 2024 05:35 AM
in my case, ive kind of lost data, and I have already made some interface designs . now I have to delete the whole table , import from the start, make all the necessary changes such as converting to checkbox, which I have like 17 fields just like that. and start all over in the interface design. When deleting the whole table and deleted table error will appear their, and if you click on it to try maybe select the correct table , the system just goes to a dead end, if you have to Delete the whole page and start a new design.. in my case is painful as just this table is around 50 fields.. and there's connections to to other tables, etc..
Aug 13, 2024 05:37 AM
Also, when importing CSV. the user should be able to select which character will be the default delimiter, for example in my exported data I had to choose * as the delimiter, when importing this is not recognized. I had to resort to import in excel and then to air table.