Discussions

Expand all | Collapse all

Different Field Reference depending on value

  • 1.  Different Field Reference depending on value

    Posted 08-27-2020 16:36
     
     
    The formula below works to list top 5 customers input in a table field into a form field I need but
    at the end it says "No GC's have been identified for this Project") when the table is empty.
     
    I need it to first reference the field called "Awarded Contractor" or the "JOB Number" fields.
    If either of these fields has a value then the only value in the Bidding GC field should be the Awarded Contractor field value.
     
     
    Any ideas on what should be changer in the formula to reference these fields?
     
    Thanks
     
     
     
    If(
        Part(ToText([All GC]),5,";")<>"",
            Part(ToText([All GC]),1,";")&" | " &
            Part(ToText([All GC]),2,";")&" | " &
            Part(ToText([All GC]),3,";")&" | " &
            Part(ToText([All GC]),4,";")&" | " &
            Part(ToText([All GC]),5,";")&"...",
     
        Part(ToText([All GC]),4,";")<>"",
            Part(ToText([All GC]),1,";")&" | " &
            Part(ToText([All GC]),2,";")&" | " &
            Part(ToText([All GC]),3,";")&" | " &
            Part(ToText([All GC]),4,";"),
     
       Part(ToText([All GC]),3,";")<>"",
            Part(ToText([All GC]),1,";")&" | " &
            Part(ToText([All GC]),2,";")&" | " &
            Part(ToText([All GC]),3,";"),
     
        Part(ToText([All GC]),2,";")<>"",
            Part(ToText([All GC]),1,";")&" | "&
            Part(ToText([All GC]),2,";"),
     
        Part(ToText([All GC]),1,";")<>"",
            Part(ToText([All GC]),1,";"),
     
    "No GCs have been identified for this Project")
     
     
     
     
     
                     Michael L. Hall | Excavation |  Survey Mgr | RPM xConstruction, LLC
            (O) 214-239-4722 - Ext. 4926 | (M) 972-837-3350 | www.rpmxconstruction.com
            planroom@rpmxconstruction.com | mhall@rpmxconstruction.com | surveying@rpmxconstruction.com
            5208 Tennyson Parkway | Suite 130 | Plano, TX  75024   cleanemail***
     
                  CONFIDENTIALITY NOTICE - The information contained in this transmission, including attachments, may be (1) subject to the Attorney-Client Privilege, (2)
                   attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you are notified that you may not disclose, print,
                   copy or disseminate this information. If you have received this transmission in error, please reply and notify the sender (only) and delete the message.
                   Unauthorized interception of this e-mail may be a violation of criminal law.
     
     
     
     
     
     
     
     
     


  • 2.  RE: Different Field Reference depending on value

    Posted 28 days ago
    Michael -

    Is your intent to convert the [All GC] field to text and list out the first 5 values, separated by "|", unless there is a value in the [Awarded Contractor] or [Job Number] fields, then show that field?

    If so, then I would suggest massaging the original formula a bit and use something along these lines:

    Case(True,
              [Awarded Contractor]<>"",[Awarded Contractor],
              [Job Number]<>"",[Job Number,
              List(" | ",Part(ToText([All GC]),1,";"),
                            Part(ToText([All GC]),2,";"),
                            Part(ToText([All GC]),3,";"),
                            Part(ToText([All GC]),4,";"),
                            Part(ToText([All GC]),5,";")))


    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------



  • 3.  RE: Different Field Reference depending on value

    Posted 28 days ago
    It seems to want to give me an error. Its wanting a bracket or another comma but neither are working for me.
     
    Case(True,
              [Awarded Contractor]<>"",[Awarded Contractor],
              [Rpmx Job Number]<>"",[Rpmx Job Number,
              List(" | ",Part(ToText([All GC]),1,";"),
                            Part(ToText([All GC]),2,";"),
                            Part(ToText([All GC]),3,";"),
                            Part(ToText([All GC]),4,";"),
                            Part(ToText([All GC]),5,";")))
     
     
     
     
                     Michael L. Hall | Excavation |  Survey Mgr | RPM xConstruction, LLC
            (O) 214-239-4722 - Ext. 4926 | (M) 972-837-3350 | www.rpmxconstruction.com
            planroom@rpmxconstruction.com | mhall@rpmxconstruction.com | surveying@rpmxconstruction.com
            5208 Tennyson Parkway | Suite 130 | Plano, TX  75024   cleanemail***
     
                  CONFIDENTIALITY NOTICE - The information contained in this transmission, including attachments, may be (1) subject to the Attorney-Client Privilege, (2)
                   attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you are notified that you may not disclose, print,
                   copy or disseminate this information. If you have received this transmission in error, please reply and notify the sender (only) and delete the message.
                   Unauthorized interception of this e-mail may be a violation of criminal law.
     
     
     
     
     
     
     
     
     





  • 4.  RE: Different Field Reference depending on value

    Posted 28 days ago
     
     
     
     
                     Michael L. Hall | Excavation |  Survey Mgr | RPM xConstruction, LLC
            (O) 214-239-4722 - Ext. 4926 | (M) 972-837-3350 | www.rpmxconstruction.com
            planroom@rpmxconstruction.com | mhall@rpmxconstruction.com | surveying@rpmxconstruction.com
            5208 Tennyson Parkway | Suite 130 | Plano, TX  75024   cleanemail***
     
                  CONFIDENTIALITY NOTICE - The information contained in this transmission, including attachments, may be (1) subject to the Attorney-Client Privilege, (2)
                   attorney work product, or (3) strictly confidential. If you are not the intended recipient of this message, you are notified that you may not disclose, print,
                   copy or disseminate this information. If you have received this transmission in error, please reply and notify the sender (only) and delete the message.
                   Unauthorized interception of this e-mail may be a violation of criminal law.
     
     
     
     
     
     
     
     
     





  • 5.  RE: Different Field Reference depending on value

    Posted 28 days ago
    You'll need to complete the bracket for that field



    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------