bloom-housing / bloom

Bloom is Exygy’s affordable housing platform. Bloom's goal is to be a single entry point for affordable housing seekers and a hub for application and listing management for developers.
https://bloomhousing.com
Apache License 2.0
33 stars 26 forks source link

AC: Application Confirmation Codes in Scientific Notation #4458

Open iph-97 opened 3 weeks ago

iph-97 commented 3 weeks ago

we recently got a question from a property manager in AC about applicant confirmation codes being read in Excel as scientific notation. This happens when an id has the letter "E" placed in a position that excel reads as scientific notation, (i.e. "219E01BE" turns into "2.19E+26"), and it renders the confirmation number unreadable. Excel conversions on the spreadsheet don't convert it back to the original number, but they'd turn it into "219,000,000,000,000....". This is a known issue, and typically has been handled manually. However, the number of applications received in AC is making this more difficult to manage. Can we consider omitting the letter "E" from confirmation numbers, or some other intervention to avoid this problem? Low priority, thank you!