Summary Field values not importing via automation activated table to table import
I have a Table set up for calculating employee's daily labor hours - This Table has several Summary Fields that look up the duration of labor hours in various categories for the day.
I have a Table-To-Table Import setup that copies the values from these Summary Fields to another Table when the user checks a box to submit their labor hours for the day. This Table-To-Table Import works perfectly fine when I manually go in and click the "Import" button in the Import From Table interface within QB.
The problem is, that when I assign that Table-To-Table Import to an Automation and trigger it, the import creates the records, but will not copy the values from the Summary Fields.
I have tried creating a Formula Fields in the first table that copy the values from the Summary Fields, and then using those formula fields in the Table-To-Table Import, that doesn't work either.
Am I missing something?
I have a Table-To-Table Import setup that copies the values from these Summary Fields to another Table when the user checks a box to submit their labor hours for the day. This Table-To-Table Import works perfectly fine when I manually go in and click the "Import" button in the Import From Table interface within QB.
The problem is, that when I assign that Table-To-Table Import to an Automation and trigger it, the import creates the records, but will not copy the values from the Summary Fields.
I have tried creating a Formula Fields in the first table that copy the values from the Summary Fields, and then using those formula fields in the Table-To-Table Import, that doesn't work either.
Am I missing something?
