Re-establishing relationships in migrated databases
I need to understand how to re-establish relationships on existing tables that I have migrated into Quickbase. I know am absolutely missingsomething that is probably pretty obvious. Its an MSAccess database, so its SQL compliant. I have a table with important information in a field that I want to preserve. This is the field in the child table--lets call the field BigInfoValue (a numeric field) and the table ChildTable. I have a tiny table with other information in it that defines what the values in BigInfoValue mean. Lets call this BigInfoParent table, and lets call the fields BigInfoValue (a numeric field I want to relate the tables on which I've also designated the key field), BigInfoTerm, and BigInfoDefinition. I absolutely cannot figure out how to make the two tables link on BigInfoValue. When I try to create a table relationship, with BigInfoParent, Quickbase does not offer me BigInfoValue in the child table as a linking field. It creates a brand-new field called Related BigInfo something something. I've also tried to establish a table relationship with the RecordID field in BigInfoParent to BigInfoValue in the ChildTable. No dice. Quickbase just doesn't offer me the field that I think should be linked. Any help would be appreciated.
Quickbase Actions
I am trying to make a Quickbase action... When a certain action takes place, I would like for a field to be edited, rather than having a new record created. However, the option for a field to be edited is blurred out. I need the field in another table to be edited? What am I missing?
Relationships functional question
Hello! Intermediate-level user here and very much enjoyed the former QB forum - hoping to see some familiar faces on here. I am dipping my toes in the waters of fixing a Quickbase app that I didn't actually build - which is great! Something I'm thinking I want to learn more about/perhaps pursue from here. But also feels like the litmus test here - fixing my own Quickbase that I built is one thing, but now getting to know the ins-and-outs of someone else's is - wow. Anyway. One ask from the team I'm refreshing this for, I'm struggling with because I'm not sure this is possible. They want to see on the Table view, a field that populates a date from the related table of the last record. Perhaps there's a formula that I can pull to make this a field. So -- in the simplest terms, I feel like what this field needs to be is: Parent Table owns the field, and that field is points to the Record Date of the newest Child Table record. How can I do this? Is there perhaps a formula field to build? Also - I see my predecessor attempted this, and it is reporting out on several fields..... I don't quite know how to make sure my fix populates everywhere, other than editing the specific existing field. Could I just copy that field, and it'll still report on those records? I know if I "change type" of field, you can often only do that once, and it won't let you change it a second time.
Report Using Multiple Tables
Hi Everyone, Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on four different tables. Any help would be appreciated. ------------------------------ Terri Wells ------------------------------
Text Lookup field shows "error displaying report" instead of value
I have two text lookup fields that are displaying the same error: However, the same two lookup fields display properly in the form for the child table: Is anyone familiar with this error and how to resolve? Please let me know what additional information is needed to assist. Thanks in advance for your help! ------------------------------ Melanie Mercadel ------------------------------Empty left column in embedded report in exact form
How to remove first column (edit / view) for embedded report in exact form. I am using this ~=qdb.GetURL("bhjz7apud", "API_GenResultsTable^query={'13'.EX.'"+field["Record ID#"]+"'}^clist=6.10.14.26^opts=nos.ned.nvw.");~ for embedding the report. But my problem is one empty column is appearing on left side. Please help
