Using a barcode scanner to associate multiple existing child records to a parent record.
I am trying to integrate barcode scanning into the app I am developing in order to track and manage the manufacturing process at my companies manufacturing plant. The plan is for each part to be assigned it's own unique QR code (essentially representing the unique record ID of each part in quickbase) and to scan that QR code at each stage of the production process to ensure that every part is tracked as it moves through the plant. Eventually all of the parts are put onto a pallet before being shipped out. I am currently looking for a way to streamline the palletization process. In my app I have a Pallet table that is the parent table to the Parts child table. The way I imagine the process working is that each pallet will have a QR code which, when scanned, would allow a user to scan the QR codes for all of the parts that are going on that pallet and then clicking a save button that would relate the scanned parts to that pallet. I'm imagining this could be done using the Quickbase API using something similar to the "add child record" button that is automatically created in the parent table when creating a relationship, but instead the "button" would be a scan and instead of creating a new record it would update the "related pallet" (the parent record) field of the exiting part records for all parts scanned prior to clicking the save button. ------------------------------ Ben Krieger ------------------------------
Exact Forms - Extra Spaces with Rich Text fields
I have a multi line rich text field in an exact form. In the past I used html to manage the spacing which worked fine. When Quickbase changed the formatting on this field I can no longer use html in the field successfully (I can put html in the source). My issue is for every hard return it adds an extra space at the bottom of the text. I used to be able to use </br> and write all the text on one line to eliminate this problem
Assign multiple child records simultaneously
Hello, I'm looking to add several child records to a parent in one go if possible. The parent is the Projects table. At the moment I have child tables for Diseases and Geographies which are added in the usual way. This is a bit of a hassle as there are usually 10+ geographies per project. I want to expand on this by adding more tags so we can fin relevant projects in the future. These tags will likely reside on one table and if necessary I can move the geographies and diseases to this table. My question is, is there a simple way to select and add several of these tags to the parent record, much like you see on numerous websites, including the field right below where I am typing now(!)? I am aware there is a wizard which sets up a button but I've only got the Essentials package which doesn't allow this. I'm not averse to upgrading if this is the right solution but wanted to throw it out there first. Thanks in advance
Add-On to allow annotation of PDF File Attachment in QBase
Does anyone know of an add-on to Quick Base that either allows direct annotation and markup to a PDF within Quick Base or allows you to open it and auto save it back to the file attachment field? We switched from Wrike and one feature we all loved was that we could open an attachment with a system and make notes. It would auto safe to the record when closed vs having to download, annotate, and upload. I know it sounds trivial but with what we do we review PDF's and JPG's ALL DAY LONG and the constant download/upload takes up a lot of time and is a bit annoying. Thanks! Hope everyone is staying safe and healthy! ------------------------------ Ivan Weiss ------------------------------Form Data to HTML Page
I have a need to get certain field data from individual record ID's to an HTML page that was created by making an Excel sheet into HTML code. This code page has the accurate field references in it already that exist in the form. I have been told that I need to do API_DoQuery. I have never done this before. In a nutshell, this is for a ticketing system app for service that I created and I want to get the form data to this HTML page to create an invoice when the ticket is billable to the customer. So hours worked on the issue, the companies bill rate, the requestor detail, etc.. It would be great to have a URL button that does this from the ticket/form and generates the invoice once clicked in a new window. I am trying to avoid using a separate vendor or company to create this. Any help is appreciated. ------------------------------ Joshua Case ------------------------------
Web Form HTML Wizard To ADD Record for Internet Users
We are using a web form containing the HTML Wizard with the API Add Record to add records to a table in Quickbase.My question is how do I get the web user to see the results that QB calculates. At present I have created a Thank You form in QB Forms.As soon as the record is created in QB the Thank You Form is displayed ( with different calculated results for each record) ( In QB) .However,when the record is added using the web form I am not sure what URL to redirect to so the web user can see the results pertinent to their record. My question is two fold 1) What URL to redirect to .I know the url has some dynamic fields which change each time a record is created 2) Can this also be achieved with the APIGetRecordAsHTML. Can someone please guide me.I have the submission working ,the results are accurate in qb....the issue is displaying the Thank You page with the results and/or fetching the record as html and displaying
