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

3 replies

null
    • Birger_H
    • 6 yrs ago
    • Reported - view

    Use a button for this. The formula would be something like this:

    –––
    let myPrev := create 'previously banned';
    let myA := 'Field A';
    myPrev.'Field A' := myA;
    myB := 'Field B';
    myPrev.'Field B' := myB;
    [...]
    delete(this)
    –––

    Birger

    • Ben_Davey
    • 6 yrs ago
    • Reported - view

    Thank you that worked well. Is there way it can be changed so that once the field ‘end date’ hits today’s date it moves over to the other table on its own without the need to press a button 

    • SMoore
    • 6 yrs ago
    • Reported - view

    With trigger after update, and some if then statements, should be possible. 

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2016Views