Skip to main content
Question

I'm trying to create a relationship between 2 apps

  • March 27, 2019
  • 0 replies
  • 46 views
So I have 2 apps, The main one with an employee table and a side one with a out of office table that states when someone is expected to be out of the office and who is going to temporarily fill in for them.

I would like to connect both of them to have a field pop-up saying who is going to be the temporary fill in for employee's who out of office. It seems so easy, but I can't seem to figure it out.

I tried making a relationship from the employee to the out of office table and it seemed to give me the information I wanted, but it broke the employee table. I tried the other way around, but that only allowed me to create summary fields for the employee table. 
This topic has been closed for replies.

  • KingslySamuel
  • Quickbase Alumni
  • March 27, 2019
Are these two tables or two apps? If two apps, is there any connection (like a key field) common between the two apps? In other words, the employee name should be the same (and linked) between the two apps and then you can achieve what you are trying in the out of office app.
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • March 27, 2019
Two apps and The employee name are linked.
  • KingslySamuel
  • Quickbase Alumni
  • March 27, 2019
Hmmm ... it should work. It looks like you have done everything right. What is the breaking in the employee app? Did you try doing it in the out of the office app?
  • ArchiveUser
  • Author
  • Quickbase Alumni
  • March 27, 2019
When I did it through the employee app, it only allowed me to say it's one out of office to many employees, when I needed it the other way around. Which I think in turn, made the employee table rely on the out of office table in their respective apps. When I do it from the out of office app, the relationship is correct, one employee have many out of office, but it only allows for summary fields to be created for the employee app.  
Terms & ConditionsAccessibility statement