0

Correct loop syntax

Hi guys,

I am trying to copy and paste a column with a more than 500 cells into another empty column through the use of a button. The mentioned button contains the following formula: 

let a := 'Paid/Applied to Date';

let b := 'Value of units completed';

for thisRecord in select Master do

                thisRecord.a := thisRecord.b

end;

but every time i save it the formula changes into:

let a := 'Paid/Applied to Date';

let b := 'Value of units completed to Avonline';

for thisRecord in select Master do

thisRecord.(a := thisRecord.b)

end

3 replies

null
    • Stefano_Stazzu
    • 5 yrs ago
    • Reported - view

    Also, when I press the button, ninox gets into an infinite upload.

    Any suggestions?

    Surely i am doing something wrong.

    Thanks in advance.

    • Stefano_Stazzu
    • 5 yrs ago
    • Reported - view

    *but every time i save it the formula changes into:

    let a := 'Paid/Applied to Date';

    let b := 'Value of units completed';

    for thisRecord in select Master do

    thisRecord.(a := thisRecord.b)

    end

    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi Stefano, 

    If I have understood you right, the formula should look like that: 

     

    for thisRecord in select Master do
    let a := thisRecord.'Value of units completed';
    thisRecord.('Paid/Applied to Date' := a)
    end

     

    Best, Jörg

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 3Replies
  • 2043Views