Forum Discussion

OlenaBilinska's avatar
OlenaBilinska
Qrew Member
2 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.

------------------------------
Olena Bilinska
------------------------------
Form Rules
Formulas and functions

6 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 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
      2 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
        Qrew #1 Challenger
        2 years ago
        Sorry, I'm not understanding the question now.  Maybe explain with some examples?

        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------