I exported a table in my database and literally 5 seconds later went to test the import of it. I changed nothing in the CSV exported. Adalo doesn’t want to recognize it’s own ID field from the CSV and is not part of the dropdown options. Am I the only one with the issue? The ID field is not referenced at all in the Aug '21 CSV files resource.
Hi Chris @vhbingham,
Welcome to the forum!
ID field is an automatically generated auto-incremented field and you can’t set it manually. For every new created record in the database the value of ID field will be increased by 1 (and record removal does not affect this logic).
I would also recommend to avoid naming any other field as “id” to avoid potential confusions later on.
Best,
Victor.