ContributionsMost RecentMost LikesSolutionsRe: Formula Field not Displaing Right on Report That was definitely it. Thanks!! ------------------------------ Ender Taylor ------------------------------ Re: Formula Field not Displaing Right on Report It does misbehave on both. so I will check my syntax. Thanks for the advise! ------------------------------ Ender Taylor ------------------------------ Re: Formula Field not Displaing Right on Report So the weird thing is it displays correctly on the Form, and on a Kanban style report just not the table report. ------------------------------ Ender Taylor ------------------------------ Re: Formula Field not Displaing Right on Report var text escapingquotes = SearchAndReplace([Customer Communication Remarks],"\"","""); If([Type Customer Communication]=true and [Type Internal Communication]=false and [Type Note]=false and [Type Task]=false, "<table style='width:100%;border: 0px Solid White'>"& "<tbody>"& "<tr"& "<td>"&"Type: "&[Customer Communication Type]&" | HO Status: "&[Homeowner Status] &" | Remarks: "& If(Length([Customer Communication Remarks])>120,Left([Customer Communication Remarks],120)&"<a href='"& Dbid()&"?a=dr&rid="&[Record ID#]&"' title=\""&$escapingquotes&"\" target=\"_blank\" \"><i><font color=blue> Hover...</font></i></div></a>",[Customer Communication Remarks])&"<br /"&"</td>"& "</tr>"& "</tbody>"& "</table>", If([Type Customer Communication]=false and [Type Internal Communication]=true and [Type Note]=false and [Type Task]=false, "<table style='width:100%;border: 0px Solid White'>"& "<tbody>"& "<tr"& "<td>"&"Remarks: "& If(Length([Internal Communication Remarks])>120,Left([Internal Communication Remarks],120)&"<a href='"& Dbid()&"?a=dr&rid="&[Record ID#]&"' title=\""&$escapingquotes&"\" target=\"_blank\" \"><i><font color=blue> Hover...</font></i></div></a>",[Internal Communication Remarks])&"<br /"&"</td>"& "</tr>"& "</tbody>"& "</table>", If([Type Customer Communication]=false and [Type Internal Communication]=false and [Type Note]=true and [Type Task]=false, "<table style='width:100%;border: 0px Solid White'>"& "<tbody>"& "<tr"& "<td>"&"Note: "& If(Length([Notes])>120,Left([Notes],120)&"<a href='"& Dbid()&"?a=dr&rid="&[Record ID#]&"' title=\""&$escapingquotes&"\" target=\"_blank\" \"><i><font color=blue> Hover...</font></i></div></a>",[Notes])&"<br /"&"</td>"& "</tr>"& "</tbody>"& "</table>", If([Type Customer Communication]=false and [Type Internal Communication]=false and [Type Note]=false and [Type Task]=true, "<table style='width:100%;border: 0px Solid White'>"& "<tbody>"& "<tr"& "<td>"&"Task: "&[Task Name]&" | Assigned To: "& ToText([Assigned To])&" | Status: "& [Task Status]& " | Due: "&[Task Due Date]& " | Completion Status: "&[Completion Status] &"<br /"&"</td>"& "</tr>"& "</tbody>"& "</table>", "NA")))) ------------------------------ Ender Taylor ------------------------------ Formula Field not Displaing Right on Report I have a formula Field that shows up correctly on the form, but on the report I get this in place of what should show up: <TR Anyone know why or how to fix it? ------------------------------ Ender Taylor ------------------------------ Pipeline Automation with Google Sheets Hey Can anyone help me understand how to set this up properly? For step B, I want it to search for all Rows that match the conditional querie on Step A, and then for the records it finds, I want it to update those rows, for records it doesn't find, I want it to create a new row. I tried doing a "insert a condition" after step B where I was going to say if RID for A = RID column in B, Update, but it doesn't let me do that. There is no ability to select a Field (Cell) from step B, But I found this: Does that mean that if the List of Rows is ENTIRELY empty as in it didn't find any rows, or just that there are some records from STEP A that don't match Step B? Thanks! Ender ------------------------------ Ender Taylor ------------------------------ Embed Google Drive Anyone know if there is away to authenticate yourself on Google Chrome through Quickbase so that on an embedd URL Link it can authenticate you so you can have access? ------------------------------ Ender Taylor ------------------------------ Reports within Reports Anyone know of anyway to create a report on a parent table that lists records where a report for the child table that are associated with that record. (as opposed to the link option) Context: We have Tasks and Sub-Tasks where subtasks are the child records of the Tasks. We want to display the report of those subtasks within the report of the Tasks. I feel like this should be doable, but also maybe not. Thoughts?? ------------------------------ Ender Taylor ------------------------------