Get Date/time
Helloooo quickbase community! I have a question, i need to create a field that saves the exact date and time when another chechkbox field is equal to true, I don't need a log I need to know some fo...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf you are editing on a form, then you can use a Dynamic Form Rule. First make a Date/ Time field called like [Date / Time checkbox was checked].
Then make a form rule,
When Multiple conditions are true
ALL of
[Date / Time checkbox was checked] is blank (just leave blank)
Checkbox field is checked
Action
Change the value of [Date / Time checkbox was checked] to the current date/time.
If it's possible that your users will be checking the checkbox in Grid Edit, hen you will need to set up a Pipeline to do that. Post back if you need help with that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Then make a form rule,
When Multiple conditions are true
ALL of
[Date / Time checkbox was checked] is blank (just leave blank)
Checkbox field is checked
Action
Change the value of [Date / Time checkbox was checked] to the current date/time.
If it's possible that your users will be checking the checkbox in Grid Edit, hen you will need to set up a Pipeline to do that. Post back if you need help with that.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- I need to estimate hours, so my start time is [Date created] and my end time is when [checkbox field] changes = true.
So I need this last hour to subtract it from [Date created].
------------------------------
Herberth Solano
------------------------------- MarkShnier__YouOK, so the start date/time is [Date Created] and the end time is [Date / Time checkbox was checked] .
So to get the number of hours as a numeric formula field type you can subtract and convert to the # of hours.
ToHours([Date / Time checkbox was checked]- [Date Created])
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Is it possible that when [Checkbox field] = true, other fields capture the exact time it was activated ?
For example
if([Checkbox field] = true, now())
But the Now() updates it to the current date, not which one was activated.
Thank you very much Mark!
------------------------------
Herberth Solano
------------------------------
