0

Massive update refused

Hello, I created a field 'Name2' to reformat the field 'Name', in uppercase. The idea is to have "John" in 'Name2' while I have "JOHN" in 'Name'.

My code is :
Name2 := upper(substr(Name, 0, 1)) + lower(substr(Name, 1, length(Name) - 1))

When pasted in the 'calculates value' of 'Name2' in massive update, I receive the message : "This formula cannot modify the data." (I get this message in French, so my translation may be approximative.)

Any idea ?

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 4 yrs ago
    • Reported - view

    Alain,

    You better make a button or use the console for this. Afterwards you can delete the button again.

    Formula should be something like this:

    ---

    for i in select Yourtable do

    i.Name2 := capitalize(lower(Name))

    end

    ---

     

    Note: Take a BACKUP before trying !

     

    Steven.

    • Alain.2
    • 4 yrs ago
    • Reported - view

    Steven,

     

    You solved my problem. Thanks a lot!

     

    Alain

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 628Views