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...
Question
Report Templates For Customers
This topic has been closed for replies.
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
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
.
Hope this helps!
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.
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.