Discussions

Expand all | Collapse all

table to table imports to remove data

  • 1.  table to table imports to remove data

    Posted 20 days ago
    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
    ------------------------------


  • 2.  RE: table to table imports to remove data

    Posted 20 days ago
    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
    ------------------------------



  • 3.  RE: table to table imports to remove data

    Posted 20 days ago
    Great Idea, Thanks!

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