Automation not copying records
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?
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?
