Can you create a relationship between a table and a report?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have a table full of buyers with a key field that is a unique ID generated at the time each buyer is created.

I want to link my buyers who have a value in a non-key field to another table in my app. It is easy enough to create a report from my buyers table that shows the table I want, so I'm wondering if I can connect that to the other table.
Photo of Hilary

Hilary

  • 0 Points

Posted 3 years ago

  • 0
  • 1
I think that you want to set up a Report Link field.  It's a type of field that just lives to facilitate embedded reports on a record where a relationship may (or in your case may not) exists.  All it need to know in its setup is which field on the pseudo parent record needs to match to which field on the pseudo child.

So, create that field of type Report Link, and configure the matchups, and then put it on the form and set the form properties to show the records on the form.
Photo of Hilary

Hilary

  • 0 Points
Hmmm, unfortunately that functionality isn't in the Essential Plan.
Really??  i don't do any work with the essentials plan and i'm not sure offhand where the list of features and limitations is.  So when you go to create a new field, are you are saying that there is no available field type to choose called Report Link?
I don't see that limitation listed here http://quickbase.intuit.com/plans-and-pricing
Photo of Hilary

Hilary

  • 0 Points
I don't see Report Link in the dropdown, limitation is mentioned here: https://www.quickbase.com/user-assistance/linking_databases.html
OK, so that's a reason to consider upgrading I guess.  I think of another way, but involved the use of a URL formula field and I don't think that functionality exists either.  That would launch the report off a buyer record without having to answer any questions on the report.
Photo of Hilary

Hilary

  • 0 Points
I'm trying to find if there is a way for a report to BE a table in quick base, like a constantly updating table that is just pulling from another table.
I'm not sure your business purpose for asking that, but yes, QuickBase Sync can maintain two tables in sync which are in the same app or different apps.  It would not be normal to want to do that within a single app.  Of course, that advanced feature is not available in the Essentials plan.  QuickBase sync can also Sync with csv files in other cloud storage systems like dropbox as well as gmail and also other cloud based systems like QuickBase on line and a bunch of other ones.