Recent Discussions
Reference Numbers Displaying Instead of Names in QuickBase
I have three tables in QuickBase: Physicians, UT Advanced Privileges, and Physician Privileges. Physicians and UT Advanced Privileges are parent tables to the Physician Privileges table. The issue: In thePhysician Privileges table, the fields are displaying as reference numbers instead of showing the actual physician and privilege names. How do I fix this to show the names instead?Solved0likes4CommentsCheckbox Fields Vs Multi-Select Fields for Tracking
Hi, I have a table with physicians and the advanced privileges they may have. There are 9 advanced privileges (there could be a few more down the line), and each physician may have a unique combination of these privileges. I’m trying to decide whether to store each privilege in its own checkbox field or use a multi-select field where you can choose the privileges that apply. I like the multi-select approach because it’s more compact, but my concern is that I need to be able to select a single privilege from the list of 9 and see all the physicians who have that privilege. I'm not sure how to do that with a multi-select field. Can anyone advise on the best way to set this up? Thanks!Solved0likes2Comments
Way to Duplicate Tables or Make A Template for a Table?
I might just not be seeing it, but is there a way to duplicate tables or save a template for a table? I need to make 51 tables that are all identical, except for the name and data that will be stored in it. I figured it would be easier to make one and then create duplicates than have to manually build all of them.Solved0likes1Comment
Distinct Dates
I'm having trouble trying to build a report that only shows distinct dates for a given variable. Scenario: I have multiple entries with activity date ranges. If those multiple entries contain the same date(s), I only want to count each calendar date once, no matter how many entries there are that contain that date. Does anyone have advice on how to achieve this?Solved0likes6Comments
Trying to calculate On Time delivery
I have a table that holds shipment data, Ship to, Reference #, Due Date, Ship Date, and then a formula field that returns "Yes" if the the the Ship Date is less than or equal to the Due Date and "No" if not. I now want to show an over all Percentage of how often we are On Time. Any suggestions on how to set up a report that would portray this information? I was looking for a formula that would count how many records where the On Time field = Yes so that I could maybe summarize that. Any thought on how to set this up would be greatly appreciated.Solved0likes5Comments
Field to "assign" a user group
I have an app tracking our department's flight delays. Depending on origin/destination of the flight, it's assigned to a group at a specific base. I currently have my app set up to "assign" the delay to a specific user with a table to table relationship based on airport code. On the dashboard, reports pull data based on the current user being in the "assigned" field. More than one person in each base may be responsible for following up with these delays. Is there a way to designate a user group, or multiple users (without making separate fields for each position) instead of one user to a record? If I can offer any other information to advise on this, let me know! Thank you!Solved0likes4CommentsHow to Link Tables in a Complex Many-to-Many Relationship?
Hello all, I have two tables: Physician Info: Contains columns for the physician's name, person number, and other static info about that physician. Credentialing: Contains the physician's name along with approval and renewal dates for various credentials. The reason I’m not combining everything into one table is that the Credentialing table is extensive, and I plan to add other tables in the future as well and if it is all in one table it becomes massive to edit. I know I need a Join Table to link these two tables. In the Join Table, I want to click on a physician's name and see all the information from both the Physician Info table (name, person number, and static info) and the Credentialing table (approval and renewal dates). I’ve watched the online many-to-many video multiple times and even have a simpler app that uses a many-to-many relationship, but I can’t seem to wrap my head around how to apply it to this project. How do I properly set up the Join Table to link these two tables, and how can I make it so I can view all relevant information for each physician in one place? Thanks! MeagSolved0likes3Comments
Nested API Button open form to add input, check box and redirect back to original form
I have another API Button question...similar to my last question. Using the same table set up (below), but this time the button would be selected if it's for a license that would not be applicable and input from the User would be required. I created a simple table that would pop up when the button was pushed asking the User to add information into the field. It would also check the [Not Applicable] button, then refresh back to the original page. However, I get the attached error page. Any thoughts? License Master(parent table) Pending Locations(parent table Suggested Licenses(a child (many to many table) to both above) Licenses (child (many to many table) to both License Master and Pending Locations / unrelated to Suggested Licenses) var text UpdateSuggestedLicense=URLRoot() & "db/" & [_DBID_SUGGESTED_LICENSES] & "?act=API_EditRecord" & "&rid=" & URLEncode([Record ID#]) & "&_fid_18=true" //Check Not Applicable to this Location & "&apptoken=MY TOKEN" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]); var text OPEN="<a class=\"OpenAsPopup\" data-height=900 data-width=900 href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] // Suggested License ID & "&dfid=11" // Not Applicable form ID & "&apptoken=MY TOKEN"; var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();//refresh and redirect back to License page $OPEN &"&rdr=" & URLEncode($UpdateSuggestedLicense) & URLEncode("&rdr=" & URLEncode($RefreshPage))Solved0likes3Comments
