Original Message:
Sent: 08-09-2022 21:50
From: Mark Shnier (Your Quickbase Coach)
Subject: How to get values from a fields on the form and display them?
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
Original Message:
Sent: 08-09-2022 17:04
From: Olena Bilinska
Subject: How to get values from a fields on the form and display them?
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
Original Message:
Sent: 08-09-2022 16:48
From: Mark Shnier (Your Quickbase Coach)
Subject: How to get values from a fields on the form and display them?
Sorry, I'm not understanding the question now. Maybe explain with some examples?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-09-2022 16:44
From: Olena Bilinska
Subject: How to get values from a fields on the form and display them?
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
Original Message:
Sent: 08-09-2022 15:37
From: Mark Shnier (Your Quickbase Coach)
Subject: How to get values from a fields on the form and display them?
np,
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
Original Message:
Sent: 08-09-2022 10:26
From: Olena Bilinska
Subject: How to get values from a fields on the form and display them?
I'll have a form with Main Contact(text), Invoicing Contact(text), Second Contact (text) and etc. Need to find a way to store all this information in one field and display it on a form.
------------------------------
Olena Bilinska
------------------------------