var Text edit=URLRoot() & \"db/\" & Dbid() &
\"?act=API_EditRecord&rid=\"&$RID
&\"&_fid_20=\"&URLEncode(\"Yes\");
var text reDirect =
URLRoot() & Dbid()?act=er&rid=\";
var Text URL=$Edit
& \"&rdr=\" & URLEncode($reDirect)& $RID;
\"<a class='SaveBeforeNavigating' data-replaceRid=true style=\\\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:200px; text-align: center; text-shadow: none; border: 2px solid #0863f5; font-size: 16px \\\"href='\"
& $URL
& \"'>Issue Announcement</a>\"
","body@stripHtml({\"removeProcessingText\":true,\"removeSpoilerMarkup\":true,\"removeTocMarkup\":true,\"truncateLength\":200})@stringLength":"211","postTime":"2024-04-16T07:54:55.184-07:00","lastPublishTime":"2024-04-16T07:54:55.184-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"solution":true,"metrics":{"__typename":"MessageMetrics","views":174},"placeholder":false,"originalMessageForPlaceholder":null,"videos":{"__typename":"VideoConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"isEscalated":null,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:86444/message:86490","customFields":[]},"ModerationData:moderation_data:86448":{"__typename":"ModerationData","id":"moderation_data:86448","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:86448_1":{"__typename":"Revision","id":"revision:86448_1","lastEditTime":"2024-04-11T16:36:51.342-07:00"},"QueryVariables:ReplyList:message:86448:1":{"__typename":"QueryVariables","id":"ReplyList:message:86448:1","value":{"id":"message:86448","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}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1744133823000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1744133823000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1744133823000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1744133823000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1744133823000","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-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1744133823000","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-components/messages/MessageView/MessageViewInline-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1744133823000","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-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1744133823000","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1744133823000","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},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":15,"name":"Qrew Elite","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:28257":{"__typename":"User","id":"user:28257","uid":28257,"login":"MikeTamoush","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-11-19T16:15:09.000-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:14"},"entityType":"USER","eventPath":"community:kqufx49752/user:28257"},"ModerationData:moderation_data:86475":{"__typename":"ModerationData","id":"moderation_data:86475","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:86475":{"__typename":"ForumReplyMessage","uid":86475,"id":"message:86475","revisionNum":1,"author":{"__ref":"User:user:28257"},"readOnly":false,"repliesCount":1,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:86448"},"conversation":{"__ref":"Conversation:conversation:86444"},"subject":"Re: Button: save the new record and edit the new record","moderationData":{"__ref":"ModerationData:moderation_data:86475"},"body":"Can you post your entire code? The %%rid%% cannot be URLEncoded, so if somewhere in your code that redirect is URL encoded, that would cause it to fail. There are work arounds, but we would need to see the entire code.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":1,"postTime":"2024-04-15T09:43:38.079-07:00","lastPublishTime":"2024-04-15T09:43:38.079-07:00","metrics":{"__typename":"MessageMetrics","views":131},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:86444/message:86475","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuM3wyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:86488"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:86488":{"__typename":"ModerationData","id":"moderation_data:86488","status":"UNMODERATED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:86488":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:40909"},"id":"message:86488","revisionNum":1,"uid":86488,"depth":3,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"parent":{"__ref":"ForumReplyMessage:message:86475"},"conversation":{"__ref":"Conversation:conversation:86444"},"subject":"Re: Button: save the new record and edit the new record","moderationData":{"__ref":"ModerationData:moderation_data:86488"},"body":"Hi Mark, I think you caught the point. The %%rid%% is used twice in the formula. 1st time is working, the 2nd time is URLEncoded in the redirect and it fails. Can't wait to see how to make it working. Thanks again.
Here is the code:
var text RID = If([Record ID#] > 0, ToText([Record ID#]), \"%%RID%%\");
var Text edit=URLRoot() & \"db/\" & Dbid() &
\"?act=API_EditRecord&rid=\"&$RID
&\"&_fid_20=\"&URLEncode(\"Yes\");
var text reDirect =
URLRoot() & Dbid()?act=er&rid=\"&$RID;
var Text URL=$Edit
& \"&rdr=\" & URLEncode($reDirect);
\"<a class='SaveBeforeNavigating' data-replaceRid=true style=\\\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:200px; text-align: center; text-shadow: none; border: 2px solid #0863f5; font-size: 16px \\\"href='\"
& $URL
& \"'>Issue Announcement</a>\"
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"223","kudosSumWeight":0,"repliesCount":0,"postTime":"2024-04-16T07:26:00.679-07:00","lastPublishTime":"2024-04-16T07:26:00.679-07:00","metrics":{"__typename":"MessageMetrics","views":54},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:86444/message:86488","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1744133823000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1744133823000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"quickbase-discussions","messageSubject":"button-save-the-new-record-and-edit-the-new-record","messageId":"86444","replyId":"86448"},"buildId":"qjItjPUjFcK4Aq3-X33tk","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"quickbase","openTelemetryServiceVersion":"25.3.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/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/community/FooterWidgetHelpLink/FooterWidgetHelpLink.tsx","./components/community/KhorosLogo/KhorosLogo.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.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":[]}