Formula URL to Add Records with a Reference Proxy Field
I have a table with lookup fields to related tables. Only one lookup field is required to be populated when adding a record, and that field has a drop down menu made up of a report link to a related ...
The reference field on the right side of the relationship needs to be populated by the API with the value of the key field of the parent record. Then all the lookup fields will populate.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
I thought more about what you said and, before I went into redesign, I managed to get the report link field to populate using the key. Unfortunately, other lookup fields to yet another table are based on an email address field. Those fields don't normally populate until the email address is entered and then the field "clicking" out of the field to let things calculate. Using the formula URL, those fields do not populate until after I choose to edit the newly added record. Any suggestions for how to handle that? Do I need to redesign anything?
------------------------------ James Carr ------------------------------
Immediately after I posted this, I thought about what the problem likely is. Dynamic form rules. I had an issue with the lookup working due to case sensitivity so, I have a hidden field that picks up the LCase of the email address. The lookup is done based on that field, which can't be edited. Dynamic form rules are in driven by the email address and the hidden email address fields for setting what sections are visible as well as setting couple of checkboxes. Will the URL not work because of the Dynamic form rules? Is there another API call I can make that will trigger the form rules after the record is added? I am looking to avoid having the record shown while being edited, if possible.
------------------------------ James Carr ------------------------------
I gather you're using an API to actually create a record so you were using the API of API_AddRecord
When you view that record the form rules would all activate in terms of show/hide, if you're expecting any formulas to edit the record then they will not fire until the form is put into edit mode. If you wanted any other fields to be populated to replicate what the form rules do then that would have to be built into the API_AddRecord. You can populate an unlimited # of fields with the one API. But, like I said I really am not understanding your question, this response may not help you!
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------
Sorry. So, you ended up answering my question, believe it or not. Lol. Unfortunately, I misunderstood my situation so, let me try again. I have lookup fields in the form. Some of them are for one related table and the rest for a 2nd related table. When I make the API_AddRecord call, only the lookup fields for one table is being populated. The other fields are blank. I do have the key for both related tables being populated with the API call so, I don't understand why the fields for one table are coming up blank. When I go into edit mode, they immediate populate so, I know the correct key is being added with the API call. Any input regarding that would be greatly appreciated.
James
------------------------------ James Carr ------------------------------
"}},"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\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/customComponent/CustomComponent\"]})":[{"__ref":"CachedAsset:text:en_US-components/customComponent/CustomComponent-1738074982000"}],"message({\"id\":\"message:18876\"})":{"__ref":"ForumTopicMessage:message:18876"},"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/ThreadedReplyList\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1738074982000"}],"cachedText({\"lastModified\":\"1738074982000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeIcon\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1738074982000"}],"message({\"id\":\"message:18877\"})":{"__ref":"ForumReplyMessage:message:18877"},"message({\"id\":\"message:18881\"})":{"__ref":"ForumReplyMessage:message:18881"},"message({\"id\":\"message:18882\"})":{"__ref":"ForumReplyMessage:message:18882"},"message({\"id\":\"message:18880\"})":{"__ref":"ForumReplyMessage:message:18880"}},"CachedAsset:pages-1741681584670":{"__typename":"CachedAsset","id":"pages-1741681584670","value":[{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1741681584670,"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:20":{"__typename":"Rank","id":"rank:20","position":21,"name":"Qrew Trainee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:6889":{"__typename":"User","id":"user:6889","uid":6889,"login":"JamesCarr","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:20"},"email":"","messagesCount":101,"biography":null,"topicsCount":18,"kudosReceivedCount":3,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-23T14:56:48.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:6889"},"ForumTopicMessage:message:18876":{"__typename":"ForumTopicMessage","uid":18876,"subject":"Formula URL to Add Records with a Reference Proxy Field","id":"message:18876","revisionNum":1,"repliesCount":27,"author":{"__ref":"User:user:6889"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:18876"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:18876"},"body@stripHtml({\"truncateLength\":200})":" I have a table with lookup fields to related tables. Only one lookup field is required to be populated when adding a record, and that field has a drop down menu made up of a report link to a related ...","body@stringLength":"803","rawBody":"
I have a table with lookup fields to related tables. Only one lookup field is required to be populated when adding a record, and that field has a drop down menu made up of a report link to a related table. I can api_addrecord to actually populate the necessary fields except, when I look at the new record, the lookup field is blank and the related fields didn't populate. When I choose to edit the record, the lookup fields immediately populate but I still have to select the drop down value.
\n\n
Is it possible to make a formula url that will lead to the lookup fields being populated after the call? Also, how do I populate the lookup field with the formul url? Is it even possible?
------------------------------ James Carr ------------------------------ ","kudosSumWeight":0,"postTime":"2023-02-16T20:26:00.000-08: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":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:18876_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":84},"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:18876":{"__typename":"Conversation","id":"conversation:18876","solved":false,"topic":{"__ref":"ForumTopicMessage:message:18876"},"lastPostingActivityTime":"2023-02-19T20:50:00.000-08:00","lastPostTime":"2023-02-19T20:50:00.000-08:00","unreadReplyCount":27,"isSubscribed":false},"ModerationData:moderation_data:18876":{"__typename":"ModerationData","id":"moderation_data:18876","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:18876_1":{"__typename":"Revision","id":"revision:18876_1","lastEditTime":"2023-02-16T20:26:00.000-08:00"},"ForumReplyMessage:message:18879":{"__typename":"ForumReplyMessage","id":"message:18879","conversation":{"__ref":"Conversation:conversation:18876"},"author":{"__ref":"User:user:6889"},"revisionNum":1,"uid":18879,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"subject":"Re: Formula URL to Add Records with a Reference Proxy Field","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:18879"},"parent":{"__ref":"ForumReplyMessage:message:18877"},"body":"
Hey Mark,
\n\n
I thought more about what you said and, before I went into redesign, I managed to get the report link field to populate using the key. Unfortunately, other lookup fields to yet another table are based on an email address field. Those fields don't normally populate until the email address is entered and then the field \"clicking\" out of the field to let things calculate. Using the formula URL, those fields do not populate until after I choose to edit the newly added record. Any suggestions for how to handle that? Do I need to redesign anything?
------------------------------ James Carr ------------------------------ ","body@stringLength":"680","rawBody":"
Hey Mark,
\n\n
I thought more about what you said and, before I went into redesign, I managed to get the report link field to populate using the key. Unfortunately, other lookup fields to yet another table are based on an email address field. Those fields don't normally populate until the email address is entered and then the field \"clicking\" out of the field to let things calculate. Using the formula URL, those fields do not populate until after I choose to edit the newly added record. Any suggestions for how to handle that? Do I need to redesign anything?
------------------------------ James Carr ------------------------------ ","kudosSumWeight":0,"repliesCount":24,"postTime":"2023-02-18T06:12:00.000-08: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:18879_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":57},"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:18880"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:theme:customTheme1-1741681583283":{"__typename":"CachedAsset","id":"theme:customTheme1-1741681583283","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1738074982000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1741681580873":{"__typename":"CachedAsset","id":"quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1741681580873","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1738074982000","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:1741681496986":{"__typename":"CachedAsset","id":"quiltWrapper:quickbase.prod:Common:1741681496986","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1738074982000","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-1741681611441":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1741681611441","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-1741681611441":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Scripts-en-1741681611441","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1738074982000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1738074982000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1738074982000","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}},"entityType":"TKB","displayId":"quickbase-knowledge","nodeType":"board","depth":2,"conversationStyle":"TKB","title":"Qrew Tips - The Qrew Knowledge Base","shortTitle":"Qrew Tips - The Qrew Knowledge Base","parent":{"__ref":"Category:category:learn"},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02OS1tWUNKM2I?image-coordinates=89%2C0%2C510%2C420\"}"},"description":"Qrew tips and more","eventPath":"category:learn/community:kqufx49752board:quickbase-knowledge/"},"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}}},"User:user:29168":{"__typename":"User","id":"user:29168","uid":29168,"login":"AudraMickles","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T14:23:47.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-2.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":5,"kudosGivenCount":4,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:29168"},"ForumTopicMessage:message:88604":{"__typename":"ForumTopicMessage","uid":88604,"subject":"Reference tables quandary","id":"message:88604","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:29168"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:88604"},"moderationData":{"__ref":"ModerationData:moderation_data:88604"},"postTime":"2024-10-09T09:33:36.739-07:00","lastPublishTime":"2024-10-09T09:33:36.739-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":48},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:88604"},"Conversation:conversation:88604":{"__typename":"Conversation","id":"conversation:88604","solved":true,"topic":{"__ref":"ForumTopicMessage:message:88604"},"lastPostingActivityTime":"2024-10-10T07:19:27.027-07:00","lastPostTime":"2024-10-10T07:19:27.027-07:00"},"ModerationData:moderation_data:88604":{"__typename":"ModerationData","id":"moderation_data:88604","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:88604":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:88604","relatedMessage":{"__ref":"ForumTopicMessage:message:88604"}},"User:user:15782":{"__typename":"User","id":"user:15782","uid":15782,"login":"RebeccaLutz","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T15:17:46.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-9.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":12,"kudosGivenCount":2,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:15782"},"ForumTopicMessage:message:87608":{"__typename":"ForumTopicMessage","uid":87608,"subject":"Tracking References and Definitions","id":"message:87608","revisionNum":1,"repliesCount":4,"author":{"__ref":"User:user:15782"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:87608"},"moderationData":{"__ref":"ModerationData:moderation_data:87608"},"postTime":"2024-07-11T13:50:15.968-07:00","lastPublishTime":"2024-07-11T13:50:15.968-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":85},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:87608"},"Conversation:conversation:87608":{"__typename":"Conversation","id":"conversation:87608","solved":true,"topic":{"__ref":"ForumTopicMessage:message:87608"},"lastPostingActivityTime":"2024-07-12T13:11:56.100-07:00","lastPostTime":"2024-07-12T13:11:56.100-07:00"},"ModerationData:moderation_data:87608":{"__typename":"ModerationData","id":"moderation_data:87608","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:87608":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:87608","relatedMessage":{"__ref":"ForumTopicMessage:message:87608"}},"Rank:rank:2":{"__typename":"Rank","id":"rank:2","position":2,"name":"Community Manager","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:3":{"__typename":"User","id":"user:3","uid":3,"login":"ben_simon","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2024-03-26T08:37:46.603-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/images/dS0zLVNETXlVWA?image-coordinates=0%2C0%2C800%2C800"},"rank":{"__ref":"Rank:rank:2"},"messagesCount":227,"kudosGivenCount":111,"kudosReceivedCount":114,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":3,"entityType":"USER","eventPath":"community:kqufx49752/user:3"},"Category:category:learn":{"__typename":"Category","id":"category:learn","entityType":"CATEGORY","displayId":"learn","nodeType":"category","depth":1,"title":"Learn","shortTitle":"Learn"},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02OS1tWUNKM2I?image-coordinates=89%2C0%2C510%2C420\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bi02OS1tWUNKM2I?image-coordinates=89%2C0%2C510%2C420","mimeType":"image/png"},"TkbTopicMessage:message:89189":{"__typename":"TkbTopicMessage","uid":89189,"subject":"Custom Record Titles","id":"message:89189","revisionNum":1,"repliesCount":0,"author":{"__ref":"User:user:3"},"depth":0,"hasGivenKudo":false,"helpful":null,"board":{"__ref":"Tkb:board:quickbase-knowledge"},"conversation":{"__ref":"Conversation:conversation:89189"},"contentWorkflow":{"__typename":"ContentWorkflow","state":"PUBLISH","scheduledPublishTime":null,"scheduledTimezone":null,"shortScheduledTimezone":null,"userContext":{"__typename":"MessageWorkflowContext","canSubmitForReview":null,"canEdit":false,"canRecall":null,"canSubmitForPublication":null,"canReturnToAuthor":null,"canPublish":null,"canReturnToReview":null,"canSchedule":false}},"moderationData":{"__ref":"ModerationData:moderation_data:89189"},"teaser@stripHtml({\"removeProcessingText\":false,\"truncateLength\":200})":"","postTime":"2024-12-02T07:00:00.044-08:00","lastPublishTime":"2024-12-02T07:00:00.044-08:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":22},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:learn/community:kqufx49752board:quickbase-knowledge/message:89189"},"Conversation:conversation:89189":{"__typename":"Conversation","id":"conversation:89189","solved":false,"topic":{"__ref":"TkbTopicMessage:message:89189"},"lastPostingActivityTime":"2024-12-02T07:00:00.044-08:00","lastPostTime":"2024-12-02T07:00:00.044-08:00"},"ModerationData:moderation_data:89189":{"__typename":"ModerationData","id":"moderation_data:89189","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:89189":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:89189","relatedMessage":{"__ref":"TkbTopicMessage:message:89189"}},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":20,"name":"Qrew Cadet","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:23253":{"__typename":"User","id":"user:23253","uid":23253,"login":"MeaganMcOlin","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-02-12T10:15:29.000-08:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/images/dS0yMzI1My1VblRFa3k?image-coordinates=0%2C1%2C957%2C958"},"rank":{"__ref":"Rank:rank:19"},"messagesCount":63,"kudosGivenCount":3,"kudosReceivedCount":5,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:23253"},"ForumTopicMessage:message:89315":{"__typename":"ForumTopicMessage","uid":89315,"subject":"Reference Numbers Displaying Instead of Names in QuickBase","id":"message:89315","revisionNum":1,"repliesCount":4,"author":{"__ref":"User:user:23253"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:89315"},"moderationData":{"__ref":"ModerationData:moderation_data:89315"},"postTime":"2024-12-11T08:46:07.688-08:00","lastPublishTime":"2024-12-11T08:46:07.688-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":45},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:89315"},"Conversation:conversation:89315":{"__typename":"Conversation","id":"conversation:89315","solved":true,"topic":{"__ref":"ForumTopicMessage:message:89315"},"lastPostingActivityTime":"2024-12-11T09:12:43.661-08:00","lastPostTime":"2024-12-11T09:12:43.661-08:00"},"ModerationData:moderation_data:89315":{"__typename":"ModerationData","id":"moderation_data:89315","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:89315":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:89315","relatedMessage":{"__ref":"ForumTopicMessage:message:89315"}},"User:user:7657":{"__typename":"User","id":"user:7657","uid":7657,"login":"KellyLyons","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-06-19T13:16:17.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-8.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":12,"kudosGivenCount":3,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:7657"},"ForumTopicMessage:message:85159":{"__typename":"ForumTopicMessage","uid":85159,"subject":"Multiple reference proxy fields help","id":"message:85159","revisionNum":1,"repliesCount":6,"author":{"__ref":"User:user:7657"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:85159"},"moderationData":{"__ref":"ModerationData:moderation_data:85159"},"postTime":"2024-03-23T16:51:00.000-07:00","lastPublishTime":"2024-03-23T16:51:00.000-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":75},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:85159"},"Conversation:conversation:85159":{"__typename":"Conversation","id":"conversation:85159","solved":true,"topic":{"__ref":"ForumTopicMessage:message:85159"},"lastPostingActivityTime":"2024-03-25T15:18:00.000-07:00","lastPostTime":"2024-03-25T15:18:00.000-07:00"},"ModerationData:moderation_data:85159":{"__typename":"ModerationData","id":"moderation_data:85159","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:85159":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:85159","relatedMessage":{"__ref":"ForumTopicMessage:message:85159"}},"CachedAsset:text:en_US-components/community/Navbar-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1738074982000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1738074982000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1738074982000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1738074982000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1738074982000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageDeepLink-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1738074982000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1738074982000","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1738074982000","value":{"alt":"Powered By Khoros"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1738074982000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1738074982000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1738074982000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1738074982000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1738074982000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1738074982000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1738074982000","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1738074982000","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},"ModerationData:moderation_data:18879":{"__typename":"ModerationData","id":"moderation_data:18879","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ModerationData:moderation_data:18877":{"__typename":"ModerationData","id":"moderation_data:18877","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"User:user:12614":{"__typename":"User","id":"user:12614","login":"MarkShnier__You","uid":12614,"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":8569,"biography":null,"topicsCount":52,"kudosReceivedCount":1051,"kudosGivenCount":181,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-23T06:11:10.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":220,"entityType":"USER","eventPath":"community:kqufx49752/user:12614"},"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"},"ForumReplyMessage:message:18877":{"__typename":"ForumReplyMessage","id":"message:18877","revisionNum":1,"uid":18877,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:18876"},"subject":"Re: Formula URL to Add Records with a Reference Proxy Field","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:18877"},"body":"
The reference field on the right side of the relationship needs to be populated by the API with the value of the key field of the parent record. Then all the lookup fields will populate.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ ","body@stringLength":"350","rawBody":"
The reference field on the right side of the relationship needs to be populated by the API with the value of the key field of the parent record. Then all the lookup fields will populate.
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ ","author":{"__ref":"User:user:12614"},"isEscalated":null,"postTime":"2023-02-17T04:28:00.000-08:00","solution":false,"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"kudosSumWeight":0,"repliesCount":26,"images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:18877_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":72},"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:18879_1":{"__typename":"Revision","id":"revision:18879_1","lastEditTime":"2023-02-18T06:12:00.000-08:00"},"QueryVariables:ReplyList:message:18879:1":{"__typename":"QueryVariables","id":"ReplyList:message:18879:1","value":{"id":"message:18879","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1738074982000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1738074982000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1738074982000","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-1738074982000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1738074982000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false},"Revision:revision:18877_1":{"__typename":"Revision","id":"revision:18877_1","lastEditTime":"2023-02-17T04:28:00.000-08:00"},"ModerationData:moderation_data:18880":{"__typename":"ModerationData","id":"moderation_data:18880","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:18880":{"__typename":"ForumReplyMessage","uid":18880,"id":"message:18880","revisionNum":1,"author":{"__ref":"User:user:6889"},"readOnly":false,"repliesCount":23,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:18879"},"conversation":{"__ref":"Conversation:conversation:18876"},"subject":"Re: Formula URL to Add Records with a Reference Proxy Field","moderationData":{"__ref":"ModerationData:moderation_data:18880"},"body":"
Immediately after I posted this, I thought about what the problem likely is. Dynamic form rules. I had an issue with the lookup working due to case sensitivity so, I have a hidden field that picks up the LCase of the email address. The lookup is done based on that field, which can't be edited. Dynamic form rules are in driven by the email address and the hidden email address fields for setting what sections are visible as well as setting couple of checkboxes. Will the URL not work because of the Dynamic form rules? Is there another API call I can make that will trigger the form rules after the record is added? I am looking to avoid having the record shown while being edited, if possible.
------------------------------ James Carr ------------------------------ ","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2023-02-18T06:21:00.000-08:00","lastPublishTime":"2023-02-18T06:21:00.000-08:00","metrics":{"__typename":"MessageMetrics","views":51},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:18876/message:18880","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:18881"}}]},"editFrozen":false,"body@stringLength":"815","rawBody":"
Immediately after I posted this, I thought about what the problem likely is. Dynamic form rules. I had an issue with the lookup working due to case sensitivity so, I have a hidden field that picks up the LCase of the email address. The lookup is done based on that field, which can't be edited. Dynamic form rules are in driven by the email address and the hidden email address fields for setting what sections are visible as well as setting couple of checkboxes. Will the URL not work because of the Dynamic form rules? Is there another API call I can make that will trigger the form rules after the record is added? I am looking to avoid having the record shown while being edited, if possible.
------------------------------ James Carr ------------------------------ ","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:18880_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":[]}}},"customFields":[]},"ModerationData:moderation_data:18881":{"__typename":"ModerationData","id":"moderation_data:18881","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:18881":{"__typename":"ForumReplyMessage","uid":18881,"id":"message:18881","revisionNum":1,"author":{"__ref":"User:user:12614"},"readOnly":false,"repliesCount":22,"depth":4,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:18880"},"conversation":{"__ref":"Conversation:conversation:18876"},"subject":"Re: Formula URL to Add Records with a Reference Proxy Field","moderationData":{"__ref":"ModerationData:moderation_data:18881"},"body":"
Sorry, but I'm not understanding the question.
\n
I gather you're using an API to actually create a record so you were using the API of API_AddRecord
\n\n
When you view that record the form rules would all activate in terms of show/hide, if you're expecting any formulas to edit the record then they will not fire until the form is put into edit mode. If you wanted any other fields to be populated to replicate what the form rules do then that would have to be built into the API_AddRecord. You can populate an unlimited # of fields with the one API. But, like I said I really am not understanding your question, this response may not help you!
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ ","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"223","kudosSumWeight":0,"postTime":"2023-02-19T14:49:00.000-08:00","lastPublishTime":"2023-02-19T14:49:00.000-08:00","metrics":{"__typename":"MessageMetrics","views":9},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:18876/message:18881","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":true,"endCursor":"MjUuMnwyLjF8b3wxfDE0OjAsMzk6MXwx","hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuMnwyLjF8b3wxfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:18882"}}]},"editFrozen":false,"body@stringLength":"859","rawBody":"
Sorry, but I'm not understanding the question.
\n
I gather you're using an API to actually create a record so you were using the API of API_AddRecord
\n\n
When you view that record the form rules would all activate in terms of show/hide, if you're expecting any formulas to edit the record then they will not fire until the form is put into edit mode. If you wanted any other fields to be populated to replicate what the form rules do then that would have to be built into the API_AddRecord. You can populate an unlimited # of fields with the one API. But, like I said I really am not understanding your question, this response may not help you!
------------------------------ Mark Shnier (Your Quickbase Coach) mark.shnier@gmail.com ------------------------------ ","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:18881_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":[]}}},"customFields":[]},"ModerationData:moderation_data:18882":{"__typename":"ModerationData","id":"moderation_data:18882","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:18882":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:6889"},"id":"message:18882","revisionNum":1,"uid":18882,"depth":5,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:18881"},"conversation":{"__ref":"Conversation:conversation:18876"},"subject":"Re: Formula URL to Add Records with a Reference Proxy Field","moderationData":{"__ref":"ModerationData:moderation_data:18882"},"body":"
Sorry. So, you ended up answering my question, believe it or not. Lol. Unfortunately, I misunderstood my situation so, let me try again. I have lookup fields in the form. Some of them are for one related table and the rest for a 2nd related table. When I make the API_AddRecord call, only the lookup fields for one table is being populated. The other fields are blank. I do have the key for both related tables being populated with the API call so, I don't understand why the fields for one table are coming up blank. When I go into edit mode, they immediate populate so, I know the correct key is being added with the API call. Any input regarding that would be greatly appreciated.
\n
James
------------------------------ James Carr ------------------------------ ","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"213","kudosSumWeight":0,"repliesCount":1,"postTime":"2023-02-19T16:08:00.000-08:00","lastPublishTime":"2023-02-19T16:08:00.000-08:00","metrics":{"__typename":"MessageMetrics","views":6},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:18876/message:18882","readOnly":false,"editFrozen":false,"body@stringLength":"815","rawBody":"
Sorry. So, you ended up answering my question, believe it or not. Lol. Unfortunately, I misunderstood my situation so, let me try again. I have lookup fields in the form. Some of them are for one related table and the rest for a 2nd related table. When I make the API_AddRecord call, only the lookup fields for one table is being populated. The other fields are blank. I do have the key for both related tables being populated with the API call so, I don't understand why the fields for one table are coming up blank. When I go into edit mode, they immediate populate so, I know the correct key is being added with the API call. Any input regarding that would be greatly appreciated.
\n
James
------------------------------ James Carr ------------------------------ ","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:18882_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":[]}}},"customFields":[]},"Revision:revision:18881_1":{"__typename":"Revision","id":"revision:18881_1","lastEditTime":"2023-02-19T14:49:00.000-08:00"},"Revision:revision:18882_1":{"__typename":"Revision","id":"revision:18882_1","lastEditTime":"2023-02-19T16:08:00.000-08:00"},"Revision:revision:18880_1":{"__typename":"Revision","id":"revision:18880_1","lastEditTime":"2023-02-18T06:21:00.000-08:00"}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"quickbase-discussions","messageSubject":"formula-url-to-add-records-with-a-reference-proxy-field","messageId":"18876","replyId":"18879"},"buildId":"k2ra3WbQxEm0ebgjo41Oz","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"],"appGip":true,"scriptLoader":[]}
Qrew Legend
