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
------------------------------

markshnier__you · 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

dantetognoli · Answer

Great Idea, Thanks!------------------------------Dante Tognoli------------------------------

Forum Discussion

table to table imports to remove data

Related Content

Merge Imports

Pipeline to add Parent record from child import

Importing data in Tables

Moving Fields from One Table to Another

How do I run a Table to Table Import?