‘Property Type’ and 'Type mismatch'

I changed the ‘Property Type’ of a property field from ‘Text’ to ‘Number’. Now I am getting a warning message ‘Type mismatch, expected Number’ on the existing notes which has this property field.

The property only contains number characters (I use it to save Year, so it contains only a four-digit number). How can I get rid of this error/warning messages in the existing note easily?

Thank you!

Maybe the number is still stored as "1234", which would be recognized as a string.

You can click on the warning on the right, to convert the property to the new type:
image

Thank you! But I have more than 1000 notes, so I am looking for an easier way to achieve this instead of doing one by one manually.

You can try bases plugin. Filter for the respective notes, copy the whole column to a new number-type property, delete old values and then paste the values back.

Alternatively, folder-wide search and replace with regex.

1 Like