Hello!
I couldn't find an answer to this question when searching the forum but basically it goes like this:
We have a table that stores phone numbers (US-only) as a string eg. '1234567890'
To make the UI of the app easier to manipulate for our ops team, the number is formatted using the map feature to look like: '(123) 456-7890'. Now if they want to edit the value using bulk update, once they click the cell the value they are manipulating will be the full formatted string including the brackets and whitespace.
Is there a way how to adjust the functionality so that when user select the phone number cell to edit, instead of the mapped value they see the original underlying value without the mapping applied?
Thank you!