Cross App Bonus Calculator
Hi everyone, I am struggling with how to create a bonus calculator for some members of my team. Here is my schema and what I am trying to accomplish:
App1: Team Elite - This is our ERP/Pro...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf there are no dependencies now then I certainly agree that you do not want to casually cross-link your applications because that can affect performance.
My suggestion is that Connected Sync tables are incredibly efficient. They can do very large tables with hundreds of thousands of records and they have minimal impact on performance while they are refreshing.
I would just make a Sync table of whatever you need for just the fields you need. I'm sure for bonus purposes the information is pretty stable as it is by its nature "retrospective".
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
My suggestion is that Connected Sync tables are incredibly efficient. They can do very large tables with hundreds of thousands of records and they have minimal impact on performance while they are refreshing.
I would just make a Sync table of whatever you need for just the fields you need. I'm sure for bonus purposes the information is pretty stable as it is by its nature "retrospective".
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Okay I did go this route with the sync table. Thanks Mark!
------------------------------
Ivan Weiss
------------------------------
------------------------------
Ivan Weiss
------------------------------