Create Logs of Child Records with a Webhook?

Question

So I want to keep track of various mixtures that we use and how much of them we use. Each mixture is composed of various materials that are entered when the mixture is made.

What I want to be able to do is when a usage log is created for the mixture, a corresponding material log is made for each material in that mixture.

Say for Example:

"Paint 1" is 50% "Red" and 50 % "Blue", so it has two child records "Red" and "Blue" related to those colors. Now I enter a log that says I used 2 gallons of "Paint 1". When I make that log, I'd like it to automatically create two logs in the materials log table, that say I used 1 gallon of "Red", 1 gallon of "Blue".

I feel like I should be able to do this with a simple Webhook, but I don't think that I can, because I have to search through the "Materials in mixtures" table to find the ones related to that mixture first, and then create records for those, which I don't think is possible in a Webhoook.

Am I missing something here or do I need to just go ahead and make some sort of script to handle this?

anomDiebolt · Answer

My advice might differ from that of others but this will be straightforward to do with script. In my opinion WebHooks are better suited to integrate QuickBase to another external service rather than connecting a trigger and action within QuickBase. But in any case there is confusion concerning how many tables you have and what the existing relationships and fields are in those tables.

I gather that you have a Mixtures table and a Components table in a one to many relationship. I think you also have a Log table of some sort but I have no idea what fields are in this table or how it is related to the Mixtures and Components table.

Can you explicitly describe your existing tables, relationships and fields?

Sign up

Login to the community