Lookup from one table to another table on different APP

  • 0
  • 1
  • Question
  • Updated 12 months ago
  • Answered
Looking for ideas if I can lookup information from one APP table to another.  Have field service app and would like to be able to pull info from our other APP that has tables to the project.  ie; be able to look up the Project name/number from a different APP used for daily reports.  Thanks in advance
Photo of Glenn Soden

Glenn Soden

  • 80 Points 75 badge 2x thumb

Posted 12 months ago

  • 0
  • 1
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
The simplest approach may be using Quickbase sync tables across apps, then building your relationship. Depending on what info you are trying to bring across, you can even total the information first in a parent table then sync the parent table. We total the # of open cases per sales rep in our case management app, then sync that table into our CRM to use as a lookup field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
The other approach is across app relationship.

Start at the child side and when you make it will initially block you until you go to the Parent App and App properties and allow your child p to make a relationship. Do you may as well do that first.

But then you go to the child table and make the relationship and choose “ from another app” as the parent and follow the prompts.
Photo of Kevin O'Boyle

Kevin O'Boyle

  • 602 Points 500 badge 2x thumb
I've been told by quickbase that when you build cross-app relationships, it brings the two apps into the same server process - and with single-threading this will adversely impact performance of both apps.  I've experienced this which is why I recommended the above - I don't know the size of the apps Glenn is referring to so it may not be an issue for him 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
Kevin,
Yes, that is a valid consideration.
Photo of Glenn Soden

Glenn Soden

  • 80 Points 75 badge 2x thumb
Thanks for the input.  Were evaluating this as replacement to our existing CRM.  Though in the learning curve I like to find limitations and try to break things ;-)  and we currently have many related objects because of field limitations.  Another option (not sure if will work) is take this other application and just create a new table on existing APP, which brings up new question -  can you copy all of an APPS fields etc into a table or is this a "recreation"
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
You can copy a table from one app to amother on a one time basis. With or without data.