I have a table called "Table A" that gets new data pushed to it every hour from our main data source. I have another field called "Table C" that I want all new unique instances of that data that currently wasn't in "Table A" to be pushed into "Table C". Is this possible?
Or you could replace Table C with a new Table D, and use QuickBase Sync. I hear that they are working in a way to allow a existing Table to be connected with a QuickBase Sync, but no timetable.
But I have no magic for an automated process.
Then after finding a way to identify table A records which need to be copied across, we would set up a saved table to table copy. You do that via the import button.
Then we would just run that with a button which would look like this
urlroot() & "db/" & [_DBID_of the target table] & "?act=API_RunImport&ID=10"
The creating of the records is easy. The detection of which ones need to be copied is the trick.
So let's discuss who we might know what makes a record unique.
Having said that, why not make all the records in table C be children of the Table A records so that if a table A record has no children,m then it need to have a child created. Then table C can get its fields as lookups from table A.