Skip to main content
Question

Clearing a formula date field

  • September 13, 2024
  • 0 replies
  • 216 views
Forum|alt.badge.img+8

I'm trying to find a solution to clearing 2 formula date fields based on a selection in another drop down field. 

I've tried to set up a form rule for this but it appears the formula date fields aren't showing as an option in the "then" section...what I'm needing is when the user selects case rounds type as MD requested to then clear and hide the 2 formula date fields as they are no longer needed. It will let me hide the field in the form rule, but won't give me an option to clear those fields. 

Not sure if there is a better/different way I should be setting this up?

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • September 13, 2024

You could not change the value of a formula field using a form rule because the formula just always calculates according to the formula. You could change the formula to take into account the form rule conditions, and make it calculate to zero or to blank if some conditions are not met. 

Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+8
    • LB34431
    • Author
    • Quickbase Alumni
    • September 18, 2024

    Thank you! I'm not sure how to structure the formula to not add a date if the case rounds type is = to MD Request

    I do want the dates in the fields to populate in the fields for 90 days date and 180 days date when a date is added to the date of consult field - but I don't want it to add a date to those fields if the case rounds type is selected as MD Request regardless if there is a date entered in the date of consult field. 

    Forum|alt.badge.img+8
    • LB34431
    • Author
    • Quickbase Alumni
    • September 18, 2024

    Or...maybe I can look at it from this angle too...I only need the 90 day and 180 day date fields to populate/calculate from the Date of Rounds field if the case rounds type is = to initial rounds

    Terms & ConditionsAccessibility statement