Forum Discussion

VinayakSoni1's avatar
VinayakSoni1
Qrew Member
6 years ago

App Help

​​Team,

we are trying to build an app that gets information from other apps in quickbase and not able to get one requirement fulfilled.

Scenario:
Table details
A - Parent App and Email is available
B - fetch ID on the basis of Email mapping
C- fetch Hours on the basis of ID mapping

1) Need to show all Id's mapped to an email address (existing in a different table) on the basis of email of the person logged in and then Standard hours for that ID that exists in another table
2) The ID's exists in separate table and so is the hours
3) I should have option to select the ID's which I want to use in my app and also hours should be editable in the form

Please advise if this is doable.

------------------------------
Vinayak Soni
------------------------------
App builders
Ask about Quickbase functionality
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    6 years ago
    Can you be more specific to what you are trying to achieve. 

    If I understood correctly, fetch details from different app based on the email address in parent app table.  There are mutliple approach to this.

    1) Use cross-app relationship and setup a copy of the table in your parent app and then build relationship- This is the old method and hampers the performance.

    2) Use Quickbase sync to create a read only copy of your different app table in your parent app. Set permissions to hide from all role. Create relationship as required.

    3) Use webhook, create a read only copy of you different app table in parent app and use webhook to refresh the table so that it is always with latest data. create relationship as required.

    ------------------------------
    Babi Panjikar
    ------------------------------