Forum Discussion

MiyakoMiyako's avatar
MiyakoMiyako
Qrew Member
9 years ago

How to move records from one table to another based on field input?

I have two tables within the same app. One table (Table A) contains records with Status A and the other table (Table B) contains records with Status B. I want to be able to move a record from Table A...
Formulas and functions
Tables and fields
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
>We all agree.  

No we don't! The original poster wants to use the two tables as an inbox/outbox moving a record from one table to the next and perhaps eventually deleting the record once the work is completed if there is no reason to keep a historical record of how it was disposed of. This is a reasonable workflow and there may be good reasons to structure it this way including security and/or information segregation. It is easy to do with JavaScript.