Forum Discussion

RicardoSendra__'s avatar
RicardoSendra__
Qrew Trainee
6 years ago

Limit the # of times an Automation runs for Multiple updated records in the same table.

I have an Automation set to run a Table to Table import when a record changes in a table, the problem is that Multiple Records change at the same time and the Action is re importing the Table for ever...
Data import and export
Quickbase Automations
System performance
MattSaforrian's avatar
MattSaforrian
Qrew Member
Hi there,

Without reviewing your app, there are two approaches I can think of to resolve this.

1. Build a scheduled automation that runs your table import once a day.
2. Use an add/modify action that mirrors the record into the destination table instead of a table import.

Let me know if that helps.

Thanks!

-Matt
RicardoSendra__'s avatar
RicardoSendra__
Qrew Trainee
6 years ago
Thanks Matt,

This occurred to me after posting this and I fixed primary table that was multiplying, but I wanted to avoid having to duplicate this import code in different Automation(s). 

I liked that it was all defined in once place with the Table to Table Import.  Also the location of the Code would be in the correct App holding the final data instead of the DataFeed App.

Thanks for your feedback!