GeorgeBramhall2
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Query giving values of zero
What's wrong with this query format. I have checked all the values and I should be getting values other than zero. SumValues(GetRecords("{80.EX.'"&[Concate Distance]&"'}and{47.EX.'Shipping'}and {66.XEX.0}",[_DBID_DISTANCES]),66) If I don't have the "and' filters QB gives me the error"Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula."Solved65Views0likes3CommentsRe: 1st Google Calendar Integration - how to update / delete
Hi Mark, Have you since tried updating a Google Calendar event by Fetching a Linked On New Event (Linked Advanced) which is set in the Add event pipeline? This has worked for me without having to "write back" the Event ID. Maybe you can help with the reverse, i.e. updating the "linked" QuickBase record when the Google Calendar event is updated. I have tried Fetching a QuickBase record by choosing the resource Event Updated from the Google Calendar event step, but I am not getting any activity for the pipeline when the Google Calendar event is updated. Interestingly, even though I show no pipeline activity, I am showing that the pipeline was triggered by the Google Calendar event update.41Views0likes3Comments