0

Automatically move data

Hi,

I have 2 tables one called “Banned” and one called “Previously Banned”

the tables fields are identical.

Is there a way i can get a record to move from the “banned” to the “previously banned” once the banned date has passed automatically or by clicking a button. And from the “previously banned” to the “banned” table should the person get banned again.

 

Thanks,

 

Ben

2 replies

null
    • Tim_McManus
    • 7 yrs ago
    • Reported - view

    Would love a reply to this as I have the same question.

    • blackie
    • 7 yrs ago
    • Reported - view

    This is an answer from a different thread, same question.

    ————————————

    Use a formula:

    –––
    let myNewRecord := create 'Second Table';
    let myA := 'a field';
    myNewRecord.'a field' := myA;
    let myB := 'a second field';
    myNewRecord.'a second field' := myB;
    let myC := 'a third field';
    [...]
    –––

    Birger

Login to reply

Content aside

  • 7 yrs agoLast active
  • 2Replies
  • 1597Views