ContributionsMost RecentMost LikesSolutionsFormula field error I'm having an issue with a Rich text formula field pulling a Combined Text Field correctly. Any time there is only one item in the combined field it doesn't pull over to my formula. Here is the formula for the "Contracts" Rich text field: If([Budget Classification]="2- Contractual", "<span style='font-weight:bold'>"&(ToText([BVA Project])&"<hr></span> \n <td " &(ToText([Combined Text Contract Document Title]))) &"<td>\n\n <td "&[Combined Text Organization/PO]&"</td>\n\n <td "&[PO #]&"</td>\n\n <td "&[Combined Text Contract Balance]&"</td>\n", [Expense Code]) ------------------------------ Bethany Hudson ------------------------------ Re: Embed a Report into Another Report's FieldMany Projects to one Grant Budget. Each Grant Budget has its own budget, expenses, encumbered, cash balance, and available balance. Then each Project may or may not have many Contracts and each will have its own budget, expense, etc. and then a vendor, PO #. This is what an Excel spreadsheet looks like: I'd love to have it match, but I know having the currency fields like this isn't possible. ------------------------------ Bethany Hudson ------------------------------ Re: Embed a Report into Another Report's FieldWhat we're wanting is a little tricky. We need a BVA report for individual grants. Each grant contains multiple projects. Within those projects, there are multiple contracts that we want certain information to show. I've tried a field that contains multiple combined fields, but it's very cumbersome and the combined fields don't always match the other related combined fields correctly. eg. when there are multiple contracts the PO #, contract amount, etc. don't always correspond properly. I also tried a rich text field with a table listing all the information, but I can't get the formula to work, so maybe that's what I need. ------------------------------ Bethany Hudson ------------------------------ Embed a Report into Another Report's FieldI'm trying to embed a report as a field in another report. Basically this: I've created the code page: [iol] & "modulecontracts.js" & [/iol] & "<span class='QBU_ToggleChildren'" & " data-rid='" & [Record ID#] & "'" & ">+</span>" I'm having trouble with the formula field: (function(){ $("img[qbu=modulecontracts]").remove(); var dbid = "bqij8g449"; var dbid GrantBudgets = "bqrnue9x7"; var rid= "85"; var apptoken = "b4bgu9_mk8a_0_dut3hpibru9pbtq884vsd7djvmt"; var querystring=document.location.search; $(".QBU_ToggleChildren").on("click", function() { if ($(this).text() == "+") { $(this).text("-"); } else { $(this).text("+"); } var rid = this.dataset.rid; $("#child_rid_" + rid).toggle(); }); }) I need help! ------------------------------ Bethany Hudson ------------------------------ Table Report HelpI have a report that needs to show the following: [Strategy Code] [Project Title] [Activities] There are different [Project Type]s, so it includes certain project titles more than once with the related activities for that type. Is there a way to show just one project name and combine the related activities to that one field? ------------------------------ Bethany Hudson ------------------------------ Subtotal in a Summary Report?Is there a way to show subtotals on a Summary Report? I want to have a subtotaled line by the field BVA Strategy. Here's my report: ------------------------------ Bethany Hudson ------------------------------ Re: Pipeline- only trigger if field has changedYes, that's exactly what I need. ------------------------------ Bethany Hudson ------------------------------ Pipeline- only trigger if field has changed I have a Pipeline that currently works great, but it duplicates the record anytime a change is made. Here's what I have: Trigger Record Updated: [Contract Ending] which is a formula field: If([Contract Extension Date text]<>"", [Contract Extension Date], [Contract End Date]) Create an Event: (to the selected Google calendar with the fields filled in) All the [Contract Ending] records are on the calendar now, but it's duplicating the event any time I make a change to ANY of the contract dates since it's a formula. So then I tried Search Events and then Update Event. Then I tried doing a query expression but I'm not sure how to format it. Maybe it needs to trigger from the other date fields? Basically, I need an event created to a Google calendar, with the [Contract Ending] date, which is either the [Contract End Date] or [Contract Extension Date], depending. Then, IF there is a change (most likely only in the extension field), I want it to update on the existing calendar event. ------------------------------ Bethany Hudson ------------------------------ Rich Text Field Loses Currency Format in PipelineI've got a Pipeline that links to my Google calendar. Everything works fine, but I'm losing the currency format on a field. Is there a way to fix this? ------------------------------ Bethany Hudson ------------------------------ URL Mail To helpI've got a URL formula field that needs to open a draft email with the names [Combined Text Email] and subject [Meeting Date] filled in. So far I've gotten the open email part but can't seem to get the rest right. Here is my formula: var text Email = "MailTo:" &([Combined Text Email]); var text Subject = &(ToText([Meeting Date])) &"?Subject=" & "($Subject)"; var text URL = "<a href='https://mail.google.com/mail/u/0/#inbox?compose=DfGhPkmsgkdqdlggxFvglVRkZfcTHWhDXKQCcvMpFWgcvJwfvqpmJnlSrZSPjWFGxGpXhLsdMmJvpJzlxmXGPBWlJlWPCkgbXhKxmtsCqdDmhmTpzpjtsxxB'>Email Contacts</a>"; $URL & "&rdr=" & URLEncode($Subject) & URLEncode($Email) ------------------------------ Bethany Hudson ------------------------------