I just recently came across a Dan Diebolt post that addresses the issue; I got this onto my team's agenda to investigate using this method to solve our templating problems. See if this gets you somewhere: https://community.quickbase.com/quickbase/topics/what-is-the-hylo-technique","body@stringLength":"696","rawBody":"We too have some clunky implementations for similar use cases where we've kludged something together by different methods over the years.
I just recently came across a Dan Diebolt post that addresses the issue; I got this onto my team's agenda to investigate using this method to solve our templating problems. See if this gets you somewhere: https://community.quickbase.com/quickbase/topics/what-is-the-hylo-technique","kudosSumWeight":0,"repliesCount":0,"postTime":"2018-12-21T14:35:00.000-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:33031_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":1},"visibilityScope":"PUBLIC","isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"parent":{"__ref":"ForumTopicMessage:message:33030"},"replies":{"__typename":"MessageConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"User:user:18470":{"__typename":"User","id":"user:18470","uid":18470,"login":"AlexCertificati","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-10.svg?time=0"},"rank":{"__ref":"Rank:rank:19"}},"ForumTopicMessage:message:33030":{"__typename":"ForumTopicMessage","uid":33030,"subject":"Automation - record creation of child records for 2 parent records","id":"message:33030","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:18718"},"readOnly":false},"Conversation:conversation:33030":{"__typename":"Conversation","id":"conversation:33030","solved":false,"topic":{"__ref":"ForumTopicMessage:message:33030"},"lastPostingActivityTime":"2018-12-21T14:35:00.000-08:00","lastPostTime":"2018-12-21T14:35:00.000-08:00","unreadReplyCount":1,"isSubscribed":false},"ModerationData:moderation_data:33031":{"__typename":"ModerationData","id":"moderation_data:33031","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:33031_1":{"__typename":"Revision","id":"revision:33031_1","lastEditTime":"2018-12-21T14:35:00.000-08:00"},"User:user:18718":{"__typename":"User","id":"user:18718","deleted":false,"uid":18718,"login":"JasonJohnson","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T14:28:15.000-07:00"}},"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},"Rank:rank:17":{"__typename":"Rank","id":"rank:17","position":18,"name":"Qrew Captain","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:32480":{"__typename":"User","id":"user:32480","uid":32480,"login":"MCFNeil","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.quickbase.com/t5/s/kqufx49752/m_assets/avatars/default/avatar-11.svg?time=0"},"rank":{"__ref":"Rank:rank:17"},"email":"","messagesCount":1198,"biography":null,"topicsCount":5,"kudosReceivedCount":31,"kudosGivenCount":22,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-07-16T15:06:32.000-07:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ModerationData:moderation_data:39319":{"__typename":"ModerationData","id":"moderation_data:39319","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:39319_1":{"__typename":"Revision","id":"revision:39319_1","lastEditTime":"2018-02-16T19:16:00.000-08:00"},"QueryVariables:ReplyList:message:39319:1":{"__typename":"QueryVariables","id":"ReplyList:message:39319:1","value":{"id":"message:39319","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":false,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1742314867000":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1742314867000","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"quickbase-discussions","messageSubject":"line-items-from-an-estimate-to-a-project","messageId":"39318","replyId":"39319"},"buildId":"q_bLpq2mflH0BeZigxpj6","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"quickbase","openTelemetryServiceVersion":"25.2.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/messages/RelatedContentWidget/RelatedContentWidget.tsx","./components/community/FooterWidget/FooterWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/community/FooterWidgetHelpLink/FooterWidgetHelpLink.tsx","./components/community/KhorosLogo/KhorosLogo.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","./components/messages/MessageView/MessageViewInline/MessageViewInline.tsx","../shared/client/components/common/Pager/PagerLoadMore/PagerLoadMore.tsx","./components/customComponent/CustomComponentContent/HtmlContent.tsx","./components/customComponent/CustomComponentContent/TemplateContent.tsx","./components/customComponent/CustomComponentContent/CustomComponentScripts.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[]}