Forum Discussion

OlenaBilinska's avatar
OlenaBilinska
Qrew Member
3 years ago

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. -----------...
Form Rules
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
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
------------------------------
  • OlenaBilinska's avatar
    OlenaBilinska
    Qrew Member
    3 years ago

    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__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      3 years ago
      Sorry, I'm not understanding the question now.  Maybe explain with some examples?

      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      • OlenaBilinska's avatar
        OlenaBilinska
        Qrew Member
        3 years ago

        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
        ------------------------------