Skip to main content
Question

How to: Edit and automation and have it run again on all applicable records?

  • February 25, 2021
  • 0 replies
  • 89 views

Hi:

So, I've written automations (all variations on one theme) that transform input data to a secondary table that will contain the output data and formats we want in the end.  But, I've realized that I need to edit the automation now because its not acting the way I want it to. It's copying over some blank values which won't  be useful and will just be confusing.  My thought was: remove all the secondary table records, make a field on the input data table that I can change simultaneously and Voila, the automation will run again.  I used Mark Shnier's focus date range parent-child table method to make a single field change simultaneously throughout the table and no luck. No automation fired.  Is there another strategy I should use?

Hmm, I guess since I'm still in app building mode I would be able to export the records the automation will run on, clear all the records, and re-import the records. That should fire the automations again. But that's probably not a good strategy in a live app environment.

Thanks
Dave



------------------------------
Dave Halter
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Can you take a step back from the technical questions and explain the business process you are trying to do?  There may be a way better way than Automations.  Are you trying to have a process to routinely receive raw data via a manual import, transform and clean it up, and then push to your real data table?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------