Auto Numbering unique inventory items by department?
As we enter new items into our inventory database we would like it to automatically increase the inventory by 1. We have several departments and each number should increment based on the department number Expample 10-000111 would be one department 20-000234 would be a second department The format has been used for many years and it would be difficult to change it. Also, we must start with the most current number for each department.
How to I properly get a webhook to fire for AddRecord?
I am just trying to figure out basic Webhooks. I want to trigger a webhook when a data record changes in Table 1 to add a record to Table #2. I set everything up with 1. When criteria are all set 2. Endpoint URL goes to the Table #2 3. XML, QuickBase-Action, API_AddRecord 4. I think the Message Body is where I'm goofing up, but I find the "help" too advanced. Any good reading suggests with examples to help me get going? Field 9 is the one to be updated in Table #2, and [Inventory Total] is the record in Table 1 that changed to cause the webhook to fire. <qdbapi> <apptoken>--app token here---</apptoken> <field fid="9">[Inventory Total]</field> </qdbapi>
How do I link to a specific form on the child record from the embedded report on the parent record?
I have two tables: Products (parent) and Inventory Adjustments (child). Inventory adjustments has multiple forms used for different purposes instead of having one main default form. How do I get the embedded report to link to a particular form when viewing or editing? Here's an example of the above: I've created two inventory adjustments. "Order" and "Sale." Both appear on the embedded report on the products table. When I click on "order" I want it to take me to the "order" form. When I click on "sale" I want it to take me to the "sale" form. Is this possible?
Data Dictionary
Our Program Evaluator is asking for a "data dictionary", which is defined as a list of all of the data points in our app. Does qb have a feature that generates this? Or would I print the field view of each and every table? Thanks! Bridget ------------------------------ Bridget Lambert ------------------------------
Creating a search box on a form
I have a table called line items that is linked to inventory and I select the inventory by either its supplier part #, company part # or its description. Is there a way to create a box that will search for any of those value in an inventory item and populate some suggestions. I know I can do it for reports but I need it on my form. Any help would be appreciated.
Field names and labels on Reports and Forms in QB Library Apps not consistent:
I understand that QB does not police or support apps. available in the Library built by customers, but is there Help/Corrections for QB authored apps ? Very frustrating ... seems QB applications should be the best example of what can be done and QB should stand behind apps they make available. This is a recurring problem: here's an example" Downloaded QB 's Project Manager Plus. Between Reports and Forms, fields are not consistent. Examples: "Project Lead" is really a USER but the dropdown is <Add a New Resource> and it doesn't work. The "Contacts" drop down displays a list of "Companies' of "Contacts", not of "Contacts" and again, the <add a new contact> function does not work.
Sample App attachments not copying over (NIST Privacy Framework Manager)
I've been exploring the NIST Privacy Framework Manager app from the sample apps library. It is excellent, except it requires downloading three import files before deleting the sample data so you can recreate the NIST functions, categories, and subcategories. Unfortunately, these files do not seem to copy over. When I click on the links to download them, I get the following error message: 404 error File metadata not found Check the Quickbase service page for more information. Please contact support if you need help. Same error with images used in some of the reporting. Is it expected behavior for attachments to not copy over when you use "get this app" from the sample-apps library? Would anyone have copies of the CSV import files that are supposed to be used with this sample app?
