Forum Discussion

BrianCafferelli's avatar
BrianCafferelli
Quickbase Staff
6 years ago

Generate template records with Pipelines

Generate template records with Pipelines


One of the main ways Quickbase helps companies perfect their unique processes is by automating routine work. This saves time, improves your employees’ morale, and reduces risk for your business. A common automation pattern we see from our customers is generating a set of template child records when a new parent record is created. If you’ve been building apps in Quickbase for a while, you may know this as the “Copy Master and Details Records” technique. You can generate template records easily using Pipelines.
Pipelines is an exciting technology that makes it easier than ever for you to automate your workflow, even across your ecosystem of software tools. Read on to learn how you can use Pipelines to generate a set of template child records.

Table of Contents

• Example use case: managing marketing campaigns
• Creating a template table
• Overview of example pipeline
• Creating a new pipeline
• Step A: Setting up the trigger
• Setting up the email condition
• Step B: Searching the template table for email activities
• Step C: Generating the activities for email campaigns
• Setting up the social media condition
• Step D: Searching the template table for social media activities
• Step E: Generating the activities for social media campaigns

Example use case: managing marketing campaigns

Automatically generating a set of template child records isn’t limited to specific industries or use cases. However, for the sake of simplicity we’ll focus on a specific example to walk through the process. Imagine that your company manages marketing campaigns in Quickbase. There are many types of campaigns, and each campaign uses a different marketing channel. For example, let’s say the company often uses email and social media for its campaigns. Each type of campaign has a standard list of activities. Rather than create the same types of activities over and over, you can use Pipelines to automatically create the activities.

Creating a template table

Next, you need to decide how to manage your list of standard activities. The most scalable way of doing this is to have one table for your live activity data and a separate table for your template activities. Note that the Activity Templates table doesn’t need to be related to your other tables.


TIP: If you didn’t already have an Activity Templates table in your app, open the Activities table and click More > Copy
table. You can copy the table without data and name the new table “Activity Templates”.

You may want to hide the templates table from your users, since they won’t need to interact with it directly. (To do this, go to the Activity Templates table > click the gear > click Advanced Settings > scroll to the bottom and uncheck “Show in the table bar”).

Finally, the Activity Templates table needs a field to mark which channel each activity is for. In this example, a Text – Multiple Choice field called Channel keeps track of that.

Overview of example pipeline

Before creating the pipeline, let’s take a look at what the finished product will look like. The pipeline will have the following steps:

- Step A: Record Created – triggers the pipeline when a new campaign is created
- 1st Condition - If the new campaign record has Channel = Email, then
-- Step B: Search Records – search the Activity Templates for email activities, and for each matching template, then
----Step C: Create Record – add an activity record using data from the activity template
- 2nd Condition – If the new campaign record has Channel = Social Media, then
--Step D: Search Records - search the Activity Templates for social media activities, and for each matching template, then
----Step E: Create Record – add an activity record using data from the activity template



Creating a new pipeline

Since pipelines can work across Quickbase apps, you access pipelines from the app bar.



Before you start building the pipeline, keep in mind that your example company uses email and social media for your marketing campaigns. You have a standard list of activities for each of those two types of campaigns. Here’s how to get started building your pipeline:

1. On the My Pipelines page, click Create pipeline.
2. In the pop-up window that appears, name the pipeline. For this example, call it “Marketing Campaign Manager: Create campaign activities”. All pipelines you create appear in a single list, across all applications you manage. Including the name of the Quickbase app in the pipeline name helps you to keep things organized.
3. It’s a best practice to write a few sentences for the description to explain what actions the pipeline will be taking.
4. Click Create pipeline.
5. Click the Quickbase channel in the list of channels.
6. Connect to your Quickbase account if you have not already done so (click here to learn how).
Next you need to create the trigger step, to determine when the pipeline will run.

Step A: Setting up the trigger

The goal of this step is to create the right set of activities when a new marketing campaign is added.



Here’s how to set it up:
1. Click the Records category.
2. Click the Record Created trigger and drag it to the dotted box on the canvas.
2. Under Table, select the Campaigns table.
3. Under Fields for Subsequent Steps, select Channel.

Setting up the email condition

Next, we need to add a condition for email campaigns.



Here’s how to set it up:
1. Click Insert a condition below Step A. A few new branches appear - for If, Then, and Else.
2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Email.

Step B: Searching the template table for email activities

The goal of this step is to find the list of standard activities needed for email marketing campaigns.



Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, below the Then box.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Email.

Step C: Generating the activities for email campaigns


The goal of this step is generate the activities for email campaigns.

Here's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step C.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.



7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.



8. Drag Record ID from the list to the Related Campaign box on the left. This will relate the new activity records to the campaign record.

Setting up the social media condition

This pipeline will handle both email campaigns and social media campaigns. So the next step is to create the condition that the campaign which triggered this pipeline is a social media campaign.



Here’s how to set it up:

1. Outside of the Else branch, click Insert a condition. A few new branches appear - for If, Then, and Else.

TIP: There are a few different places you can insert conditions. For this type of pipeline, your condition steps should be one beneath the other, as you see below. The conditions should not be indented as part of a Then or Else branch.



2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Social Media.

Step D: Searching the template table for social media activities

The goal of this step is to find the list of standard activities needed for social media marketing campaigns.



Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, under the Then box of the condition we just created above.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Social Media.

TIP: To easily navigate around the Pipeline Builder, use the toggle in the top-right of a step to expand or collapse it.



Step E: Generating the activities for social media campaigns

The goal of this step is to generate the activities for social media campaigns.

Here's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step E.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.
7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.
8. Drag Record ID from the list to the Related Campaign box on the left.
No RepliesBe the first to reply
"}},"componentScriptGroups({\"componentId\":\"custom.widget.Custom_Footer_Scripts\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageView/MessageViewInline\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/Pager/PagerLoadMore\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"components/customComponent/CustomComponent\"]})":[{"__ref":"CachedAsset:text:en_US-components/customComponent/CustomComponent-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000"}],"cachedText({\"lastModified\":\"1742314867000\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/nodes/NodeIcon\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1742314867000"}]},"CachedAsset:pages-1742462094414":{"__typename":"CachedAsset","id":"pages-1742462094414","value":[{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"HealthCheckPage","type":"COMMUNITY","urlPath":"/health","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1742462094414,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Anonymous","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"true","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MM-dd-yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":null,"possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420","mimeType":"image/png"},"Category:category:connect":{"__typename":"Category","id":"category:connect","entityType":"CATEGORY","displayId":"connect","nodeType":"category","depth":1,"title":"Connect","shortTitle":"Connect","parent":{"__ref":"Category:category:top"}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Forum:board:quickbase-discussions":{"__typename":"Forum","id":"board:quickbase-discussions","entityType":"FORUM","displayId":"quickbase-discussions","nodeType":"board","depth":2,"conversationStyle":"FORUM","title":"Quickbase Discussions","description":"A forum for Qrew members of all levels, where questions about Quickbase can be asked and answered.","avatar":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bi02NC04b1IweFI?image-coordinates=89%2C0%2C510%2C420\"}"},"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:connect"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:kqufx49752"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:connect"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":true,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}},"canReadNode":{"__typename":"PolicyResult","failureReason":null}},"shortTitle":"Quickbase Discussions","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"LIKES","repliesFormat":"threaded"},"forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/","tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"FREEFORM_AND_PRESET"},"Rank:rank:5":{"__typename":"Rank","id":"rank:5","position":6,"name":"Quickbase Staff","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:20367":{"__typename":"User","id":"user:20367","uid":20367,"login":"BrianCafferelli","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/images/dS0yMDM2Ny1rN3c3dWg?image-coordinates=0%2C0%2C512%2C512"},"rank":{"__ref":"Rank:rank:5"},"email":"","messagesCount":183,"biography":null,"topicsCount":87,"kudosReceivedCount":61,"kudosGivenCount":4,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T14:18:10.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":1},"ForumTopicMessage:message:83869":{"__typename":"ForumTopicMessage","uid":83869,"subject":"Generate template records with Pipelines","id":"message:83869","revisionNum":1,"repliesCount":0,"author":{"__ref":"User:user:20367"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:83869"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:83869"},"body":"

Generate template records with Pipelines

\n
One of the main ways Quickbase helps companies perfect their unique processes is by automating routine work. This saves time, improves your employees’ morale, and reduces risk for your business. A common automation pattern we see from our customers is generating a set of template child records when a new parent record is created. If you’ve been building apps in Quickbase for a while, you may know this as the “Copy Master and Details Records” technique. You can generate template records easily using Pipelines.
Pipelines is an exciting technology that makes it easier than ever for you to automate your workflow, even across your ecosystem of software tools. Read on to learn how you can use Pipelines to generate a set of template child records.

\n

Table of Contents

\n• Example use case: managing marketing campaigns
• Creating a template table
• Overview of example pipeline
• Creating a new pipeline
• Step A: Setting up the trigger
• Setting up the email condition
• Step B: Searching the template table for email activities
• Step C: Generating the activities for email campaigns
• Setting up the social media condition
• Step D: Searching the template table for social media activities
• Step E: Generating the activities for social media campaigns

\n

Example use case: managing marketing campaigns

\nAutomatically generating a set of template child records isn’t limited to specific industries or use cases. However, for the sake of simplicity we’ll focus on a specific example to walk through the process. Imagine that your company manages marketing campaigns in Quickbase. There are many types of campaigns, and each campaign uses a different marketing channel. For example, let’s say the company often uses email and social media for its campaigns. Each type of campaign has a standard list of activities. Rather than create the same types of activities over and over, you can use Pipelines to automatically create the activities.

\n

Creating a template table

\nNext, you need to decide how to manage your list of standard activities. The most scalable way of doing this is to have one table for your live activity data and a separate table for your template activities. Note that the Activity Templates table doesn’t need to be related to your other tables.\n
\n

TIP: If you didn’t already have an Activity Templates table in your app, open the Activities table and click More > Copy
table. You can copy the table without data and name the new table “Activity Templates”.

You may want to hide the templates table from your users, since they won’t need to interact with it directly. (To do this, go to the Activity Templates table > click the gear > click Advanced Settings > scroll to the bottom and uncheck “Show in the table bar”).

Finally, the Activity Templates table needs a field to mark which channel each activity is for. In this example, a Text – Multiple Choice field called Channel keeps track of that.

\n

Overview of example pipeline

\nBefore creating the pipeline, let’s take a look at what the finished product will look like. The pipeline will have the following steps:

- Step A: Record Created – triggers the pipeline when a new campaign is created
- 1st Condition - If the new campaign record has Channel = Email, then
-- Step B: Search Records – search the Activity Templates for email activities, and for each matching template, then
----Step C: Create Record – add an activity record using data from the activity template
- 2nd Condition – If the new campaign record has Channel = Social Media, then
--Step D: Search Records - search the Activity Templates for social media activities, and for each matching template, then
----Step E: Create Record – add an activity record using data from the activity template
\n
\n



Creating a new pipeline

\nSince pipelines can work across Quickbase apps, you access pipelines from the app bar.

\n
\n

Before you start building the pipeline, keep in mind that your example company uses email and social media for your marketing campaigns. You have a standard list of activities for each of those two types of campaigns. Here’s how to get started building your pipeline:

1. On the My Pipelines page, click Create pipeline.
2. In the pop-up window that appears, name the pipeline. For this example, call it “Marketing Campaign Manager: Create campaign activities”. All pipelines you create appear in a single list, across all applications you manage. Including the name of the Quickbase app in the pipeline name helps you to keep things organized.
3. It’s a best practice to write a few sentences for the description to explain what actions the pipeline will be taking.
4. Click Create pipeline.
5. Click the Quickbase channel in the list of channels.
6. Connect to your Quickbase account if you have not already done so (click here to learn how).
Next you need to create the trigger step, to determine when the pipeline will run.

\n

Step A: Setting up the trigger

\nThe goal of this step is to create the right set of activities when a new marketing campaign is added.

\n
\n

Here’s how to set it up:
1. Click the Records category.
2. Click the Record Created trigger and drag it to the dotted box on the canvas.
2. Under Table, select the Campaigns table.
3. Under Fields for Subsequent Steps, select Channel.

\n

Setting up the email condition

\nNext, we need to add a condition for email campaigns.

\n
\n

Here’s how to set it up:
1. Click Insert a condition below Step A. A few new branches appear - for If, Then, and Else.
2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Email.

\n

Step B: Searching the template table for email activities

\nThe goal of this step is to find the list of standard activities needed for email marketing campaigns.

\n
\n
\n
\n

Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, below the Then box.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Email.

\n

Step C: Generating the activities for email campaigns

\n
The goal of this step is generate the activities for email campaigns.\n
\n

\nHere's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step C.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.

\n
\n

7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.

\n
\n

8. Drag Record ID from the list to the Related Campaign box on the left. This will relate the new activity records to the campaign record.

\n

Setting up the social media condition

\nThis pipeline will handle both email campaigns and social media campaigns. So the next step is to create the condition that the campaign which triggered this pipeline is a social media campaign.

\n
\n

Here’s how to set it up:

1. Outside of the Else branch, click Insert a condition. A few new branches appear - for If, Then, and Else.

TIP: There are a few different places you can insert conditions. For this type of pipeline, your condition steps should be one beneath the other, as you see below. The conditions should not be indented as part of a Then or Else branch.

\n
\n

2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Social Media.

\n

Step D: Searching the template table for social media activities

\nThe goal of this step is to find the list of standard activities needed for social media marketing campaigns.

\n
\n

Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, under the Then box of the condition we just created above.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Social Media.

TIP: To easily navigate around the Pipeline Builder, use the toggle in the top-right of a step to expand or collapse it.

\n
\n

\n

Step E: Generating the activities for social media campaigns

\nThe goal of this step is to generate the activities for social media campaigns.
\n
\n
Here's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step E.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.
7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.
8. Drag Record ID from the list to the Related Campaign box on the left.","body@stringLength":"17424","rawBody":"

Generate template records with Pipelines

\n
One of the main ways Quickbase helps companies perfect their unique processes is by automating routine work. This saves time, improves your employees’ morale, and reduces risk for your business. A common automation pattern we see from our customers is generating a set of template child records when a new parent record is created. If you’ve been building apps in Quickbase for a while, you may know this as the “Copy Master and Details Records” technique. You can generate template records easily using Pipelines.
Pipelines is an exciting technology that makes it easier than ever for you to automate your workflow, even across your ecosystem of software tools. Read on to learn how you can use Pipelines to generate a set of template child records.

\n

Table of Contents

\n• Example use case: managing marketing campaigns
• Creating a template table
• Overview of example pipeline
• Creating a new pipeline
• Step A: Setting up the trigger
• Setting up the email condition
• Step B: Searching the template table for email activities
• Step C: Generating the activities for email campaigns
• Setting up the social media condition
• Step D: Searching the template table for social media activities
• Step E: Generating the activities for social media campaigns

\n

Example use case: managing marketing campaigns

\nAutomatically generating a set of template child records isn’t limited to specific industries or use cases. However, for the sake of simplicity we’ll focus on a specific example to walk through the process. Imagine that your company manages marketing campaigns in Quickbase. There are many types of campaigns, and each campaign uses a different marketing channel. For example, let’s say the company often uses email and social media for its campaigns. Each type of campaign has a standard list of activities. Rather than create the same types of activities over and over, you can use Pipelines to automatically create the activities.

\n

Creating a template table

\nNext, you need to decide how to manage your list of standard activities. The most scalable way of doing this is to have one table for your live activity data and a separate table for your template activities. Note that the Activity Templates table doesn’t need to be related to your other tables.\n
\n

TIP: If you didn’t already have an Activity Templates table in your app, open the Activities table and click More > Copy
table. You can copy the table without data and name the new table “Activity Templates”.

You may want to hide the templates table from your users, since they won’t need to interact with it directly. (To do this, go to the Activity Templates table > click the gear > click Advanced Settings > scroll to the bottom and uncheck “Show in the table bar”).

Finally, the Activity Templates table needs a field to mark which channel each activity is for. In this example, a Text – Multiple Choice field called Channel keeps track of that.

\n

Overview of example pipeline

\nBefore creating the pipeline, let’s take a look at what the finished product will look like. The pipeline will have the following steps:

- Step A: Record Created – triggers the pipeline when a new campaign is created
- 1st Condition - If the new campaign record has Channel = Email, then
-- Step B: Search Records – search the Activity Templates for email activities, and for each matching template, then
----Step C: Create Record – add an activity record using data from the activity template
- 2nd Condition – If the new campaign record has Channel = Social Media, then
--Step D: Search Records - search the Activity Templates for social media activities, and for each matching template, then
----Step E: Create Record – add an activity record using data from the activity template
\n
\n



Creating a new pipeline

\nSince pipelines can work across Quickbase apps, you access pipelines from the app bar.

\n
\n

Before you start building the pipeline, keep in mind that your example company uses email and social media for your marketing campaigns. You have a standard list of activities for each of those two types of campaigns. Here’s how to get started building your pipeline:

1. On the My Pipelines page, click Create pipeline.
2. In the pop-up window that appears, name the pipeline. For this example, call it “Marketing Campaign Manager: Create campaign activities”. All pipelines you create appear in a single list, across all applications you manage. Including the name of the Quickbase app in the pipeline name helps you to keep things organized.
3. It’s a best practice to write a few sentences for the description to explain what actions the pipeline will be taking.
4. Click Create pipeline.
5. Click the Quickbase channel in the list of channels.
6. Connect to your Quickbase account if you have not already done so (click here to learn how).
Next you need to create the trigger step, to determine when the pipeline will run.

\n

Step A: Setting up the trigger

\nThe goal of this step is to create the right set of activities when a new marketing campaign is added.

\n
\n

Here’s how to set it up:
1. Click the Records category.
2. Click the Record Created trigger and drag it to the dotted box on the canvas.
2. Under Table, select the Campaigns table.
3. Under Fields for Subsequent Steps, select Channel.

\n

Setting up the email condition

\nNext, we need to add a condition for email campaigns.

\n
\n

Here’s how to set it up:
1. Click Insert a condition below Step A. A few new branches appear - for If, Then, and Else.
2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Email.

\n

Step B: Searching the template table for email activities

\nThe goal of this step is to find the list of standard activities needed for email marketing campaigns.

\n
\n
\n
\n

Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, below the Then box.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Email.

\n

Step C: Generating the activities for email campaigns

\n
The goal of this step is generate the activities for email campaigns.\n
\n

\nHere's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step C.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.

\n
\n

7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.

\n
\n

8. Drag Record ID from the list to the Related Campaign box on the left. This will relate the new activity records to the campaign record.

\n

Setting up the social media condition

\nThis pipeline will handle both email campaigns and social media campaigns. So the next step is to create the condition that the campaign which triggered this pipeline is a social media campaign.

\n
\n

Here’s how to set it up:

1. Outside of the Else branch, click Insert a condition. A few new branches appear - for If, Then, and Else.

TIP: There are a few different places you can insert conditions. For this type of pipeline, your condition steps should be one beneath the other, as you see below. The conditions should not be indented as part of a Then or Else branch.

\n
\n

2. Under If, click Add Conditions.
3. Select Channel.
4. In the dropdown next to Channel, select is.
5. In the box below, select Social Media.

\n

Step D: Searching the template table for social media activities

\nThe goal of this step is to find the list of standard activities needed for social media marketing campaigns.

\n
\n

Here’s how to set it up:
1. Click and drag the Search Records action from the Quickbase channel, under the Then box of the condition we just created above.
2. Click in the Account box and select the same user token used in the trigger step. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activity Templates”.
4. Under Fields, select Channel, Activity Name, and Assigned To.
5. Click Add conditions.
6. Select Channel.
7. Next to Channel, select equals from the dropdown.
8. In the box below, enter Social Media.

TIP: To easily navigate around the Pipeline Builder, use the toggle in the top-right of a step to expand or collapse it.

\n
\n

\n

Step E: Generating the activities for social media campaigns

\nThe goal of this step is to generate the activities for social media campaigns.
\n
\n
Here's how to set it up:
1. Under the Do box, drag the Create Record step onto the canvas as Step E.
2. Click in the Account box and select the same user token used above. In this example, that would be “Marketing campaign manager token”.
3. Click in the Table box and select “Activities”.
4. Select the fields to specify values: Activity Name, Assigned To, and Related Campaign.
5. In the field list in the middle of the page, find Email under Assigned To and drag it into the Assigned To box on the left. As you would do when importing a spreadsheet into a User-type field, in pipelines you also use email addresses to populate User fields.
6. Drag Activity Name from the list in the middle to the box on the left.
7. In the field list in the middle of the page, click A to switch to a list of fields from the campaign record that triggered this pipeline.
8. Drag Record ID from the list to the Related Campaign box on the left.","kudosSumWeight":1,"postTime":"2020-02-21T06:23:43.000-08:00","images":{"__typename":"AssociatedImageConnection","edges":[{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDE","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MWlFRkJGMkNBQkUxNkUyMjkw?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDI","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MmlBNDY2RTBCMkM2MjU1NDgw?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDM","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM3OGk2MDZDM0RGNEFEQTU3MDU4?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDQ","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MGlDMTY1MTE1RDFENUMxNTMy?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDU","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NWlCODY3NDdDNTU3QjY1RDE2?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDY","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4M2kwMzkzRTRCNkRDNDBCNDdC?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDc","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NmkzMzE3RDk1Rjg3NzY0MjNC?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDg","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MWkxNjEwNkI3RTIyMTlGMjk0?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDk","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4N2lBMEIzOUQ2RUI2REM1MTQ1?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDEw","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4OGk5ODMyQ0NFMkU2RTVEOUI1?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDEx","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MGlFQzQ1Rjg3REVDNjAxQThC?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDEy","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5Mmk0MkM1NTJDN0EzQjE3QjIz?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDEz","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5M2kwODdCNTZDOTYwN0NDODc2?revision=1\"}"}},{"__typename":"AssociatedImageEdge","cursor":"MjUuMnwyLjF8b3wyNXxfTlZffDE0","node":{"__ref":"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5NGkzN0RDNDYwNUYyQ0RDOTBD?revision=1\"}"}}],"totalCount":14,"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":7,"currentRevision":{"__ref":"Revision:revision:83869_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":172},"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,"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:83869":{"__typename":"Conversation","id":"conversation:83869","solved":false,"topic":{"__ref":"ForumTopicMessage:message:83869"},"lastPostingActivityTime":"2020-02-21T06:23:43.000-08:00","lastPostTime":"2020-02-21T06:23:43.000-08:00","unreadReplyCount":0,"isSubscribed":false},"ModerationData:moderation_data:83869":{"__typename":"ModerationData","id":"moderation_data:83869","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MWlFRkJGMkNBQkUxNkUyMjkw?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MWlFRkJGMkNBQkUxNkUyMjkw?revision=1","title":"16426.png","associationType":"BODY","width":745,"height":301,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MmlBNDY2RTBCMkM2MjU1NDgw?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MmlBNDY2RTBCMkM2MjU1NDgw?revision=1","title":"16427.png","associationType":"BODY","width":678,"height":2378,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM3OGk2MDZDM0RGNEFEQTU3MDU4?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM3OGk2MDZDM0RGNEFEQTU3MDU4?revision=1","title":"16428.png","associationType":"BODY","width":624,"height":100,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MGlDMTY1MTE1RDFENUMxNTMy?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4MGlDMTY1MTE1RDFENUMxNTMy?revision=1","title":"16429.png","associationType":"BODY","width":562,"height":550,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NWlCODY3NDdDNTU3QjY1RDE2?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NWlCODY3NDdDNTU3QjY1RDE2?revision=1","title":"16430.png","associationType":"BODY","width":567,"height":333,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4M2kwMzkzRTRCNkRDNDBCNDdC?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4M2kwMzkzRTRCNkRDNDBCNDdC?revision=1","title":"16431.png","associationType":"BODY","width":537,"height":783,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NmkzMzE3RDk1Rjg3NzY0MjNC?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4NmkzMzE3RDk1Rjg3NzY0MjNC?revision=1","title":"16432.png","associationType":"BODY","width":504,"height":943,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MWkxNjEwNkI3RTIyMTlGMjk0?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MWkxNjEwNkI3RTIyMTlGMjk0?revision=1","title":"16433.png","associationType":"BODY","width":1038,"height":756,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4N2lBMEIzOUQ2RUI2REM1MTQ1?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4N2lBMEIzOUQ2RUI2REM1MTQ1?revision=1","title":"16434.png","associationType":"BODY","width":485,"height":275,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4OGk5ODMyQ0NFMkU2RTVEOUI1?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM4OGk5ODMyQ0NFMkU2RTVEOUI1?revision=1","title":"16435.png","associationType":"BODY","width":566,"height":329,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MGlFQzQ1Rjg3REVDNjAxQThC?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5MGlFQzQ1Rjg3REVDNjAxQThC?revision=1","title":"16436.png","associationType":"BODY","width":703,"height":866,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5Mmk0MkM1NTJDN0EzQjE3QjIz?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5Mmk0MkM1NTJDN0EzQjE3QjIz?revision=1","title":"16437.png","associationType":"BODY","width":535,"height":849,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5M2kwODdCNTZDOTYwN0NDODc2?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5M2kwODdCNTZDOTYwN0NDODc2?revision=1","title":"16438.png","associationType":"BODY","width":1194,"height":371,"altText":null},"AssociatedImage:{\"url\":\"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5NGkzN0RDNDYwNUYyQ0RDOTBD?revision=1\"}":{"__typename":"AssociatedImage","url":"https://community.quickbase.com/t5/s/kqufx49752/images/bS04Mzg2OS0xNjM5NGkzN0RDNDYwNUYyQ0RDOTBD?revision=1","title":"16439.png","associationType":"BODY","width":505,"height":926,"altText":null},"Revision:revision:83869_1":{"__typename":"Revision","id":"revision:83869_1","lastEditTime":"2020-02-21T06:23:43.000-08:00"},"CachedAsset:theme:customTheme1-1742462093949":{"__typename":"CachedAsset","id":"theme:customTheme1-1742462093949","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"3px","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"Browser_Favicon_QB_Icon_512x512-1711046472639.png","imageLastModified":"1711046475044","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"quickbase-logo-300-1711548884441.png","imageLastModified":"1711548886217","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1320px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"3px","borderRadius":"3px","borderRadiusLg":"5px","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"400","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-body-color)","secondaryTextHoverColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-body-color-h), var(--lia-bs-body-color-s), calc(var(--lia-bs-body-color-l) * 0.9))","secondaryBgColor":"#2C9382","secondaryBgHoverColor":"hsl(170.10000000000002, 53.9%, 31.8%)","secondaryBgActiveColor":"hsl(170.10000000000002, 53.9%, 26.2%)","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-body-bg-h), var(--lia-bs-body-bg-s), var(--lia-bs-body-bg-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-body-bg-h), var(--lia-bs-body-bg-s), var(--lia-bs-body-bg-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0","md":"0","lg":"0","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-primary)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#1DD1E0","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#28A745","blogColor":"#2C9382","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#2C9382","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#F25E30","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#10503C","secondary":"#333333","bodyText":"#000000","bodyBg":"#FFFFFF","info":"#17A2B8","success":"#28A745","warning":"#FFC107","danger":"#B50000","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#2C9382","#F25E30","#1DD1E0","#F2B203","#FFABA2","#363432","#E6EEEB","#AAA9A8"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Tinos","fontStyle":"NORMAL","fontWeight":"700","h1FontSize":"56px","h2FontSize":"48px","h3FontSize":"36px","h4FontSize":"32px","h5FontSize":"24px","h6FontSize":"24px","lineHeight":"1.2","subHeaderFontSize":"14px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":null,"imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"10px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"10px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"AvenirNext3","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"20px","fontSizeXxs":"11px","fontSizeXs":"14px","fontSizeSm":"16px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"AvenirNext","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext-normal-400.woff2","AvenirNext-normal-500.woff2","AvenirNext-normal-600.woff2","AvenirNext-normal-400.woff2","AvenirNext-normal-500.woff2","AvenirNext-normal-700.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"AvenirNext2","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext2-normal-400.woff2","AvenirNext2-normal-500.woff2","AvenirNext2-normal-700.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"AvenirNext3","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"}],"assetNames":["AvenirNext3-normal-400.woff2","AvenirNext3-normal-500.woff2","AvenirNext3-normal-700.woff2"],"__typename":"CustomFont"},{"source":"GOOGLE","name":"Tinos","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"}],"assetNames":["Tinos-italic-400.woff2","Tinos-normal-400.woff2","Tinos-normal-700.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1742314867000","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1743605506557":{"__typename":"CachedAsset","id":"quilt:quickbase.prod:pages/forums/ForumMessagePage:board:quickbase-discussions-1743605506557","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","className":null,"props":{"hideIfEmpty":true,"enablePagination":true,"useTitle":true,"listVariant":{"type":"unstyled","props":{"listItemSpacing":"xxl"}},"instanceId":"1737477728716","pageSize":5,"style":"compact","pagerVariant":{"type":"loadMore"},"viewVariant":{"type":"inline","props":{"useRepliesCount":false,"useMedia":false,"useAuthorRank":false,"useNode":false,"useCompactSpacing":true,"boardIconSize":"24","useTimeToRead":false,"useSpoilerFreeBody":true,"useKudosCount":false,"useNodeLink":true,"useViewCount":false,"usePreviewMedia":true,"useBody":false,"timeStampType":"postTime","useTags":false,"clampSubjectLines":2,"useBoardIcon":true,"useMessageTimeLink":true,"useTextBody":true,"useSolvedBadge":false,"renderPostTimeBeforeAuthor":true,"useAvatar":false,"useAuthorLogin":true,"useVideoPreview":false}},"lazyLoad":false,"panelType":"standard"},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1742314867000","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1742314867000","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.TCmPzV.title":"Forum Discussion","section.XYHOid.title":"Forum Discussion"},"localOverride":false},"CachedAsset:quiltWrapper:quickbase.prod:Common:1742462005234":{"__typename":"CachedAsset","id":"quiltWrapper:quickbase.prod:Common:1742462005234","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":"header.png","backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"RIGHT_CENTER","lastModified":"1709066928000","__typename":"BackgroundImageProps"},"backgroundColor":"var(--lia-bs-body-bg)","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"migrated-link-0","params":{"boardId":"welcome-to-the-qrew","categoryId":"overview"},"routeName":"BlogBoardPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-2","params":{"boardId":"quickbase-discussions","categoryId":"top"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"categoryId":"qrew-networks-"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"migrated-link-4","url":"https://qrewchampions.influitive.com/forum/","target":"BLANK"}],"linkType":"INTERNAL","id":"migrated-link-1","params":{"categoryId":"qrew-networks-"},"routeName":"CategoryPage"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-6","url":"https://university.quickbase.com/","target":"BLANK"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"getting-started","categoryId":"getting-started"},"routeName":"ForumBoardPage"},{"linkType":"EXTERNAL","id":"migrated-link-8","url":"https://www.quickbase.com/customers","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-9","url":"https://www.quickbase.com/exchange","target":"BLANK"}],"linkType":"INTERNAL","id":"migrated-link-5","params":{"boardId":"quickbase-knowledge","categoryId":"learn"},"routeName":"TkbBoardPage"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-11","url":"https://helpv2.quickbase.com/hc/en-us","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-13","url":"https://helpv2.quickbase.com/hc/en-us/categories/4404742594708-Release-Notes","target":"BLANK"},{"linkType":"INTERNAL","id":"migrated-link-14","params":{"boardId":"quickbase-knowledge","categoryId":"learn"},"routeName":"TkbBoardPage"},{"linkType":"EXTERNAL","id":"migrated-link-12","url":"https://team.quickbase.com/qb/support/newcase?subject=New+Case","target":"BLANK"}],"linkType":"EXTERNAL","id":"migrated-link-10","url":"https://helpv2.quickbase.com/hc/en-us","target":"BLANK"},{"children":[{"linkType":"EXTERNAL","id":"migrated-link-16","url":"https://www.quickbase.com/events","target":"BLANK"},{"linkType":"EXTERNAL","id":"migrated-link-17","url":"https://www.quickbase.com/empower","target":"BLANK"}],"linkType":"EXTERNAL","id":"migrated-link-15","url":"https://www.quickbase.com/events","target":"BLANK"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-18","params":{"boardId":"the-qrew-blog-","categoryId":"blog"},"routeName":"BlogBoardPage"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-19","params":{"boardId":"job-board","categoryId":"connect"},"routeName":"ForumBoardPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","linkFontWeight":"700","controllerHighlightColor":"#F25E30","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"16px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"26px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"flex-start","linkColor":"var(--lia-bs-body-color)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-primary)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"0","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"transparent","visualEffects":{"showBottomBorder":false},"backgroundOpacity":50,"backgroundImageProps":{"backgroundSize":"COVER","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-body-color)"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"var(--lia-bs-white)","linkHighlightColor":"#363432","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"linkTextColor":"#363432"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer","props":{"customComponentId":"custom.widget.Custom_Footer"},"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer_Scripts","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1742314867000","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer-en-1742462107317":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer-en-1742462107317","value":{"component":{"id":"custom.widget.Custom_Footer","template":{"id":"Custom_Footer","markupLanguage":"HTML","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"TEXTHTML","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer_Scripts-en-1742462107317":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Scripts-en-1742462107317","value":{"component":{"id":"custom.widget.Custom_Footer_Scripts","template":{"id":"Custom_Footer_Scripts","markupLanguage":"HANDLEBARS","style":null,"texts":null,"defaults":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer_Scripts","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1742314867000","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1742314867000","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/RelatedContentWidget-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/RelatedContentWidget-1742314867000","value":{"title":"Related Content","emptyDescription":"No content to show"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1742314867000","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"localOverride":false},"Category:category:qrew-networks-":{"__typename":"Category","id":"category:qrew-networks-","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:job-board":{"__typename":"Forum","id":"board:job-board","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Tkb:board:quickbase-knowledge":{"__typename":"Tkb","id":"board:quickbase-knowledge","tkbPolicies":{"__typename":"TkbPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"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}}},"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":228,"kudosGivenCount":114,"kudosReceivedCount":120,"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:89187":{"__typename":"TkbTopicMessage","uid":89187,"subject":"Three Words of Advice on Pipelines","id":"message:89187","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:89187"},"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:89187"},"teaser@stripHtml({\"removeProcessingText\":false,\"truncateLength\":200})":"","postTime":"2024-11-26T06:51:55.604-08:00","lastPublishTime":"2024-11-26T06:51:55.604-08:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":230},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:learn/community:kqufx49752board:quickbase-knowledge/message:89187"},"Conversation:conversation:89187":{"__typename":"Conversation","id":"conversation:89187","solved":false,"topic":{"__ref":"TkbTopicMessage:message:89187"},"lastPostingActivityTime":"2024-11-26T06:51:55.604-08:00","lastPostTime":"2024-11-26T06:51:55.604-08:00"},"ModerationData:moderation_data:89187":{"__typename":"ModerationData","id":"moderation_data:89187","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:89187":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:89187","relatedMessage":{"__ref":"TkbTopicMessage:message:89187"}},"Rank:rank:20":{"__typename":"Rank","id":"rank:20","position":21,"name":"Qrew Trainee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:40763":{"__typename":"User","id":"user:40763","uid":40763,"login":"ChrisDavies","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-10-24T10:47:09.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":4,"kudosGivenCount":4,"kudosReceivedCount":1,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:40763"},"ForumTopicMessage:message:88765":{"__typename":"ForumTopicMessage","uid":88765,"subject":"PDF Document Generator, automatically attached to a record","id":"message:88765","revisionNum":3,"repliesCount":6,"author":{"__ref":"User:user:40763"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:88765"},"moderationData":{"__ref":"ModerationData:moderation_data:88765"},"postTime":"2024-10-22T02:56:16.846-07:00","lastPublishTime":"2024-10-22T03:00:43.557-07:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":336},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:88765"},"Conversation:conversation:88765":{"__typename":"Conversation","id":"conversation:88765","solved":true,"topic":{"__ref":"ForumTopicMessage:message:88765"},"lastPostingActivityTime":"2024-10-24T20:04:10.623-07:00","lastPostTime":"2024-10-24T20:04:10.623-07:00"},"ModerationData:moderation_data:88765":{"__typename":"ModerationData","id":"moderation_data:88765","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:88765":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:88765","relatedMessage":{"__ref":"ForumTopicMessage:message:88765"}},"Rank:rank:27":{"__typename":"Rank","id":"rank:27","position":22,"name":"Qrew Member","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:21816":{"__typename":"User","id":"user:21816","uid":21816,"login":"TimRoberge","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-06-02T16:39:11.000-07:00","confirmEmailStatus":null,"registrationAccessLevel":null,"ssoRegistrationFields":[]},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/images/dS0yMTgxNi1GRzFhNG8?image-coordinates=12%2C55%2C320%2C363"},"rank":{"__ref":"Rank:rank:27"},"messagesCount":5,"kudosGivenCount":0,"kudosReceivedCount":0,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:21816"},"ForumTopicMessage:message:89866":{"__typename":"ForumTopicMessage","uid":89866,"subject":"Are \"Document Templates\" still a feature in QB?","id":"message:89866","revisionNum":1,"repliesCount":3,"author":{"__ref":"User:user:21816"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:89866"},"moderationData":{"__ref":"ModerationData:moderation_data:89866"},"postTime":"2025-02-16T09:13:20.211-08:00","lastPublishTime":"2025-02-16T09:13:20.211-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":61},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:89866"},"Conversation:conversation:89866":{"__typename":"Conversation","id":"conversation:89866","solved":true,"topic":{"__ref":"ForumTopicMessage:message:89866"},"lastPostingActivityTime":"2025-02-16T12:38:16.912-08:00","lastPostTime":"2025-02-16T12:38:16.912-08:00"},"ModerationData:moderation_data:89866":{"__typename":"ModerationData","id":"moderation_data:89866","status":"UNMODERATED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:89866":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:89866","relatedMessage":{"__ref":"ForumTopicMessage:message:89866"}},"TkbTopicMessage:message:89723":{"__typename":"TkbTopicMessage","uid":89723,"subject":"Three Words of Advice on Building Pipelines - Brittany Scheid","id":"message:89723","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:89723"},"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:89723"},"teaser@stripHtml({\"removeProcessingText\":false,\"truncateLength\":200})":"","postTime":"2025-02-17T06:00:00.045-08:00","lastPublishTime":"2025-02-17T06:00:00.045-08:00","readOnly":false,"introduction":"","metrics":{"__typename":"MessageMetrics","views":126},"placeholder":false,"originalMessageForPlaceholder":null,"entityType":"TKB_ARTICLE","eventPath":"category:learn/community:kqufx49752board:quickbase-knowledge/message:89723"},"Conversation:conversation:89723":{"__typename":"Conversation","id":"conversation:89723","solved":false,"topic":{"__ref":"TkbTopicMessage:message:89723"},"lastPostingActivityTime":"2025-02-17T06:00:00.045-08:00","lastPostTime":"2025-02-17T06:00:00.045-08:00"},"ModerationData:moderation_data:89723":{"__typename":"ModerationData","id":"moderation_data:89723","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:89723":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:89723","relatedMessage":{"__ref":"TkbTopicMessage:message:89723"}},"User:user:6889":{"__typename":"User","id":"user:6889","uid":6889,"login":"JamesCarr","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-08-23T14:56:48.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-12.svg?time=0"},"rank":{"__ref":"Rank:rank:20"},"messagesCount":101,"kudosGivenCount":0,"kudosReceivedCount":3,"kudosWeight":1,"ssoId":null,"followersCount":null,"solutionsCount":0,"entityType":"USER","eventPath":"community:kqufx49752/user:6889"},"ForumTopicMessage:message:23661":{"__typename":"ForumTopicMessage","uid":23661,"subject":"Pipeline Incorrect Template Error","id":"message:23661","revisionNum":1,"repliesCount":14,"author":{"__ref":"User:user:6889"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:quickbase-discussions"},"conversation":{"__ref":"Conversation:conversation:23661"},"moderationData":{"__ref":"ModerationData:moderation_data:23661"},"postTime":"2023-11-23T14:27:00.000-08:00","lastPublishTime":"2023-11-23T14:27:00.000-08:00","readOnly":false,"metrics":{"__typename":"MessageMetrics","views":262},"placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"entityType":"FORUM_TOPIC","eventPath":"category:connect/community:kqufx49752board:quickbase-discussions/message:23661"},"Conversation:conversation:23661":{"__typename":"Conversation","id":"conversation:23661","solved":false,"topic":{"__ref":"ForumTopicMessage:message:23661"},"lastPostingActivityTime":"2025-01-13T08:55:00.906-08:00","lastPostTime":"2025-01-13T08:55:00.906-08:00"},"ModerationData:moderation_data:23661":{"__typename":"ModerationData","id":"moderation_data:23661","status":"APPROVED","rejectReason":null},"RelatedContentMessage:RelatedContentMessage:23661":{"__typename":"RelatedContentMessage","id":"RelatedContentMessage:23661","relatedMessage":{"__ref":"ForumTopicMessage:message:23661"}},"QueryVariables:TopicReplyList:message:83869:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:83869:1","value":{"id":"message:83869","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":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1742314867000","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"App Exchange","migrated-link-7":"Getting Started","migrated-link-8":"Success Stories","migrated-link-1":"Connect","migrated-link-10":"Help","migrated-link-2":"Quickbase Discussions","migrated-link-11":"Quickbase Help","migrated-link-0":"Welcome","migrated-link-5":"Learn","migrated-link-6":"Quickbase University","migrated-link-3":"Qrew Groups","migrated-link-4":"Qrew Champions Program ","migrated-link-18":"Blog","migrated-link-19":"Job Board","migrated-link-16":"Qrew Events","migrated-link-17":"Empower","migrated-link-14":"Qrew Tips","migrated-link-15":"Events","migrated-link-12":"Open Support Case","migrated-link-13":"Release Notes"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1742314867000","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1742314867000","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1742314867000","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1742314867000","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1742314867000","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1742314867000","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1742314867000","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1742314867000","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1742314867000","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1742314867000","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1742314867000","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1742314867000","value":{"alt":"Powered By Khoros"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1742314867000","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1742314867000","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1742314867000","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1742314867000","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1742314867000","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1742314867000","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1742314867000","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1742314867000","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1742314867000","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1742314867000","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1742314867000","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1742314867000","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/customComponent/CustomComponent-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/customComponent/CustomComponent-1742314867000","value":{"errorMessage":"Error rendering component id: {customComponentId}","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1742314867000","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1742314867000","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/nodes/NodeIcon-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/nodes/NodeIcon-1742314867000","value":{"contentType":"Content Type {style, select, FORUM {Forum} BLOG {Blog} TKB {Knowledge Base} IDEA {Ideas} OCCASION {Events} other {}} icon"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"quickbase-discussions","messageSubject":"generate-template-records-with-pipelines","messageId":"83869"},"buildId":"q_bLpq2mflH0BeZigxpj6","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"quickbase","openTelemetryServiceVersion":"25.2.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.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":[]}