Forum Discussion
Try this
List("\n",
[Main Contact],
[Invoicing Contact]
[Second Contact])
or else
var text AllContacts =
List("\n",
IF(Trim([Main Contact])<>"", "Main: " & [Main Contact]),
IF(Trim([Invoicing Contact])<>"", "Invoicing: " & [Invoicing Contact]),
IF(Trim([Second Contact])<>"", "Second: " & [Second Contact]));
IF($AllContacts<>"",
List("\n",
"Contacts",
$AllContacts)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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).
------------------------------
Olena Bilinska
------------------------------
- MarkShnier__You3 years agoQrew LegendSorry, I'm not understanding the question now. Maybe explain with some examples?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- OlenaBilinska3 years agoQrew Member
We 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
------------------------------
Olena Bilinska
------------------------------- MarkShnier__You3 years agoQrew Legend
If 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
------------------------------
Related Content
- 2 months ago
- 2 months ago
- 4 months ago
- 3 months ago