I'm going to be importing some info using DataGrab for about 700 entries (on this site an entry is a construction project). One of the fields is a number that shows the cost of the project. On the front end of the site users need to be able to order the projects based on the cost. I want to display the cost on the front end with commas where necessary ($1,123,345). What is the best way to setup the import for that field? If it's a text field would I be able to order if it has numbers and commas? If it is a numbers field would I be able to add commas after the fact? I just don't want the client to have to go back and redo the projects import file. Any ideas would be great! Thanks.
I would setup the field as a text input field and set the field content to
number –this way sorting on the front end can work properly (ie. sort highest to lowest, etc.). Remove all currency characters & thousands separators on the numbers before importing.
Re: formatting, you can use several different number format addons to achieve the thousands separator.