How do I update a record on a table, based on a record on another table that just got updated, it requires a record ID but the update record automation action only gives the record ID of the just updated record and not the ID of the target record
You have to determine the target record using information in the triggering record. For example, if the two records are linked, you can get the record ID from the linked record field. Or if the records are not linked, but have matching info, you can do a "Find Record" action based on info in the triggering record.
You have to determine the target record using information in the triggering record. For example, if the two records are linked, you can get the record ID from the linked record field. Or if the records are not linked, but have matching info, you can do a "Find Record" action based on info in the triggering record.
