Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Need help with creating a pipeline

I need a link from one table to a record (form) in another table and I can't seem to get a pipeline to work.

For Example:
I am in MATERIAL ORDERS table, record 204.PJD
While in this record, I need a button to link directly to 204.PJD in ORDERS table

Need a pipeline to automatically make this happen when OPTS VERIFIED (lookup field from JOBS table) is updated in the Jobs table.

------------------------------
BuildPro
------------------------------
  • BrianSeymour's avatar
    BrianSeymour
    Qrew Assistant Captain
    3 years ago

    Are Material Orders and Orders related under the hood?

    If so, can you make Form Rule that shows button link when the lookup field has a value?

    Otherwise, it sounds like you'd want check out the Pipeline Search Records step in the Pipelines Channel to find the relevant records, then loop them (even if there is only one) and update the link value. Worthing mentioning that Formula URL field may be of use in conjunction with a stored ID to form a link to the Order. In other words, store the minimum necessary information, you likely don't need to store a full link, as the majority of the link will be the same in all cases, it's likely just the ID at the end of the link that differs (e.g. &rid=123)

    But without understanding more about your schema, it sounds like this should be handled via relationships (with a lookup link) vs. Pipelines.



    ------------------------------
    Brian
    ------------------------------