ContributionsMost RecentMost LikesSolutionsRe: Rich text lookup field not displaying correct when emailing a report Hi Mark, the field in my report is a rich text lookup field. I am using this field for the sorting/grouping for this specific report. It is not a button Re: Rich text lookup field not displaying correct when emailing a report This isn't a subscription email. I am on my report, and then just click on the 3 dots, and am selecting email. In that screen (see attached) does not have that option. Rich text lookup field not displaying correct when emailing a report When I email a report from QB, I have a rich text lookup field that is not displaying correctly, it is showing the actual code: <span style='font-family: Gibson-Regular; font-size: 13px;'>Aviation and Occupational Medicine</span><br><span style='font-family: Gibson-Regular; font-size: 10px;'>6900 East 47th Avenue Drive<br>STE 100<br>Denver, CO 80216</span> (8 AP Invoice) Any ideas why or how to correct this issue? Re: RT Formula Checkbox Summary field help Thanks Mark! I knew was was just overthinking it! RT Formula Checkbox Summary field help I need a some formula help to show the results of a checkbox summary field. If the checkbox result is yes, then I want to show the message 1" or more Invoices is missing our Cost!" and if the result is no "Our cost is up to date" I a drawing a blank so any help is appreciated! Re: If currency(summary field) is blank formula help That worked perfect! Thank you as always!! If currency(summary field) is blank formula help I have a currency summary field in my invoice table that shows "our cost" which is summarized from another table in out APP. I would like to create a formula checkbox field that will be checked if the "our cost" field is blank in my INVOCIES table. Is this possible to do? I have tried several formulas option in a checkbox formula field, the NZ function, as well as the Null function using another field I created and converted our cost to a text field. I need to use this missing our cost field for several other things as well, but cannot get the formula right..... Thanks SolvedLookup a field within same table? Is there a way to lookup a field within the same table? Re: Client portal/App setup help Hi Mark, Is this the easiest route to accomplish this? I see and agree with your point of using 1 separate app for all our clients. I have several questions, but first would like to clarify 1 thing first -- If I am reading this correctly, I would be creating 2 new apps, 1 - Client Portal APP, and 2 - Client Users APP?? Once you answer that it will allow me to ask my follow ups if that is okay! Display a logo on all child tables? I have an image table where we have uploaded all of our clients logos so they are stored within our APP. I would like to automatically have the company logo placed on certain forms in several different tables. Any suggestions as to how to do this?