Hello Jay,
If possible on your app, I suggest creating a summary field to obtain the Hours total (on a parent record that would be associated with all the children that contain those hours you want to sum up.
Then with the pipeline you can grab the Hours total from that summary field you created and send it to the other app.
Alternatively, you can obtain the Hours total by creating a formula query field, that will query (as your pipeline does) all the records and return the sum of Hours. SumValues() formula query function – Quickbase Help
Let me know if you have questions.
------------------------------
Alberto Tablada
Alberto@bluewellgroup.com
Lead Software Engineer
BlueWell Group
Florencia
+50688083124
------------------------------
Hi Alberto,
Thank you for your reply! Do you know if the SumValues function will work across different app?
Thanks
Qrew LegendJay, Formula Queries do not currently work cross app. That was an initial limitation they did while they were assessing performance impacts of using Formula Queries and has not changed.
A thought would be to bring in the data from the other table into a Connected Sync table set to refresh every hour. That might be OK for your needs. You can just bring in the minimum # of fields you need to have available for the Formula Query.
