Skip to main content
Question

Translation Layer for an Inter-app pipeline.

  • June 2, 2026
  • 0 replies
  • 82 views
Forum|alt.badge.img+1

Hey Qrew!

Question for your expertise.

I have a request from my userbase to create a number of pipelines to help transmit a request from one app to another.

The gist is, when a request in system A meets certain criteria, that request needs to be submitted in system B or C. The pipeline will take the request details from system A and distribute them to the appropriate system.

The roadblock I'm facing is that I have site (name, company, address, etc) and site contact (name, email, phone, etc) data that needs to be brought over from system A into B or C, but none of the record IDs match between these systems. So if I use the pipeline and pull site record ID 10 from system A, site record ID 10 will pull something completely different in B and C. 

I need either a translation layer in each system, or if there is a way to universalize without ruining existent data, I would prefer that.

As always, your wisdom is appreciated!

MarkShnierYou
Forum|alt.badge.img+24

Well, this could get ugly in a hurry because it sounds like you don't have a consolidated company wide table for sites and Contacts.

So obviously in hindsight, the right solution is to have a table which is the single source of truth that all users update for this information and then all apps will draw from that Data either in across App relationship, but a better practice would be to have Connected Sync tables in each of the apps so the users get to see what's in the site table in the Contacts table locally within their own app. It also prevents Cross application dependencies which will approve the performance of the apps if you have a lot of data or a lot of transaction volume. 

Assuming factors like people names and site names are spelled perfectly exactly the same in both systems you can have a pipeline that goes off and searches for the site name in the other application and then uses that Record ID.   But in free form data entry in the separate systems for the site name,  it's very easy to get slightly different site names for the same physical site.

An interim solution would be to populate some pure data entry fields with those details and have a human intervene where the pipeline wasn't able to find an exact match.  

Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+11
  • Denin
  • Registered
  • June 2, 2026

What is the relationship between A, B, and C? Do they have anything in common?

Are you wanting to create new requests in B or C based on request submitted in A, or are you updating existing records in B and C based on A? Do you need these records synced or related in some way?

If you need some kind of match or sync, then you must create or identify some commonality and use that to associate or create your own new ID to associate the records.

Terms & ConditionsAccessibility statement