Just making this post to be informative, in case anyone else was confused as I was. I noticed that after 25.03, all the phone numbers saved in IT Flow lost their formatting and now just appear as a string of digits. When you add the country code, it will automatically adjust the number into a more readable format. I have only done this with US numbers, but I assume this would be the same with different country codes as well.
Phone number formatting change
- Edited
if this is changed from the admin panel, will it update the entire clients list?
I saw it does work for a single client, but the country code has to be manually entered.
opensourcefollower I'm not sure if this can be changed globally from the admin panel. I have just been updating individual clients and contacts as I open them. Please post here if you discover another way of doing this!
im sure there's a way.
im thinking of going to the sql(using phpmyadmin)
and drop the following lines
UPDATE clients
SET phone = CONCAT('1 (', SUBSTRING(phone, 1, 3), ') ', SUBSTRING(phone, 4, 3), '-', SUBSTRING(phone, 7))
WHERE phone NOT LIKE '1 (%';
at least that's what master "copilot" recommended
ill check on that later on today.
Make a backup first!
I would be careful relying on SQL commands from AI.
I haven't tested any of this but check out this post: https://forum.itflow.org/d/1688-country-code-set-to-1/2