Timestamp a Checkbox

Question

I am looking to timestamp a checkbox that will be edited in Grid Edit (so a form rule is not an option). Is there a formula I can use in another field to timestamp the user/date? A lot of results I am finding suggest an automation but those aren't available anymore. I'm scared of the P word (pipeline) but I'll figure it out if a formula isn't available. Thanks!

------------------------------
Cheryl Huie
------------------------------

markshnier__you · Answer

"P" is your only option for Grid Edit situations. Jump in. The water's fine.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

cherylhuie · Answer

Okay, I will try it out. Thanks------------------------------Cheryl Huie------------------------------

prashantmaheshw · Answer

If you are scared of 'P' , You can consider 'A' aka QuickBase 'Actions' (they are arcane , but boy they are fast).

I have a formula field with value now() , I run an action which simply copies the value from formula field to timestamp field.

------------------------------
Prashant Maheshwari
------------------------------

markshnier__you · Answer

Yes,, brilliant, we tend to forget about Actions. &nbsp;It was a direction that QuickBase was going in to make Webhooks more approachable &nbsp;and non technical. &nbsp;So an Action is really a Webhook with a pretty face. &nbsp;And yes, they fire truly instantly and natively with no fancy intercession to external Pipeline engines.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

barrydolan · Answer

I'm having issues with using Now(). I'm finding that it is a dynamic value that always shows the current date &amp; time when refreshed. I apparently can't use Actions because I'm trying to update a field in the same form. When I check a box I need a field to record the time/date and user who checked the box. I can do this with a formula but it's not a static value and keeps updating on a page reload. I get the same results by using a mirror field. So I resulted to using a pipeline and it works fine, except you can't see the value until the page is reloaded. It works but not quite like I need it to. This seems like it should be easier to achieve and I feel like I'm overlooking something, like I can't see the forest because I'm too close to the tree!
------------------------------Barry Dolan------------------------------

Forum Discussion

Timestamp a Checkbox

7 Replies

Related Content

Convert timestamp to Date/Time

Pipeline Jinja based on current timestamp

Autofill user field when a checkbox is checked

Checkbox in Docusign

Defaulted checkbox

Recent Discussions

Create Child Record, Save and then Edit button

Updating predecessors in a pipeline

Error - Invalid record data provided when executing form rules

Formula using Contain

Dynamic Form Rules