Forum Discussion

RajeevShukla's avatar
RajeevShukla
Qrew Member
5 years ago

Condition on Lov

Hi Team,

Please suggest possible ways to achieve below Case

- I have two Text - Multiple Choice field
1. Status with LOV (Yes/No)
2. Method with List of values (Sample 1/Sample 2/ Sample 3/ Sample 4 /Sample 5/ Sample 6).

Condition :

If  Status = No than List of values of Method Fields should appear in form will be (Sample 1/ Sample 4 /Sample 5) .

Let me know any ideas on the same .

------------------------------
Rajeev Shukla
------------------------------
roles and permissions
Tables and fields
  • UrsulaLlaveria's avatar
    UrsulaLlaveria
    Qrew Assistant Captain
    5 years ago
    Hi There, 

    I am not sure if there is a way to do that native in QB. However, another solution would be to have two fields, one for if No (status 2,4, 6) and one for yes (status 1,3,5). Display the different fields based on the choice, then have a "master" field that pulls in whatever option is chosen to use for displaying.

    ------------------------------
    Ursula
    ------------------------------