Quickbase Discussions

 View Only
  • 1.  Today Formula

    Posted 05-25-2022 14:14
    Hi,

    I am trying to write a formula to show today's date when a checkbox is selected. The name of the checkbox field is "Completed".

    Thank you

    ------------------------------
    Fatima Khan
    ------------------------------


  • 2.  RE: Today Formula

    Posted 05-25-2022 14:30
    I can help you with a formula,  but the issue will be that Today keeps changing every day, so that date will change each day to the current date, which is not what you want.

    If all of the data entry is done on a form, then I suggest that you make a Dynamic Form Rule

    When multiple conditions are true
    All of
    when [Completed] is checked
    when [date completed] is blank

    Action
    Change the value of date completed to the current date.

    and uncheck he box at the bottom


    However, if you are entering data in Grid Edit mode, then  Dynamic Form Rules do not apply and you would need to set up an Automation or Pipeline to do this.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Today Formula

    Posted 05-25-2022 14:36
    Thank you,

    I have 2 fields, Completed and Completion Date. I want the Completion Date to automatically be filled to the current date when Completed is checked.

    When i tried the Dynamic form rule Completion Date was not an option.

    ------------------------------
    Fatima Khan
    ------------------------------



  • 4.  RE: Today Formula

    Posted 05-25-2022 14:38
    Change the field type for Completion Date to be a Date field, not a formula date field.  Then it will be available to be populated by a Dynamic Form Rule.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Today Formula

    Posted 05-25-2022 14:45
    Thank you,

    That is exactly what I needed to do. I appreciate your help.

    ------------------------------
    Fatima Khan
    ------------------------------