Forum Discussion

MattHardy's avatar
MattHardy
Qrew Trainee
4 years ago

Cross App Formula Query

Is it possible to run a formula query on a table in a different app? At present the tables are not related and I would prefer not to relate them if possible.

------------------------------
Matt Hardy
------------------------------
formula queries
Relationships
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    Cross App Formula Queries are not supported at this time.   This may have been done for App Performance reasons as they know that Formula Queries can be processing intensive.   Maybe you could use a Sync table to bring the data into your app.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • MattHardy's avatar
      MattHardy
      Qrew Trainee
      4 years ago
      That's what I expected. Thanks for the confirmation and suggestion Mark, I'll see if that will work for me.

      ------------------------------
      Matt Hardy
      ------------------------------
      • JohnCrosland's avatar
        JohnCrosland
        Qrew Trainee
        4 years ago

        Good morning,
        If the 1-hour sync timeframe is too long for you, then you can set up a Table and just keep it updated using Pipelines or Automations. Another option is to create a Cross-App Relationship and bring the values that you care about into the other app. This will prevent the need for additional Automations or Pipelines to transfer the data. You can just have one that runs when a new record is added to link it inside of the new Table.

        Good Luck!

        John



        ------------------------------
        John Crosland
        ------------------------------