0

format phone number after update

Hello,

how can I change a phone number that has been inserted using the 0049xxxxx format to +49xxxxx.

I need this to work on the trigger after update field.

I can select the first 2 digits using let codcat := substring(Phone, 0, 2); but I don't know how to have it updated into "+"

 

Thanks for any help

4 replies

null
    • Alain_Fontaine
    • 2 wk ago
    • Reported - view

    replacex(Phone,"^00","+")

      • CLD
      • Valerio
      • 2 wk ago
      • Reported - view

       thanks, but it's not working.. nothing happens

      • Alain_Fontaine
      • 2 wk ago
      • Reported - view

       There are several ways to make use of this formula:

      1- putting it in a formula field;

      2- defining a button with the action: Phone := replacex(Phone, "^00", "+");

      3- in the "Trigger after update" option of the "Phone" field, putting Phone := replacex(Phone, "^00", "+");

      4- in a "Bulk edit", replacing the value of "Phone" by the computed value replacex(Phone, "^00", "+")

      • CLD
      • Valerio
      • 2 wk ago
      • Reported - view

      working now! thanks for your help

Login to reply

Content aside

  • Status Answered
  • 2 wk agoLast active
  • 4Replies
  • 34Views
  • 2 Following