Trigger a conditional group of actions based on a specific field of a created record. Getting around the 10 action/table limit.
This is a bit of a complex use case, so I'll try to break it down in a clear way:
I have a table, projects, which is the parent table to _jobs. _When a _project_ is created, it can have one of about a dozen categories, currently selected with a simple multiple-choice field.
When a project is created and a category selected, I want the system to create a few related jobs in the jobs table with titles coming from a set list of possible titles. I have so far been achieving this using simple quickbase actions, one for each job I need to create.
Here is the problem: I need the jobs created to be different based on the category selected. So for example, every time a user creates a _project_ with the _alphabet_ category, I would want the system to create 2 related _jobs_, ___titled alpha_ and _beta_. But when the user creates a project with the _beta_ category, I would want the system to create a only single job titled _beta_.
Right now, each project-job pairing seems like it needs to be an individual quickbase action. But with a dozen categories and over twice that many job titles, this would be a painful task even if quickbase did not limit you to only 10 actions/table.
Is there maybe some way I could do this with webhooks? If possible, is there a way to automate the process so that I can easily manage the list of _job_ titles under each category? I'll take what I can get at this point, but that would make things easier for the end users.
I have a table, projects, which is the parent table to _jobs. _When a _project_ is created, it can have one of about a dozen categories, currently selected with a simple multiple-choice field.
When a project is created and a category selected, I want the system to create a few related jobs in the jobs table with titles coming from a set list of possible titles. I have so far been achieving this using simple quickbase actions, one for each job I need to create.
Here is the problem: I need the jobs created to be different based on the category selected. So for example, every time a user creates a _project_ with the _alphabet_ category, I would want the system to create 2 related _jobs_, ___titled alpha_ and _beta_. But when the user creates a project with the _beta_ category, I would want the system to create a only single job titled _beta_.
Right now, each project-job pairing seems like it needs to be an individual quickbase action. But with a dozen categories and over twice that many job titles, this would be a painful task even if quickbase did not limit you to only 10 actions/table.
Is there maybe some way I could do this with webhooks? If possible, is there a way to automate the process so that I can easily manage the list of _job_ titles under each category? I'll take what I can get at this point, but that would make things easier for the end users.
