Hmm, I tried. Unfortunately, this formula not displaying the values.
Maybe I explained it a little bit wrong.
So I have a report and all those fields (Main Contact and etc.) have to be fill in. After they filled I need to have them displayed beyond (to keep track on who worked on the report).
Qrew LegendWe have records on table A (claims) with several lookup fields from table B (contacts), which are outlined previously
so what we're trying to accomplish is copying the values in these fields to another text field (historical purposes), but only when records on table A is approved
sometimes those records are reopened and re-approved later on, so we would like to have another snapshot of those contact fields appended to the historical field, rather than replacing them
Hopefully it makes sense now
Qrew LegendIf 100% of your data entry is on Forms, as opposed to say Grid Edit, then I suggest that you set up a new set of fields matching the ones you want to Log Changes to.
Set the field priorities to log changes.
Make a Form rule that says,
When the record is saved
And the Approval status is changed to Approved
Change Main Contact Log field to the value in the field Main Contact.
Change Second Contact Log field to the value in the field Second Contact.
etc
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
