[DATATYPES] Textfield vs Float

Hi,

You should be able to sort and preform calculations on pricing information entered into CMS Builder the way it is right now without any changes. I do this for projects all the time.

Can you give me an example of pricing information and how you want to use it?

Just trying to determine if I can change the datatype of the "pricing" field from TEXT to FLOAT or INTEGER. Will CMS tools work without any issues?

FYI. I plan on using external SQL Admin tool to modify the table structure.

Hi,

Like Damon said, you are able to do numerical sorts and calculations on the data without having to convert the field type. If you'd like some specific example of how to do this, please let us know what you need to accomplish and we'll be able to help you out.

That being said, you can go and manually change the field types to FLOAT or INTEGER. We don't recommend doing this, but it is an option. You may run into certain errors. For example, if there is any value already stored in that field that is not a number, when you try to save that record, you'll most likely get a MySQL error. Likewise if someone ever tries to enter a character ($ , etc) you'll probably get a MySQL error there as well.

We don't support any changes made to the database that was not made directly by CMS Builder.

Hope this helps