Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
Murali,
If all data entry is done on a form, you can have a text field with logging enables and have a form rule
When he record is saved
and
[My field] has changed
Change [My logging] field
to the value in the field [field to be logged]
You may need to have a new field called [My field to be logged in text format]
with a formula of ToText([My field to be logged]])
and use that to be written to the logged field.
If all data entry is done on a form, you can have a text field with logging enables and have a form rule
When he record is saved
and
[My field] has changed
Change [My logging] field
to the value in the field [field to be logged]
You may need to have a new field called [My field to be logged in text format]
with a formula of ToText([My field to be logged]])
and use that to be written to the logged field.
- MuraliGangineni6 years agoQrew CadetIt Worked by using Dynamic Form Rule.
Thank You... - MitchKoyle6 years agoQrew TraineeMark,
I used your suggested above to use a form rule to populate a log edits field. This works great in most cases, but I have a scenario where there is a button on a form that updates the status with one click. When using this button, the form rule + log edits field does not update. Presumably this is because when using a button to update the status the editing isn't truly done on the form. I tried using an automation to update the log edits field, but the owner of the automation is entered as the user in the log edits field, so no dice. Any thoughts on getting around this issue? - QuickBaseCoachD6 years agoQrew CaptainI suggest that adjust the button to also update the logged field.
- MitchKoyle6 years agoQrew TraineeDuh, we seem to always over-complicate things don't we. One line of code was the solution. Thanks!