How can I avoid saving a form if I need the user to create another record in a related table first?
Hi I need support with the following issue, I have created a form. This form contains a button to add more product requests. But many times users do not add products to the request and the request remains open and empty, unattended and incomplete. Until the user comes to upload products and in the form selects that no more products need to be added, Quickbase executes rules and notifications to complete this multiple or single product order as completed and processes the request. The problem is that I don't know of a way to prevent them from creating and saving the empty product order. Is there any way to achieve that result?Help with Lookup Fields from Multiple Parent Tables in Quickbase Form
Hello, I have a Quickbase app where a single child table is connected to three separate parent tables. Each parent table represents a different employee group, and the child table is set up to pull employee information from all three. In the form for the child table, I want to be able to look up and select employees from any of the three parent tables. However, I can only select from the first parent table I connected—its lookup field is active. The lookup fields for the other two parent tables appear grayed out and are not selectable, even though they are all connected in the same way, using the employee name as a lookup field. As shown in the screenshot, only the first table’s name field is selectable, while the others are disabled. What might be causing this behavior, and how can I make all three lookup fields usable in the form? Thank you!
Script a button to print current record to DYMO
I'm finally moving a product pricing process from EXCEL into QB. The last step is giving a user(s) the ability to print product labels from QB to a local DYMO printer. What I had envisioned was a button on the record form that would take a half dozen or so values in the record and push them as values for the label. Has anyone here done this already? If so, are you willing to share any of your scripting? My JavaScript experience is extremely limited. This link is an example of printing to a DYMO via a JavaScript library, but I don't really understand how to set the values of QB fields as the values to send to the printer. http://developers.dymo.com/2010/06/02/dymo-label-framework-javascript-library-samples-print-a-label/ Any help would be greatly appreciated.
Employee list
Hello, I have a multi-select text field with employee name choices that is going to be archived and no longer used. In that fields place I will be adding fields that relate back to a connected employee roster table for the user to locate and pull the info from, however, I'm wondering if there is a way to have the new field populate based off the names that are currently already in the multi-select field?
Minimizing side menu when opening a pop up
Any options/tricks for minimizing the side menu when opening a pop up from a rich text button? What I notice is if the side menu is expanded in my parent page it will also be expanded in the pop up... ideally I want to always minimize the side menu in a pop up
Opening form in edit mode
Hello! Does anyone know how/if you can have a form always be in edit mode? Most of our users are in and out of forms all day for the purposes of editing, so ridding the extra Edit mouse click would be a win. Thanks :) R ------------------------------ Rick Satenstein ------------------------------
Duplicated record fills blank user fields with "[object Object]"
When duplicating a record from a new-style form, all blank user fields seem to be automatically filled with "[object Object]" upon save. The user fields are flagged to copy the value when "Copy this Record" is used. Happens in Chrome and Edge. Tested this in a new table with no pipelines or QB actions. Has anyone seen this and know of a fix?
Removing Blank Input Type
Hi, I am new to Quickbase, I have a table with multiple columns in it and there is a location column that I am using. In the Location column I want to show only 3 values. When I try to add the 3 items, the system auto creates a blank option too. I don't want that option, I am trying to turn that off. Any ideas on how to do that? The field properties are Text - Multiple Choice.
Pop up window from table home to preview record
Wondering if there is a way to create a button or link on each record so that when viewing from a table home report would open a smaller pop up window that would display some of the records details? Would also like to then have that window pop up have a button which could be clicked to view the full record. Would be nice to not have to display so many columns on a table home report, instead the preview pop up could hold 3-5 data fields with the option to open the full record.
