Getting Started

 View Only
  • 1.  How to get values from a fields on the form and display them?

    Posted 08-09-2022 10:26
    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
    ------------------------------


  • 2.  RE: How to get values from a fields on the form and display them?

    Posted 08-09-2022 15:38
    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
    ------------------------------



  • 3.  RE: How to get values from a fields on the form and display them?

    Posted 08-09-2022 16:44

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



  • 4.  RE: How to get values from a fields on the form and display them?

    Posted 08-09-2022 16:48
    Sorry, I'm not understanding the question now.  Maybe explain with some examples?

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



  • 5.  RE: How to get values from a fields on the form and display them?

    Posted 08-09-2022 17:04

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



  • 6.  RE: How to get values from a fields on the form and display them?

    Posted 08-09-2022 21:50

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



  • 7.  RE: How to get values from a fields on the form and display them?

    Posted 08-10-2022 10:39
    Thank you, Mark! Will try!

    ------------------------------
    Olena Bilinska
    ------------------------------