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>
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.
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 ------------------------------
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?
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.If I enter an invoice and inventory is negative, will COGS be recorded?
We have a situation where inventory was being increased through Item A and the sale to the customer was being recorded to Item B. This caused Item A to be hugely over stated and Item B to be understated. To fix this, the first step was to correct the original purchases to Item B. Now, the quantity is right but the $ are way over valued. My theory is that since the inventory value was negative, QB relieved more quantity through the invoice transaction, but COGS was $0. Now that we've fixed the original purchase, that invoice is still incorrect. I think we need to delete it and re-enter it. In addition, this company has just in time inventory (they order from a co-packer and sell to retailers through drop ship wholesale orders). I believe some of the invoices were recorded before the bills from the supplier which would increase inventory. The bookkeeper was ignoring the warnings that there isn't enough inventory to fulfill the orders. So, I think the same thing happened on the financials (COGS had a $0 value). Are my theories correct and is the solution to validate that inventory purchases need to be completed prior to items being sold and is the solution to get that right first, then delete and re-enter the invoices, then apply the payment made from the original invoice to the newly created invoice?
