Solved: Copy Data from Table A (with data) to a Table B (b... - Page 2

John_Paul_Armis · 12-03-2020 08:12 PM

Hi Good Day,

I want to copy in Table A every row that has a “Cannot Be Reached” value in a Column TD Status and Paste it on Table B. Both Tables has a same count and name of columns.

Thank you for the big help.

Lucinda_Mason

This is how I do it.

Create action to add a new row. This particular action actually imports data from an outside source and I set multiple field values. You would just have the second column be the same column names. See dnr_no — [dnr_no]

Set the condition for the records you want copied

Create report for it to run automatically

Call the action made in the first step. I call a combo action which copies the rows and set the value of a column.

Hope this helps.

Oh, and make sure that whenever you change fields or field types in one table that they are changed in the second table.

View solution in original post

Copy Data from Table A (with data) to a Table B (blank data)