Forum Discussion
A solution is to have a form rule to "dirty" the record when opened for edit, using a form rule. I make a numeric field and another field with a formula of that numeric field +1, then a form rule to change the data entry field to the value in the formula field. But it does mean that the record will get dirtied when no real change ws made, if the user was just "looking" in edit mode..
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
To echo Marks point - you can similarly do a date/time that is always being set to 'now' by a form rule but it will mean that if a user saves without changing anything else QB will still save that field as a change. If your workflow would allow for it - you could modify it where the user checks a box or completes some other step before they upload. For example I have a prior use case where a file was required for closeout before they could submit - to which we just made a checkbox for 'Ready to Submit' that made it seem as if they were unlocking some additional process that then required the file before they could leave. Wasn't ideal but it provided a workflow that seemed semi-natural in the overall process.
------------------------------
Chayce Duncan
------------------------------