Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

Pipeline not working

Scenario:
When a date has been entered in the [SYSTEM START] field on the JOBS table,
Create Record in the MATERIAL ORDERS table and populate the [ORDER TYPE] field with DW
AND...
Create a 2nd record populating that record [ORDER TYPE] field with PRIME

NOTE:  [ORDER TYPE] is a Multiple Choice field...is this the problem?

------------------------------
BuildPro
------------------------------

5 Replies

  • When you say 'not working' what do you mean?

    Is it not triggering?
    Is it triggering but not creating the record?
    Is it creating the record but not filling out the order type?
    Are there any errors messages?

    ------------------------------
    Mike Tamoush
    ------------------------------
  • The related job on the second Create Record should be {{a.id}}

    ------------------------------
    Mike Tamoush
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      Pipeline is not triggering

      It doesn't give me the choice

      ------------------------------
      BuildPro
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        If it is not triggering, I am not sure why it isn't. It looks good to me? As long as System Start is being changed, it should trigger. The only thing I can think of, is that you have no fields for subsequent steps. Now, this shouldn't matter at all, but I don't trust pipelines, and sometimes funny stuff happens. Maybe it really wants something in there, even if it isn't used?

        Not sure what you mean 'it doesn't give me the choice'. If you mean, there is no {{a.id}} you can either manually type it, or better yet, expand the A selection there, and you will be given the choice to drag and drop.

        ------------------------------
        Mike Tamoush
        ------------------------------