Help finding solution for either a webhook or automation

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
  • (Edited)
I am working on developing an application in which we will be getting data from another company dropped into our QuickBase App that has 187 fields at this time. This information consists of data from a home inspection, and possibly up to 114 different line items. My tables are setup in the following manner: Inspection which is a child table of Applicants, Line items which is a child table of Inspections, and pick list which is the parent table of Line items (this table has all possible items that can be used on the Line items, so it has a drop down on the Line Items table.

I need to create an automatic process, so that when we get inspections dropped into our application it creates a record on our Inspections table which is related to the Applicant on the applicants table, and then adds all line items that are not blank to the line items table and relates it to the inspection. The fields for the line items in the inspections we get from this other company have the quantity of the items, so the process needs to see if blank skip over that possible line item and if the field has a value create a line item record with the value in the field populated in the quantity field on our line item table but it also needs to trigger the related pick list item at the same time. Does anyone have any suggestions? 

QuickBase automation does really well with he process however it caps out at 50 actions and it cannot skip line items that are blank which is fine since I can create a webhook to purge records with quantity 0.
Photo of Anthony Zuvich

Anthony Zuvich

  • 70 Points

Posted 6 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 52,928 Points 50k badge 2x thumb
This sounds complicated enough that it will need a script to automate.  Even if you could automate this with a few webhooks, if these records get imported, I think that you would end up exceeding the rate at which webhooks can fire, which is a rate of 10 per second.

If you contact me via the information in my website, I can recommend a couple of QSPs (Quick Base Solution Providers) who could do this type of work.