How to move rows from one table to another? Or can I lock a box when status is X for example?
We have orders that are comming into ninox (let say 1,2,3). We also give those order status (csv import). But than we change some orders statuses and when we import (csv, again) than those orders have previous status back.
So we would need to make that when status is X we need to lock this box so it cannot be changed.
Even better if we can make that if status become X than move this row to another table. :)
How can we do that?
6 replies
-
Hello, can I get answer?
Best Regards
-
Hi,
Please use the import options like "Only new records", "Update only field". This will avoid overwriting already existing values in your records.
Kind regards, Jörg
-
No, you don't understand what I am doing :)
Best Regards
-
This is what you need?
let myField1 := TableA_Field1;
let myField2 := TableA_Field2;
let myB := (create 'Table B');
myB.(TableB_Field1:= myField1);
myB.(TableB_Field2:= myField2);
delete this;
openRecord(myB); -
Joze,
I think we had an exellent example of what you mean yesterday in the www.nioxus.com webinar.
The video in not yet available but will soon been publisched on his site.
Look in the webinar vault for the video of the past webinars under the section PROGRAMMING & CODING IN NINOX
The video date is Thursday Juli 25,2019 .... but as i said, not yet available. (https://www.nioxus.com/z5w112)
-
Here is a template from the 2019 webinar
https://drive.google.com/open?id=1PCaEfxf_hOcmPcJ7A6wnK85bKn6WH6Im
Content aside
- 5 yrs agoLast active
- 6Replies
- 1967Views