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.
Intermittent Issue: Contacts Not Displaying After Adding to Form/Table
Hi! I am trying to resolve an issue that has been happening since last year and that neither QB Support nor I have been able to solve. This issue randomly began out of the blue, and I can't make sense of it. The process: User 1 adds a task (record) to the 'Client Request Form' for XYZ Company. User 1 clicks 'Add Client Request Contact'. This takes the user to the child form Client Request Contact. User 1 will add the XYZ Company contact via an email dropdown box. If the contact does not exist from a previous entry, User 1 will click 'create new contact'. Upon clicking, the 'Contacts' form will open for User 1 to enter a new contact associated with XYZ Company. After adding the new contact, the contact is now available to add as a contact for any future Client Request Form tasks/records entered. The issue: When User 1 attempts to associate an existing contact with a Client Request form, the list of possible contacts does not display, resulting in the user having to add the contact repeatedly. Additional Information: Multiple contacts can be associated with one Client Request Form. We have been using Quick Base for 5 years now, and this issue was first discovered in 2023. We have 1,000+ clients in our application. When it was first reported as an issue in October 2023, the user only saw this happen on 6 clients added by different sales team members in 5 different months from January 2023 to September 2023. The other was added back in 2019. Today, the number affected is higher than 6. Please let me know what additional information I can provide. I hope we do not have to create something new, as this will impact over 17,000 existing records. Thanks in advance!
Viewing content from a hidden table?
I'm sure I'm missing something simple here, but I have a few tables that are source data for table-to-table relationships. I don't want / need most users to see the information in these tables so have unchecked "show in table bar" in the advanced settings. However, occasionally I DO want to see what's in that table. The only way I've found to do that is to change that setting, look at what I want to see, and then change it back. Is there an easier way?
Table-to-Table Relationship Question
Is there a way to create a table-to-table relationship that you can use with a multiple-choice field? For context, I am trying to create an inspection form that pulls questions from another table based on the equipment that is selected at the top of the inspection form. The questions on the inspection form need to have a "Pass" or "Fail" option, hence why I would like them to be multiple choice. Or if there were some formula that would do something similar, that could also be helpful. Any feedback would be greatly appreciated!
Incrementing a field values based off another field's content.
Hello, I'm currently working on a project where many tables have relationships and require automation features. For instance, if a user selects an option from a lookup field, [Field X], in Table X, then in doing so, [Field Y] will increment in another separate table, Table Y. My design right now is built on a set of reference tables that can be utilized in an operations table. My goal is to "trigger" events such as the one described above to reduce clutter in the operations table. I can provide screenshots and table data/field info if the structure of my app is not sufficiently described. All of the data are just filler to work on functionality. Many thanks, Gabe
Assign Child Record to Parent Record
I'm trying to create an inventory database with my Users as a parent table and my Computers as the child table. Computers need to be assigned to users. I can go to the computer table and easily assign to a user, but I want to be able to go to the user table form and assign an existing computer. This is a Quality Of Life request, to be able to open the form view of the user and then assign existing computers from the computer table and other equipment from subsequent tables. Thanks.
