Discussions

Back to discussions
Expand all | Collapse all

Dynamic Form Rule based on Master Table Multi-Select Field does not work

  • 1.  Dynamic Form Rule based on Master Table Multi-Select Field does not work

    Posted 06-28-2018 06:26
    I have a master table Client.
    I have a details table Merchant Accounts (MIDS for short).

    One Client has 1-to-n MIDS.
    Client has a multi-select field: Services

    My goal:
    • Based on the value of Client - Services, hide a field in MIDS form.

    What I've done so far:
    • Define 1-to-n relationship from Client to MIDS.
    • Added Client - Services as a lookup field.
    • Client - Name by default was added as a lookup field and a reference proxy.
    • MIDS Main Form, tried adding a dynamic rule based on Client - Services lookup field.
    • I get an error: "There are no compatible fields".
    Here are the screenshots:


    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1737881/RackMultipart20180628-21612-mq2bfl-QuickbaseError-1_inline.png?1530167154">



  • 2.  RE: Dynamic Form Rule based on Master Table Multi-Select Field does not work

    Posted 06-28-2018 09:35
    I suggest making a formula Checkbox field to evaluate your condition and using it in the form rule

    For example a field called [Cats?]

    Contains(ToText([Select all your favorite pet types]), "cats")