I set up an AppSheet Database with several tables and all the columns set up. I then linked my App to an AppSheet Database.
Two of the columns ("Workday" and "NWDIntl") were initially configured to be enum data types in the database but I later on realized I could configure them as Lookup within the AppSheet Database and link the data to another table without having to use App Formula.
When I tried to change the datatype in the database from "Text" to "Lookup", the app generated an additional column "NWDIntl(1)". I have since tried to remove the columns from the database and regen the table structure in app but the "NWDIntl(1)" column still exists. I have also tried deleting the entire table in the app and readding it but to no avail. I have also tried clearing the cookies and cache from my browser.
Look forward to any advice on how to remedy this thanks!
#AppSheetDatabase #Database
User | Count |
---|---|
35 | |
9 | |
3 | |
3 | |
2 |