Copy data from one table to another when a field matches

[viviannaidoo]

Hi,

 

I have 2 tables(Table A & Table B )

The fields in the tables are Name and Percent (Name is a unique field)

I'm trying to get the Percent data to copy over from Table B to Table A when the name matches in both tables for each record

The issue is that the information in Table B will only be imported manually from an excel file so triggers won't work since they don't run on manual import.

Any idea how to go about doing this?

 

 

 

[MayMusic]

If that is the case, you can create a TASK instead of a triggered action. The difference is that it will run on a scheduled basis and will move the percent for all matching names.

[DefinitelyNot31337]

I think it's worth mentioning that data manipulation with the Tasks feature triggers Triggered Actions.

You might to disable your Trigger(s) first when running Tasks.

 

Regards,

DN31337