Help finding solution for either a webhook or automation
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.
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.
