Copy record from one app to another app

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
we've have 2 teams working on 2 different apps. When team A is done with their work that record needs to be copied to another app (team B will continue to work with that copied record). Is it possible to copy a record from one app to another. Any help appreciated. Thanks.
Photo of QuickbaseUser

QuickbaseUser

  • 474 Points 250 badge 2x thumb
  • unsure

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
This can be done, but will more than likely require a custom script.  
I'm assuming your record is rather large, and there is most likely child records associated with it.  There might even be some file attachments as well.

You will need a custom script to transfer that much data.

***
This is a shot in the dark, but if you don't have multiple layers of data, and have less than 10 fields to transfer, you could do this through a URL button, but beyond that you'll want to go with script.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 2,266 Points 2k badge 2x thumb
Is it a single-table record?  Are there attachments?  

If the answer is that it's a single-table record and there are no attachments you can use a Table-to-Table import which you would need to fire using a button to launch it from the record you are pushing.  The button would usually have to "mark" the record in some way (like a checkbox) and then run the Table-to-Table Import in the other Application which can then come back to the record and mark it as "transferred" with a date/time field.  There are also other more advanced options for marking a record which doesn't do all this; but ultimately when transferring data, unless you are then deleting it from the source table; it's a good idea to mark it as transferred.

You have to do this so that the next record that is pulled in the table-to-table import doesn't import the same record again that were already transferred.

If you do have attachments, then you may want to consider pulling the data via the Table-to-Table import and populating a cross-app-Relationship so that you can access the file attachments in Application B when the attachments exist in Application A.

Users would need access to both apps to do all of this because it would be their User permissions creating records in Application B from Application A.  
Photo of Cassie

Cassie

  • 182 Points 100 badge 2x thumb
This is what I need to do for intakes, if the case is opened I would like to add the data fields directly into the system and not have to retype the info. Can you break down the process a little more?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Cassie,
I suggest that you explore "Actions".  This is very new and were not in general release until about a month or so ago.  It allows you to create a record hen a record is added elsewhere.

Look in the "Settings" for the table where the record is first entered.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,502 Points 20k badge 2x thumb
This can be done easily with a short script using the FormData API and the Fetch API. It makes no difference if there are file attachment fields. I am at a conference at the moment but when I get back home I will show you how do to this. The other suggestions to use (1) actions, (2) Table-to-Table import or (3) formula URLs are all outdated in comparison to using the FormData API. and the Fetch API.