Prevent duplicate record entries using a webhook

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • In Progress
I have an issue with a webhook. I am using the Import from CSV to enter records in a table. In my projects table I have a series of checkboxes based on equipment type. I simply check each box by each equipment type and that inturn enters a record in my equipment table with the related ID of the project, the project type and the equipment description. All is working with the exception that if I forget to check an equipment type, check another box and save, it not only make the new entry, but it duplicate the previous entry. Not sure how to add code to this webhook to prevent that from happening.

I tried creating a unique field of information in the equipment records to prevent duplicates but the webhook is looking at anything in that filed, is finding duplicate information and stops dead in its tracks

The other issue is even if a box is not checked it will post a line item in the table without the equipment description or a related ID. I created an automation that runs right after the save to cleanup those records but am sure there is some coding for the webhook to prevent this as well.

Any help or guidance is appreciated...image of webhook coding attached

Photo of Joey Zint

Joey Zint

  • 1,870 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBase Girl

QuickBase Girl

  • 658 Points 500 badge 2x thumb
I would love to know this too.