I've been using OpenCATS to track affordable housing applications, and it's worked out great so far. I have a list in which I need to contact candidates in based on their randomly assigned log number, which I made a custom candidate text box field for. Since this list is for about 30,000 applications, I've been importing batches in based on their statuses (qualify/don't qualify, etc.). I imported the first few batches with the format from the original spreadsheet, and then realized that OpenCATS sorts based on the first character/digit, so 1 is followed by 10, rather than 2. I then imported the next batch after amending the format with zeros prefixed to the number. Unfortunately, when I tried to amend the first batches (e.g., 1 to 00001), the changes don't stick when I try to save. Attached is a photo of how things are sorting now.
Does anyone have suggestions on how to either sort by number, or how to edit the text field so that the zeros prefixed save? I've already begun attaching candidates to job orders, and I'd hate to have to delete everything and start all over for this list. Please let me know if the above needs any clarification.