Tranferring new data from one table to another

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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?


Photo of Derek

Derek

  • 30 Points

Posted 3 years ago

  • 0
  • 1
I can think of s pretty easy button to make  do that "push". But you would need to push the button.

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.
Photo of Derek

Derek

  • 30 Points
Pushing a button a few times a day wouldn't be a problem.  How would you go about setting that up?
In general it would be this. We would need to find a way to know how you are defining unique instances.  Is there a unique identifier of the records?  So that may take some discussion back and forth either slowly on this forum or more quickly on a one to one session.

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.