Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords(...
I will bet you a hamburger that you can write a query that matches those parameters but it will not work. That is too many variables for a formula query to swallow. I will often get the failure message when my only parameter is
{3.EX.'" & [Record ID#] & '"}
Formula queries are very fragile. I crippled a clients main application last week when I was testing what I though was a small one. I had to open a Support Case to get the application back up and running. The complexity of the query, yours is very high, and the size of the table combine to cause the instability.
Actually, I'm with Don here. What I always do with anything remotely complex is to make a formula checkbox field to match the report filters. Then check that the record count matches for qualifying records. Then the formula query is stupid simple.
var text QUERY = "{99.EX.1}";
Size( GetRecords($QUERY))
// Replace the 99 with the formula checkbox field ID#
"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer_Scripts\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/customComponent/CustomComponent\"]})":[{"__ref":"CachedAsset:text:en_US-components/customComponent/CustomComponent-1742314867000"}],"message({\"id\":\"message:88519\"})":{"__ref":"ForumTopicMessage:message:88519"},"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/ThreadedReplyList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeIcon\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1742314867000"}],"message({\"id\":\"message:88522\"})":{"__ref":"ForumReplyMessage:message:88522"},"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1742314867000"}],"message({\"id\":\"message:88524\"})":{"__ref":"ForumReplyMessage:message:88524"}},"CachedAsset:pages-1742462094414":{"__typename":"CachedAsset","id":"pages-1742462094414","value":[{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Anonymous","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MM-dd-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420","mimeType":"image/png"},"Category:category:connect":{"__typename":"Category","id":"category:connect","entityType":"CATEGORY","displayId":"connect","nodeType":"category","depth":1,"title":"Connect","shortTitle":"Connect","parent":{"__ref":"Category:category:top"}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Forum:board:quickbase-discussions":{"__typename":"Forum","id":"board:quickbase-discussions","entityType":"FORUM","displayId":"quickbase-discussions","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Quickbase Discussions","description":"A forum for Qrew members of all levels, where questions about Quickbase can be asked and answered.","avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420\"}"},"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:connect"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:kqufx49752"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:connect"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}},"canReadNode":{"__typename":"PolicyResult","failureReason":null}},"shortTitle":"Quickbase Discussions","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"LIKES","repliesFormat":"threaded"},"forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/","tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"FREEFORM_AND_PRESET"},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":20,"name":"Qrew Cadet","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:17397":{"__typename":"User","id":"user:17397","uid":17397,"login":"QuickBaseAdmi10","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"email":"","messagesCount":27,"biography":null,"topicsCount":10,"kudosReceivedCount":3,"kudosGivenCount":3,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-10-16T15:08:24.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ForumTopicMessage:message:88519":{"__typename":"ForumTopicMessage","uid":88519,"subject":"Expanded URL to Formula Query","id":"message:88519","revisionNum":1,"repliesCount":5,"author":{"__ref":"User:user:17397"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:88519"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:88519"},"body@stripHtml({\"truncateLength\":200})":" Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords(...","body@stringLength":"1524","rawBody":"
Hello, I am hoping someone much smarter than I can help solve this puzzle. I have a report on an activities table. I want to search the same parameters that the report has within a size(GetRecords()) formula query in order to showcase how many records the user can expect to generate. The first thing I did was to go to the report, unswitch the 'new style', choose 'more', and then select \"show expanded url for this report\". Which gives me this (made minor change to allow the formula query to save):
The above expanded url equals the below (report parameters)
How can I modify this expanded url and turn it into a workable formula query? Any and all tips/ tricks are welcomed.
Thank you!
","kudosSumWeight":0,"postTime":"2024-10-01T15:34:23.439-07:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04ODUxOS1JZzRMckg?revision=1\"}"}}],"totalCount":1,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMnwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:formula query","text":"formula query","time":"2024-04-10T12:23:43.524-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:88519_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":71},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"customFields":[]},"Conversation:conversation:88519":{"__typename":"Conversation","id":"conversation:88519","solved":false,"topic":{"__ref":"ForumTopicMessage:message:88519"},"lastPostingActivityTime":"2024-10-02T07:11:32.193-07:00","lastPostTime":"2024-10-02T07:11:32.193-07:00","unreadReplyCount":5,"isSubscribed":false},"ModerationData:moderation_data:88519":{"__typename":"ModerationData","id":"moderation_data:88519","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04ODUxOS1JZzRMckg?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04ODUxOS1JZzRMckg?revision=1","title":"image.png","associationType":"BODY","width":944,"height":635,"altText":""},"Revision:revision:88519_1":{"__typename":"Revision","id":"revision:88519_1","lastEditTime":"2024-10-01T15:34:23.439-07:00"},"ForumReplyMessage:message:88523":{"__typename":"ForumReplyMessage","id":"message:88523","conversation":{"__ref":"Conversation:conversation:88519"},"author":{"__ref":"User:user:12614"},"revisionNum":1,"uid":88523,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"subject":"Re: Expanded URL to Formula Query","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:88523"},"parent":{"__ref":"ForumReplyMessage:message:88522"},"body":"
Actually, I'm with Don here. What I always do with anything remotely complex is to make a formula checkbox field to match the report filters. Then check that the record count matches for qualifying records. Then the formula query is stupid simple.
var text QUERY = \"{99.EX.1}\";
Size( GetRecords($QUERY))
// Replace the 99 with the formula checkbox field ID#
","body@stringLength":"411","rawBody":"
Actually, I'm with Don here. What I always do with anything remotely complex is to make a formula checkbox field to match the report filters. Then check that the record count matches for qualifying records. Then the formula query is stupid simple.
var text QUERY = \"{99.EX.1}\";
Size( GetRecords($QUERY))
// Replace the 99 with the formula checkbox field ID#
","kudosSumWeight":1,"repliesCount":1,"postTime":"2024-10-01T17:38:08.711-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:88523_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":23},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"customFields":[],"replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"ForumReplyMessage:message:88524"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1742462093949":{"__typename":"CachedAsset","id":"theme:customTheme1-1742462093949","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"3px","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"Browser_Favicon_QB_Icon_512x512-1711046472639.png","imageLastModified":"1711046475044","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"quickbase-logo-300-1711548884441.png","imageLastModified":"1711548886217","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1320px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"3px","borderRadius":"3px","borderRadiusLg":"5px","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"400","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-body-color)","secondaryTextHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.9))","secondaryBgColor":"#2C9382","secondaryBgHoverColor":"hsl(170.10000000000002, 53.9%, 31.8%)","secondaryBgActiveColor":"hsl(170.10000000000002, 53.9%, 26.2%)","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-body-bg-h), var(--lia-bs-body-bg-s), var(--lia-bs-body-bg-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-body-bg-h), var(--lia-bs-body-bg-s), var(--lia-bs-body-bg-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0","md":"0","lg":"0","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-primary)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#1DD1E0","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#28A745","blogColor":"#2C9382","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#2C9382","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#F25E30","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#10503C","secondary":"#333333","bodyText":"#000000","bodyBg":"#FFFFFF","info":"#17A2B8","success":"#28A745","warning":"#FFC107","danger":"#B50000","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#2C9382","#F25E30","#1DD1E0","#F2B203","#FFABA2","#363432","#E6EEEB","#AAA9A8"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Tinos","fontStyle":"NORMAL","fontWeight":"700","h1FontSize":"56px","h2FontSize":"48px","h3FontSize":"36px","h4FontSize":"32px","h5FontSize":"24px","h6FontSize":"24px","lineHeight":"1.2","subHeaderFontSize":"14px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":null,"imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"10px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"10px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"AvenirNext3","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"20px","fontSizeXxs":"11px","fontSizeXs":"14px","fontSizeSm":"16px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"AvenirNext","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext-normal-400.woff2","AvenirNext-normal-500.woff2","AvenirNext-normal-600.woff2","AvenirNext-normal-400.woff2","AvenirNext-normal-500.woff2","AvenirNext-normal-700.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"AvenirNext2","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext2-normal-400.woff2","AvenirNext2-normal-500.woff2","AvenirNext2-normal-700.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"AvenirNext3","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext3-normal-400.woff2","AvenirNext3-normal-500.woff2","AvenirNext3-normal-700.woff2"],"__typename":"CustomFont"},{"source":"GOOGLE","name":"Tinos","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"}],"assetNames":["Tinos-italic-400.woff2","Tinos-normal-400.woff2","Tinos-normal-700.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1742314867000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1742462091996":{"__typename":"CachedAsset","id":"quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1742462091996","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","className":null,"props":{"hideIfEmpty":true,"enablePagination":true,"useTitle":true,"listVariant":{"type":"unstyled","props":{"listItemSpacing":"xxl"}},"instanceId":"1737477728716","pageSize":5,"style":"compact","pagerVariant":{"type":"loadMore"},"viewVariant":{"type":"inline","props":{"useRepliesCount":false,"useMedia":false,"useAuthorRank":false,"useNode":false,"useCompactSpacing":true,"boardIconSize":"24","useTimeToRead":false,"useSpoilerFreeBody":true,"useKudosCount":false,"useNodeLink":true,"useViewCount":false,"usePreviewMedia":true,"useBody":false,"timeStampType":"postTime","useTags":false,"clampSubjectLines":2,"useBoardIcon":true,"useMessageTimeLink":true,"useTextBody":true,"useSolvedBadge":false,"renderPostTimeBeforeAuthor":true,"useAvatar":false,"useAuthorLogin":true,"useVideoPreview":false}},"lazyLoad":false,"panelType":"standard"},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1742314867000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1742314867000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.TCmPzV.title":"Forum Discussion","section.XYHOid.title":"Forum Discussion"},"localOverride":false},"CachedAsset:quiltWrapper:quickbase.prod:Common:1742462005234":{"__typename":"CachedAsset","id":"quiltWrapper:quickbase.prod:Common:1742462005234","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":"header.png","backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"RIGHT_CENTER","lastModified":"1709066928000","__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-body-bg)","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"migrated-link-0","params":{"boardId":"welcome-to-the-qrew","categoryId":"overview"},"routeName":"BlogBoardPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-2","params":{"boardId":"quickbase-discussions","categoryId":"top"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"categoryId":"qrew-networks-"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"migrated-link-4","url":"https://qrewchampions.influitive.com/forum/","target":"BLANK"}],"linkType":"INTERNAL","id":"migrated-link-1","params":{"categoryId":"qrew-networks-"},"routeName":"CategoryPage"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-6","url":"https://university.quickbase.com/","target":"BLANK"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"getting-started","categoryId":"getting-started"},"routeName":"ForumBoardPage"},{"linkType":"EXTERNAL","id":"migrated-link-8","url":"https://www.quickbase.com/customers","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-9","url":"https://www.quickbase.com/exchange","target":"BLANK"}],"linkType":"INTERNAL","id":"migrated-link-5","params":{"boardId":"quickbase-knowledge","categoryId":"learn"},"routeName":"TkbBoardPage"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-11","url":"https://helpv2.quickbase.com/hc/en-us","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-13","url":"https://helpv2.quickbase.com/hc/en-us/categories/4404742594708-Release-Notes","target":"BLANK"},{"linkType":"INTERNAL","id":"migrated-link-14","params":{"boardId":"quickbase-knowledge","categoryId":"learn"},"routeName":"TkbBoardPage"},{"linkType":"EXTERNAL","id":"migrated-link-12","url":"https://team.quickbase.com/qb/support/newcase?subject=New+Case","target":"BLANK"}],"linkType":"EXTERNAL","id":"migrated-link-10","url":"https://helpv2.quickbase.com/hc/en-us","target":"BLANK"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-16","url":"https://www.quickbase.com/events","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-17","url":"https://www.quickbase.com/empower","target":"BLANK"}],"linkType":"EXTERNAL","id":"migrated-link-15","url":"https://www.quickbase.com/events","target":"BLANK"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-18","params":{"boardId":"the-qrew-blog-","categoryId":"blog"},"routeName":"BlogBoardPage"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-19","params":{"boardId":"job-board","categoryId":"connect"},"routeName":"ForumBoardPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"700","controllerHighlightColor":"#F25E30","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"16px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"26px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"flex-start","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-primary)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"0","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":false},"backgroundOpacity":50,"backgroundImageProps":{"backgroundSize":"COVER","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"var(--lia-bs-white)","linkHighlightColor":"#363432","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"linkTextColor":"#363432"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer","props":{"customComponentId":"custom.widget.Custom_Footer"},"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer_Scripts","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1742314867000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer-en-1742462107317":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1742462107317","value":{"component":{"id":"custom.widget.Custom_Footer","template":{"id":"Custom_Footer","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer_Scripts-en-1742462107317":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Scripts-en-1742462107317","value":{"component":{"id":"custom.widget.Custom_Footer_Scripts","template":{"id":"Custom_Footer_Scripts","markupLanguage":"HANDLEBARS","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer_Scripts","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1742314867000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1742314867000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1742314867000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1742314867000","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"localOverride":false},"Category:category:qrew-networks-":{"__typename":"Category","id":"category:qrew-networks-","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:job-board":{"__typename":"Forum","id":"board:job-board","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Tkb:board:quickbase-knowledge":{"__typename":"Tkb","id":"board:quickbase-knowledge","tkbPolicies":{"__typename":"TkbPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:getting-started":{"__typename":"Forum","id":"board:getting-started","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:the-qrew-blog-":{"__typename":"Blog","id":"board:the-qrew-blog-","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Rank:rank:18":{"__typename":"Rank","id":"rank:18","position":19,"name":"Qrew Assistant Captain","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:38208":{"__typename":"User","id":"user:38208","uid":38208,"login":"CharlotteM","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T14:10:57.000-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-3.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":51,"kudosGivenCount":12,"kudosReceivedCount":11,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:38208"},"ForumTopicMessage:message:90035":{"__typename":"ForumTopicMessage","uid":90035,"subject":"Formula Query with custom key","id":"message:90035","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:38208"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:90035"},"moderationData":{"__ref":"ModerationData:moderation_data:90035"},"postTime":"2025-03-04T12:34:51.475-08:00","lastPublishTime":"2025-03-04T12:34:51.475-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":27},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:90035"},"Conversation:conversation:90035":{"__typename":"Conversation","id":"conversation:90035","solved":true,"topic":{"__ref":"ForumTopicMessage:message:90035"},"lastPostingActivityTime":"2025-03-04T14:07:39.036-08:00","lastPostTime":"2025-03-04T14:07:39.036-08:00"},"ModerationData:moderation_data:90035":{"__typename":"ModerationData","id":"moderation_data:90035","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:90035":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:90035","relatedMessage":{"__ref":"ForumTopicMessage:message:90035"}},"User:user:15208":{"__typename":"User","id":"user:15208","uid":15208,"login":"JeremyLahners","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-12-13T06:12:51.000-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":18,"kudosGivenCount":7,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:kqufx49752/user:15208"},"ForumTopicMessage:message:82746":{"__typename":"ForumTopicMessage","uid":82746,"subject":"Formula Query for null dates","id":"message:82746","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:15208"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:82746"},"moderationData":{"__ref":"ModerationData:moderation_data:82746"},"postTime":"2022-01-11T06:29:00.000-08:00","lastPublishTime":"2022-01-11T06:29:00.000-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":249},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:82746"},"Conversation:conversation:82746":{"__typename":"Conversation","id":"conversation:82746","solved":true,"topic":{"__ref":"ForumTopicMessage:message:82746"},"lastPostingActivityTime":"2022-01-11T06:54:00.000-08:00","lastPostTime":"2022-01-11T06:54:00.000-08:00"},"ModerationData:moderation_data:82746":{"__typename":"ModerationData","id":"moderation_data:82746","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:82746":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:82746","relatedMessage":{"__ref":"ForumTopicMessage:message:82746"}},"Rank:rank:20":{"__typename":"Rank","id":"rank:20","position":21,"name":"Qrew Trainee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:13965":{"__typename":"User","id":"user:13965","uid":13965,"login":"DonStrickland","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-11-20T18:46:17.000-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-9.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":4,"kudosGivenCount":0,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":1,"entityType":"USER","eventPath":"community:kqufx49752/user:13965"},"ForumTopicMessage:message:20237":{"__typename":"ForumTopicMessage","uid":20237,"subject":"advanced query in a pipeline","id":"message:20237","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:13965"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:20237"},"moderationData":{"__ref":"ModerationData:moderation_data:20237"},"postTime":"2023-12-05T13:11:00.000-08:00","lastPublishTime":"2023-12-05T13:11:00.000-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":347},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:20237"},"Conversation:conversation:20237":{"__typename":"Conversation","id":"conversation:20237","solved":true,"topic":{"__ref":"ForumTopicMessage:message:20237"},"lastPostingActivityTime":"2023-12-05T13:28:00.000-08:00","lastPostTime":"2023-12-05T13:28:00.000-08:00"},"ModerationData:moderation_data:20237":{"__typename":"ModerationData","id":"moderation_data:20237","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:20237":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:20237","relatedMessage":{"__ref":"ForumTopicMessage:message:20237"}},"User:user:22258":{"__typename":"User","id":"user:22258","uid":22258,"login":"RaymondSakar","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-01-05T04:22:18.000-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":21,"kudosGivenCount":3,"kudosReceivedCount":4,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:22258"},"ForumTopicMessage:message:16655":{"__typename":"ForumTopicMessage","uid":16655,"subject":"Current User in Formula Query","id":"message:16655","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:22258"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:16655"},"moderationData":{"__ref":"ModerationData:moderation_data:16655"},"postTime":"2022-11-25T12:41:00.000-08:00","lastPublishTime":"2022-11-25T12:41:00.000-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":46},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:16655"},"Conversation:conversation:16655":{"__typename":"Conversation","id":"conversation:16655","solved":true,"topic":{"__ref":"ForumTopicMessage:message:16655"},"lastPostingActivityTime":"2022-11-28T16:35:00.000-08:00","lastPostTime":"2022-11-28T16:35:00.000-08:00"},"ModerationData:moderation_data:16655":{"__typename":"ModerationData","id":"moderation_data:16655","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:16655":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:16655","relatedMessage":{"__ref":"ForumTopicMessage:message:16655"}},"User:user:14765":{"__typename":"User","id":"user:14765","uid":14765,"login":"BradElmore","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T14:13:42.000-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"messagesCount":91,"kudosGivenCount":23,"kudosReceivedCount":28,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:14765"},"ForumTopicMessage:message:88398":{"__typename":"ForumTopicMessage","uid":88398,"subject":"Formula Query (Size) - Question","id":"message:88398","revisionNum":1,"repliesCount":2,"author":{"__ref":"User:user:14765"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:88398"},"moderationData":{"__ref":"ModerationData:moderation_data:88398"},"postTime":"2024-09-19T07:58:35.819-07:00","lastPublishTime":"2024-09-19T07:58:35.819-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":82},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:88398"},"Conversation:conversation:88398":{"__typename":"Conversation","id":"conversation:88398","solved":false,"topic":{"__ref":"ForumTopicMessage:message:88398"},"lastPostingActivityTime":"2024-09-19T12:47:06.210-07:00","lastPostTime":"2024-09-19T12:47:06.210-07:00"},"ModerationData:moderation_data:88398":{"__typename":"ModerationData","id":"moderation_data:88398","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:88398":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:88398","relatedMessage":{"__ref":"ForumTopicMessage:message:88398"}},"CachedAsset:text:en_US-components/community/Navbar-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1742314867000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"App Exchange","migrated-link-7":"Getting Started","migrated-link-8":"Success Stories","migrated-link-1":"Connect","migrated-link-10":"Help","migrated-link-2":"Quickbase Discussions","migrated-link-11":"Quickbase Help","migrated-link-0":"Welcome","migrated-link-5":"Learn","migrated-link-6":"Quickbase University","migrated-link-3":"Qrew Groups","migrated-link-4":"Qrew Champions Program ","migrated-link-18":"Blog","migrated-link-19":"Job Board","migrated-link-16":"Qrew Events","migrated-link-17":"Empower","migrated-link-14":"Qrew Tips","migrated-link-15":"Events","migrated-link-12":"Open Support Case","migrated-link-13":"Release Notes"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1742314867000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1742314867000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1742314867000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1742314867000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1742314867000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1742314867000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1742314867000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageDeepLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1742314867000","value":{"viewFullDiscussion@board:FORUM":"View Full Discussion ({repliesCount} Replies)","viewFullDiscussion@board:BLOG":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:TKB":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:IDEA":"View Full Discussion ({repliesCount} Comments)","viewFullDiscussion@board:OCCASION":"View Full Discussion ({repliesCount} Comments)","showParents@board:FORUM":"Show Parent Replies","showParents@board:BLOG":"Show Parent Comments","showParents@board:TKB":"Show Parent Comments","showParents@board:IDEA":"Show Parent Comments","showParents@board:OCCASION":"Show Parent Comments"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1742314867000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1742314867000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1742314867000","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1742314867000","value":{"alt":"Powered By Khoros"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1742314867000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1742314867000","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1742314867000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1742314867000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1742314867000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1742314867000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1742314867000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1742314867000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1742314867000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1742314867000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1742314867000","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1742314867000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/cmstMjktSnVCdmZL\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/cmstMjktSnVCdmZL","height":1084,"width":1085,"mimeType":"image/png"},"Rank:rank:29":{"__typename":"Rank","id":"rank:29","position":7,"name":"Qrew Legend","color":"2C9382","icon":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/cmstMjktSnVCdmZL\"}"},"rankStyle":"FILLED"},"User:user:12614":{"__typename":"User","id":"user:12614","uid":12614,"login":"MarkShnier__You","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/images/dS0xMjYxNC1qTzNlY2M?image-coordinates=0%2C315%2C3024%2C3340"},"rank":{"__ref":"Rank:rank:29"},"email":"","messagesCount":8582,"biography":null,"topicsCount":52,"kudosReceivedCount":1054,"kudosGivenCount":181,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-23T06:11:10.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":222},"ModerationData:moderation_data:88523":{"__typename":"ModerationData","id":"moderation_data:88523","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ModerationData:moderation_data:88522":{"__typename":"ModerationData","id":"moderation_data:88522","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"User:user:17863":{"__typename":"User","id":"user:17863","login":"DonLarson","uid":17863,"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-12.svg?time=0"},"rank":{"__ref":"Rank:rank:14"},"email":"","messagesCount":812,"biography":null,"topicsCount":23,"kudosReceivedCount":101,"kudosGivenCount":142,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-27T12:17:48.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":22,"entityType":"USER","eventPath":"community:kqufx49752/user:17863"},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":15,"name":"Qrew Elite","color":"333333","icon":null,"rankStyle":"TEXT"},"ForumReplyMessage:message:88522":{"__typename":"ForumReplyMessage","id":"message:88522","revisionNum":1,"uid":88522,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:88519"},"subject":"Re: Expanded URL to Formula Query","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:88522"},"body":"
I will bet you a hamburger that you can write a query that matches those parameters but it will not work. That is too many variables for a formula query to swallow. I will often get the failure message when my only parameter is
{3.EX.'\" & [Record ID#] & '\"}
Formula queries are very fragile. I crippled a clients main application last week when I was testing what I though was a small one. I had to open a Support Case to get the application back up and running. The complexity of the query, yours is very high, and the size of the table combine to cause the instability.
","body@stringLength":"653","rawBody":"
I will bet you a hamburger that you can write a query that matches those parameters but it will not work. That is too many variables for a formula query to swallow. I will often get the failure message when my only parameter is
{3.EX.'\" & [Record ID#] & '\"}
Formula queries are very fragile. I crippled a clients main application last week when I was testing what I though was a small one. I had to open a Support Case to get the application back up and running. The complexity of the query, yours is very high, and the size of the table combine to cause the instability.
","author":{"__ref":"User:user:17863"},"isEscalated":null,"postTime":"2024-10-01T17:15:15.334-07:00","solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"kudosSumWeight":0,"repliesCount":2,"images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:88522_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":26},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"Revision:revision:88523_1":{"__typename":"Revision","id":"revision:88523_1","lastEditTime":"2024-10-01T17:38:08.711-07:00"},"QueryVariables:ReplyList:message:88523:1":{"__typename":"QueryVariables","id":"ReplyList:message:88523:1","value":{"id":"message:88523","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1742314867000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1742314867000","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1742314867000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1742314867000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false},"Revision:revision:88522_1":{"__typename":"Revision","id":"revision:88522_1","lastEditTime":"2024-10-01T17:15:15.334-07:00"},"ModerationData:moderation_data:88524":{"__typename":"ModerationData","id":"moderation_data:88524","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:88524":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:17863"},"id":"message:88524","revisionNum":1,"uid":88524,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:88523"},"conversation":{"__ref":"Conversation:conversation:88519"},"subject":"Re: Expanded URL to Formula Query","moderationData":{"__ref":"ModerationData:moderation_data:88524"},"body":"
This is a much better idea than putting the pieces in a formula query.
This is a much better idea than putting the pieces in a formula query.
","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:88524_1"},"latestVersion":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}}},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1742314867000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"Revision:revision:88524_1":{"__typename":"Revision","id":"revision:88524_1","lastEditTime":"2024-10-01T18:33:23.810-07:00"}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"quickbase-discussions","messageSubject":"expanded-url-to-formula-query","messageId":"88519","replyId":"88523"},"buildId":"q_bLpq2mflH0BeZigxpj6","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"quickbase","openTelemetryServiceVersion":"25.2.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/community/FooterWidgetHelpLink/FooterWidgetHelpLink.tsx","./components/community/KhorosLogo/KhorosLogo.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[]}
Qrew Legend