Here is my scenario, I want to record a drivers license ID, which in my country has the following format :
Right now I am saving it as a text column because I want to keep the dots ans dashes (and don.t want that +/- option associated with number columns) However I have to manually input the dots and dashes to have them saved in the DB with the right format.
But I want it to input in the form just the sequence of numbers i.e: 66688899900 and have it saved in the DB as 666.888.999-00. Is there a way to do so?
I have been trying to use concatenate to create a text expression but I cant make it work
This gives me the right output however I don`t know where to set it up in order for it to get the values from a form that is being filled.
Any clues on how to do that ?