Right, so I have run into this exact same problem myself. If the automation had a trigger record then the fields from the trigger record would be available. But because it is a scheduled automation there is no trigger record.
So I think there are two alternatives. One is to set up a saved table to table copy with those same filters on white records need to be updated and have the scheduled automation run that on your schedule. It remains to be seen what QuickBase plans for us when it comes to the migration of automations for running saved table to table imports. But at a minimum it will be possible to manually convert that automation by calling the API in the pipeline.
The other alternative would be to have an automation update each of those records and apply a checkbox to a certain field. Then you can have another automation the triggers when the checkbox is changed to do the actual update you were looking for. Since the second one will be based on a trigger event rather than a schedule you will find that the fields from the trigger record will be available to you.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
