table to table imports to remove data

Question

I am using an automation to trigger an import of current employees. When an employee is no longer active I would like it to remove that employee from the target table. Is this possible? As an alternative I could use a report from another app on my homepage, but that doesn't seem to be possible either. Any suggestions are appreciated.

------------------------------
Dante Tognoli
------------------------------

MarkShnierYou · Answer

One solution assuming that you import these employees say daily on some automated basis, would be to import a field which contains the current date.

Then each employee who continues to be active will have that date be current. But of course employees that were not imported would have an old value for that date field in the target table. You could then have a nightly automation go through and delete employees wear that date last imported is older than say a week.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community