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.
Solved! Go to Solution.
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.
You can combine an โexecute action on a set of rowsโ action, with a โadd new row to another tableโ action. Check out the following post for some ideas.
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.
Thank you so much. It was a great help i manage to record historical data on it.
Hi @Lucinda_Mason What if you want tio copi multiple rowโs from a table into an other tabel ?? we need to create mmultiple actions ? or how should be the best option ?
thank you in advice
Already tried that way but didnยดt work.
everything Iโve looked for has indicated that I should use API
What exactly did you try, and how exactly didnโt it work?
API is certainly another option to achieve this functionality. I wouldnโt go that route personally.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |