Forum Discussion

kartiklakshmana's avatar
kartiklakshmana
Qrew Member
11 months ago

syntax for recording completion date

Hi I am trying to set up a scenario. 
i have two fields 1> build complete = checkbox 2> actual build completion date = formula date.
The expectation is when the operator checks the build complete, the date is recorded in the actual build completion date (field)

I tried a few syntax's but i am unable to get the formula correct. Any suggestions?



------------------------------
kartik lakshmanan
------------------------------

1 Reply

Sort By
  • JeremyAnson's avatar
    JeremyAnson
    Qrew Cadet
    11 months ago

    If I've understood correctly, you're looking to set 'Actual Build Completion Date' to the current date when checkbox 'Build Complete' is checked. If you use a formula field - something like If([build complete]=true, Today()) - the field will contain the current date, not the date when the checkbox was checked. You could use a form rule or a pipeline to set the date - I'd suggest using a pipeline as it can be triggered from any record update (from a form update and a grid edit update).



    ------------------------------
    Jeremy Anson
    ------------------------------