Forum Discussion

Re: Time Stamp for Start of New Entry

OK, yes, I just did a test and was quite surprised that it changed the value of that field during the saving process.  I'm sure it is a feature and not a bug.  :)

So np, try Plan B.

make a new formula date / time field called [Current Date / Time] with a formula of
now()

Uncheck the setting on the [Date /Time form started] so that it is required but not unique and not defaulted to now.

make a form rule

When [Date / Time form started] is blank

change [Date / time form started' to the value on the field [current date/ time]

uncheck to fire all the time

If that does not work, I have Plan C, but it does seem to work for me.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

1 Reply

  • AmberAnderson's avatar
    AmberAnderson
    Qrew Trainee
    FANTASTIC! This seems to have done the trick! Thank you so  much for your help!
    make a new formula date / time field called [Current Date / Time] with a formula of
    now()

    Uncheck the setting on the [Date /Time form started] so that it is required but not unique and not defaulted to now.

    make a form rule

    When [Date / Time form started] is blank

    change [Date / time form started' to the value on the field [current date/ time]

    uncheck to fire all the time
    Mark Shnier (YQC),  06-29-2020 18:30


    ------------------------------
    Amber Anderson
    ------------------------------