Hub: Programming a General Command request

Hi,

Background for our use case:

  • We regularly receive requests from analyst customers asking us to build new SQL tables.
  • To manage this more effectively, we've built a Hub Morph which:
    • Asks the User to upload a structured spreadsheet containing the details of the request, which then
    • A SQL Stored Procedure pieces together the various elements of the request into a functioning SQL script, which then
    • Produces a prototype data table and is presented to the User

The above works well.

The 2nd stage is the slightly tricky bit. At that point we want:

  • The User to click on an 'Approve' button, which then
  • Triggers a module within the Morph to populate a Board with details of the request for our Developers to review and productionise.

Currently:

  • This is achievable using a Row-level Command, as it passes the Column 'workflow_ID' value into the Module. However I think it looks visually confusing for the User, as it looks like it's only applying to one row of the table, which it isn't.
  • Ideally, I want to use a General Command, as it looks clearer and more appropriate, but I don't think I can pass a computed value into the Module this way?

Row-level Command config:

General Command config:

Am I going wrong somewhere? Or is there a workaround?

Thanks as ever.

Alistair

Hi Alistair,

Could you clarify at which stage the workflow_ID is created in your workflow, and whether it is passed to the current asset as a parameter?