Report Templates For Customers

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
  • (Edited)
I searched quickbase documentation and cannot find how to or if this is possible. 

I have a client that sends quotes to customers. Is there a way to create a report that has basic text like "Dear x, here is the amount for your quote $dollar" where x is a customer name  based on a filter and $dollar is based on some orders record.

Also, is it possible to leave a field open for the report for memo text that won't be part of the original order?

For reports I only see tables, charts, etc...
Photo of Alex Malishkin

Alex Malishkin

  • 72 Points

Posted 1 year ago

  • 0
  • 1
Photo of Noah McBride

Noah McBride

  • 356 Points 250 badge 2x thumb
I don't know if a report is what you're looking for.

You could certainly have this information displayed in an email, where you can reference fields like [Customer Name] and [Quote Amount] as variable text based on a condition.

You could as create a new field called [Display Text] which would simply be a Text - Formula field that would display something like "Dear" & [Customer Name] & "here is the amount for your quote" & [Quote Amount]. You could then have this field referenced in a Table report to show next to each record.

You could also create a page called "Customer Page" that asks that Customer for their name (or Customer Number) and then displays a filtered report of only their [Display Text] and [Quote].

Hope this helps!
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Another option that people often use is to create a PDF report of that information, and possibly include more details/line items.

Pretty much all of the QSP partners have a tool to create said PDF.

There is also a native quickbase tool called exact forms, but it is pretty rough to set up, and you'd need a consultant to help with that either way.

Matthew Neil - Product Specialist