Different Field Reference depending on value
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 e...
Forum Discussion
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
------------------------------
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
------------------------------
- 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.complanroom@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. Michael L. Hall | Excavation | Survey Mgr | RPM xConstruction, LLC (O) 214-239-4722 - Ext. 4926 | (M) 972-837-3350 | www.rpmxconstruction.complanroom@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.- You'll need to complete the bracket for that field
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
