Discussions

Expand all | Collapse all

Automation not copying records

  • 1.  Automation not copying records

    Bronze
    Contributor
    Posted 08-06-2019 09:26
    I have 2 tables;

    Table 1:  Products (about 500 records)
    Table 2: Daily product valuations


    This is what I am trying to accomplish:


    1) Copy all the products from table 1 to table 2, every day at a scheduled time. 

    2) Fields to copy are: Description, cost, quantity on hand.

    3) This will allow me to get a snap shot of each stock item and its quantities/cost every day.

    4) I can then create a summary report in this "Daily products valuation table" to pin point the stock values and quantities at any given day.

    The problem:

    I am trying an automation:  but, an automation doesn't seem to be working (it runs, but no records are copied).  Does this have something to do with the 10 records a second rule?



    Is the use of an automation not going to work?  or is there a more novel solution to this?















  • 2.  RE: Automation not copying records

    Posted 08-06-2019 09:45
    No problem,

    Set up a saved table to table import mapping the fields from Table 1 to table 2.

    Edit your scheduled daily Automation to simply run the import. When you do it that way, there is no effective limit to the number of records you can copy and those saved imports run super fast.

    The Automation will run some time an hour or two after midnight.


  • 3.  RE: Automation not copying records

    Bronze
    Contributor
    Posted 08-06-2019 09:58
    Thanks for this Mark.  Is there any way I can set what time the automation can run?  


  • 4.  RE: Automation not copying records

    Posted 08-06-2019 10:13
    No, not natively.  The Automations run overnight.  If you need a very specific time you either need to be a coder or contract with a QSP such as Juiced to run that import on a schedule.  They have a flexible product called Triggers, which can do that.

    https://www.juicedtech.com/triggers

    https://docs.wixstatic.com/ugd/9e32c1_e899c1b870cb431988b4c2c391581f59.pdf