Can Apps interact/share data with each other?

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

Hi. I am looking to build the shell of a platform for my company. In doing so, I need to identify the best way to manage our staff and projects in one place.

Currently (up for discussion of course) I envision having 1 App per Client, and within each App it would house all of their current projects (along with budgets, scope etc.). With regard to Staffing- one idea I had was to create an App that specifically held all Staffing details (Title, Bill Rate, which projects they are assigned to.. etc.). This would be accessible to our Staffing Coordinator that assigns resources to each project. Is that possible to do? Have Apps that interact with each other, and carry over data?

Say I have App 1 - Staffing; App 2 - Client A; App 3 - Client B; App 4 - Client C. While in Staffing, I can assign John, Peter, and Sally to Client A, Stephanie to Client B, and Michael to Client C. 

As the Project Manager of, example, Client A- I could then assign John, Peter, and Sally to the Projects currently running for Client A. Also, I would be able to assign them permissions as far as what they are able to see within each project.

Is any of that possible with QuickBase?

Your thoughts are appreciated.

Thank you
E

Photo of Eric

Eric

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
I highly recommend having 1 app. Do not split your app by client as you multiply the development effort by the factor of the number of clients and it will quickly drive you crazy.

Make 1 app with many tables.

While you can do "cross app relationships", its not a good way to go in your situation.
Photo of Eric

Eric

  • 0 Points
Understandable! And thank you for your thoughts, that makes sense. Follow up question: Are you suggesting that within that 1 app, I would make a table per client (or per project), and a table for staffing? Within that Staffing Table, could I see what project each individual is assigned to? And can you set permissions for team members per table? My challenge is that I may have 50 team members, but they are used differently (regardless of title) on any given project. While someone may be considered a Director within the company- they may be assigned to 2 projects. On Project A, they may Manage that project- therefore they should see the hours their team is working, budget info etc. But on Project B, they may only be filling in for a heavy period of time- and therefore perform similar functions to that of an Analyst. In which case, they should only need to see the tasks they've been assigned to.

So in Table 1- Staffing, they would be inputted as a Director with the appropriate bill rate etc. On Table 2 (Project A)- they would be running that project, bill based on the rate contained in Staffing, and therefore can see all screens and access all reports. On Table 3 (Project B)- they would bill based on the rate contained in staffing, but only be able to view the screens that an analyst would normally see.