How to display related field value from a grid edit dropdown selector (rather than record id#)
I have a grid edit table report that requires the user to select the "Related Content Allocation" before editing the rest of the columns/fields. However, the dropdown is displaying the related field's record ID, which isn't very user-friendly. Is there a way to display other related field values in this dropdown rather than the record ID# easily? ------------------------------ Matt Makris ------------------------------
Question on Connected Tables
Our company has several apps, it has become apparent to me that we have a lot of common information in tables across these apps. It has also become apparent that we could leverage connected tables to help manage this, so that we only need to update a table in one app as opposed to updating the same information in several apps. I'm wondering though how one would handle the existing table relationships. Example. We have an app (App A) that has a 'Customer' table. This table could be used in another app (App B) which has it's own 'customer' table. But the second app's table has several existing child tables. Would I be able to just make a new connected table from App A to App B, and then just sever the existing relationship with one of App B's child tables (but keep the reference field), then make a new relationship with the connected table? That seems possible to me, but I'm wondering about the key field in the connected table. I wouldn't be able to use the key field the source table is using because in App B the 'Customer' table uses a calculated key. Would I be able to define a new key field in the connected table so that the child table keys could be mapped to it?
Many parent records on a single child record
Hi everyone, I'm having some issues building the following: I need to build a table where a laboratory analyst can record analytical standards that they have prepared. I have one table that records reagent inventory and relevant reagent information like lot number, date received, expiration date, manufacturer, etc. For analytical standards that use only one reagent, this is simple to build with a one-to-many relationship. However, some standards are made with multiple different reagents. How do I get multiple parent records on a single child record? Any help would be appreciated!
Intuitive way to pick line items from a list
I want to allow my clients to create a Purchase order and then pick items from inventory to be line items of Purchase Order. The normal way to do this would be to display a report of available inventory on the Purchase Order record and then let the user pick which of the items he would like to be part of the purchase order. Is there an intuitive way to do this in Quick Base?How to Show Conditional Data in a Related Join Table
Hello all, I have an app with three tables: Faculty Records - Contains the various credentialing programs available for physicians. Physician Info - Stores static information like name, title, and person number. Physician Credentials - A join table that shows the relationship between physicians, credentials, and the dates those credentials were approved. The relationships between these tables are as follows: Here’s the issue I’m facing: One specific credentialing program from the Faculty Records table includes advanced privileges (checkboxes) unique to individual physicians. These privileges: Are only relevant to this one credentialing program. Differ from person to person. Ideally, should appear in the Physician Credentials table alongside the credentialing program, approval dates, and physician name. While I could add the advanced privileges to thePhysician Info table, how could I then see them in the Physician Credentials table? Would queries be a solution for this? (I’ve never used those before.) What’s the best way to structure this? Thanks in advance for your help! Meag
Attendance Tracker
I am trying to build an app that will keep track of attendance by name based on the selected location of the plant. Ideally there is just a multiple-choice field at the beginning of the tracker of the area of the plant, and that will populate the list of names associated with that area. From there, each name would have a checkbox associated with it to designate that person was in attendance. If possible I would want there to be some way to show the attendance percentage of each person as well. I was thinking having the list of names associated with each area in a separate table. Then each person that populates in the tracker form would have an associated check box as a separate field (unless there was a way to make that one field). The issue that I see with that is there isn't really tracking by person that I could figure out, and if you change that list in the separate table then that changes past records of the tracker, which could be an issue. Any help or tips with this would be greatly appreciated!
Maximum Summary field not working
I have Table A with all of the delay records. I have Table B that counts them by airports using a summary field in a table relationship. I have Table C that I want to grab the top five from Table B using maximum summary fields in a table relationship with Table B. Here is Table B. When I add a summary field in the relationship with Table C, I put in maximum and it returns nothing. Below is what I'm using for the summary field. Both of the fields are numeric. Does anyone have any idea why this might be happening? I followed a Kirk Trachy YouTube video explaining how to do this and followed the direction exact to what he showed in the video.
