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
-
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
-
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
-
With trigger after update, and some if then statements, should be possible.
Content aside
- 5 yrs agoLast active
- 3Replies
- 2015Views