Let me switch the field type on an existing database.
I created a database and erroneously set a bunch of the fields to 'multi-select' when what I really wanted was 'string select.' I've already added things to this database and now I can't change the fields to the type I want without manually re-entering everything. Please let me edit the field type if the data already in the field does not conflict with the new type. (I.e. multi-select data could go to string values or plain text, and if it's string values but all the strings currently in the database are integers, let me convert it to integers.)
Gretchen S.
shared this idea
-
Vincent Irwin commented
Agreed. This is the most annoying and time consuming issue I currently have with Momento. I am evaluating switching from Airtable to Momento but csv imports set most fields as text and I don't see an easy way forward to change the field types and convert the data entries. When your database has thousands of entries entering the data again into a new field is not a very palatable option. It might be a deal breaker...
-
wouter.van.vliet commented
Seems to make sense. Of course not all field types would be compatible (how to convert string to integer, fx).
I just ran into something where I wanted to change a field type from Text to "Link to entry" - would have been nice if even that would be possible, perhaps with a search-sync-and-create wizard to make all the "Links to entries" possible.