How do I create a conditional field? | Discussions

Expand all | Collapse all

How do I create a conditional field?

  • 1.  How do I create a conditional field?

    Posted 05-15-2017 03:40

    does anyone know what the rule would be for something like this?  

    • if this checkbox is checked, make these fields required
    • if this checkbox is unchecked, make these same fields NOT required 


    or even better - 

    • if this checkbox is checked, REVEAL these fields and make them required
    • if this checkbox is unchecked, HIDE these same fields and make them NOT required


  • 2.  RE: How do I create a conditional field?

    Silver
    Contributor
    Posted 05-15-2017 05:14
    What are you asking? How to apply these rules or what is the best way to apply the above conditions?


  • 3.  RE: How do I create a conditional field?

    Posted 05-15-2017 05:15
    I guess both because i'm still really new to quickbase! 


  • 4.  RE: How do I create a conditional field?

    Posted 05-15-2017 05:18
    i saw this formula but i'm not sure if it is right.

    IF(([Status]="Completed"),[End Date]-[Start Date],Today()- [Start Date])

    I need to know how to change "[End Date]-[Start Date],Today()- [Start Date])" to something that allows me to pick a particular date instead of a standard date formula. Is that possible?


  • 5.  RE: How do I create a conditional field?

    Bronze
    Contributor
    Posted 05-15-2017 05:21
    You are talking about dynamic form rules.

    https://www.google.com/search?q=quickbase+dynamic+form+rules&oq=quickbase+dynamic+form+rules&...

    You also should know that these are very straightforward to set up in forms, but there's a BIG loophole in QuickBase around the fact that grid edit or API calls will not have access to those rules, so users could circumvent your business logic as stated above. The form entry can lock them down to what you want, but not grid edit. This is the single biggest thing I wish QB would address, as table validation rules should be independent from forms and tied to the table setup more directly.


  • 6.  RE: How do I create a conditional field?

    Posted 05-15-2017 05:48
    Create a formula field checkbox 

    Condition should be like eg: if(condition, 1,0)

    Then go to forms- click on dynamic rules - Create a new rule

    If Formula Checkbox is checked then create the actions like this , make the field as required[what ever fields that you need to make it as required] , also automatically reverse action will be created by quick base itself , you can see on Otherwise Heading below actions on corresponding rule.