Discussions

 View Only
  • 1.  Very confusing issue

    Posted 01-15-2022 16:26
      |   view attached
    Here it goes. Trying to figure out why one table relationship works one way for a report link and another another table relationship doesn't. Tables we will look at:  JOBS, SUB PAYROLL, ORDERS.  Background info:

    1.  Using COPY JOB button.  This was created many many years ago.  I have no memory of where I got it.  I am attaching a document because when I try to paste here, I get kicked out.

    2.  JOBS to SUB PAYROLL -

    3.  SUB PAYROLL to JOBS -
    RESULT:  NEW JOB NUMBERS (after copied from "template) "connect" automatically and shows this report on the JOBS form  -

    NOW for ORDERS -
    JOBS to ORDERS -

    ORDERS to JOBS -
    RESULT:  NEW JOB NUMBERS (after copied from "template) "DO NOT connect" automatically and shows this report on the JOBS form  -


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

    Attachment(s)

    docx
    javascript.docx   11 KB 1 version


  • 2.  RE: Very confusing issue

    Posted 01-15-2022 17:02
    In essence....I am trying to figure out how a new job (from copied template) automatically appears in SUB PAYROLL, but not in ORDERS?

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



  • 3.  RE: Very confusing issue

    Posted 01-15-2022 18:04
    Although you posted the JavaScript code, that is simply calling a code page. Typically you need a real developer to make changes to a code page. I suppose you could post the code page but it's probably unlikely that anyone on this forum will assist.  You will probably have to contract with a Quickbase solution provider to get help.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: Very confusing issue

    Posted 01-15-2022 18:57
    Thanks, Mark.
    This actual coincides with our previous discussion.  Do you think this code has something to do with the reason that JOBS seem to connect automatically with SUB PAYROLL, but not ORDERS?  I can't seem to identify the field that "adds" the job to SUB PAYROLL automatically.  I have to manually click "add order" to "connect" to JOBS

    Also, there is no RECORD# field in JOBS.  Only a TASK ID# (key field).
    The KEY FIELDs in both SUB PAYROLL and ORDERS is the RECORD ID#

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



  • 5.  RE: Very confusing issue

    Posted 01-15-2022 18:58
    Any referrals for a developer?

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



  • 6.  RE: Very confusing issue

    Posted 01-15-2022 19:49
    Sure, contact me directly be email.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Very confusing issue

    Posted 01-15-2022 20:44
    Will do.  thank you

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