How to Deal with More than 10 Webhooks

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
Goodday, we are currently experiencing a design challenge, and would like alternative solutions, as we understand you are limited to 10 Webhooks...currently we are assigning 15 resources to a project at any given time, and we have 15 relationships to the resource table.  The challenge we sit with is we want to now when these resources are allocated in the projects table, and we are currently doing it with webhooks, but have now run out of webhooks, therefore we are looking for a solution to log the allocation date and time simultaneously.
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb

Posted 10 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,456 Points 50k badge 2x thumb
Normally when assigning Resources to a Project you do this though a many to many relationship.

1 Project has many Resource Assignments.
1 Resource has Many Resource Assignments.

If you were will to change your app structure to a arguably "proper" structure, then  you will only need one Webhook or Action and not 15.

The only only option I can see is to have the log table have fields "times 15" to record all the assignments when any of them, changes.  Then you would probably want to have a formula to extract out just the changes into one column.
Photo of Paul Vorster

Paul Vorster

  • 556 Points 500 badge 2x thumb
Hi There, Thank you for responding...I think the solution above will definitely help...the other scenario we have in another table is as follows...maybe the same solution?

I am currently having four relationships between Table 1:Access Premises and Table 2: Wayleaves (Permissions), these relationships are presented in Table 1 as follows:
1. Wayleaves 1
2. Wayleaves 2
3. Wayleaves 3
4. Wayleaves 4

The user has the ability to select 1 or 2 or 3 or 4, or all of them at any given time...we want to capture the date when this field is selected by the user in the following fields:
1. Wayleaves 1 Selected Date
2. Wayleaves 2 Selected Date
3. Wayleaves 3 Selected Date
4. Wayleaves 4 Selected Date

We currently are doing this with 8 web hooks, 4 to update the date, and 4 to remove the date, if the record is de-selected...

We are trying to do all of this in 1 or 2 web hooks?