How to move from one table to another

How do you move items from one table to another....example....move from "active" table to "completed" table?

- Jorg
- 5 yrs ago
- Reported - view
Hi Sandra,

I assume you don't need to move items (data records) from one table to another. You should just mark them as "active" or "completed" with a choice field. That will allow you to create different views where can filter the data an only show the "active" records or only the "completed" ones in another view. Keeping all the records in one table will enable you to search for records more quickly, set different filter options and create better statistic charts.

Kind regards, Jörg
- GAJO GROUP d.o.o.
- Joze_Kuhar
- 4 yrs ago
- Reported - view
Hello, but i need to move it because i am constantly updating existing fields and let say I manualy change it from A to B but than when I update it again I don't want that they are changed back to A.
- Nick
- 4 yrs ago
- Reported - view
You can use a button with this code...

-----
let reply := dialog("ATTENTION", "I will move this record to Table B. Are you sure?", ["Yes", "No"]);
if reply = "Yes" then
let myB := (create 'Table B');
let myField1 := Field1;
let myField2 := Field2;
myB.(Field1:= myField1);
myB.(Field2:= myField1);
delete this;
openRecord(myB);
alert("Record moved successfully")
end
-----

Content aside